Community

Ben,

I tried it again and it works perfectly. I think as you mentioned something added when I was copying from web to tool.

Thanks a lot and I never thought of this solution, since I was struck that I should be handling them as individual cases....

By the way do we have any answer for how to ...

Ben,

I tried following things and it didn't work.

Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

Tried to do your find and replace for following sample data and it didn't work.

a.column1,
a.column2,
'',
1, -- comment,
'', -- comment,
'', -- comment ...

Hi,

I am trying to find and replace following comma(,) and rest of the line on following three situation of select query and i got struck at the replacement speicification.

1) Line ended with comma(,)
Example: a.column3,
2) Line ended with spaces( ) after comma(,)
Example: a.column,\space ...