How to trim data

[jmh8981]

Hi,

Please guide on below,

input is - select col-1, col-2 from table where col-3<="date";

Required output- select col-1, col-2 from table;

[gawa · Accepted solution]

@jmh8981 

Hi, I think Regex tool would help. See my WF s attached. I prepared my WF so as to cater the SQL query without "WHERE" clause.

[jmh8981]

thank u it works.