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 replace ...

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, '', -- comment It didn't ...

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\space ...