elixir_sinari,

Can u please explain this to me as to what exactly are you doing here as this bit as this is working finally....

Now, the bigger question...why cant we do this using SED ? I got it working up to the last portion as below -

Code:

/Users/ManoharChandran 00:37:37 $cat ANOTHER | grep 'INSER' | sed 's/) VALUES/,NEWCOLUMN) VALUES/g'
1389675	Opera_ShirtCatalog INSERT INTO Opera_ShirtCatalog(COL1, COL2,NEWCOLUMN) VALUES (1, 'TEST1'), (2,'TEST2');
1389685	Opera_ShirtCatlog_Wom INSERT INTO Opera_ShirtCatlog_Wom(col1, col2, col3,NEWCOLUMN) VALUES (9,'Siz12, FormFit', 'Test');

The only pending thing in the above statement is mark up the first set of numbers and move them inside the closing brackett ... can u please come up with something on that line as that is what I need. Also, that is the reason as to why I titled it as REGEX help coz I couldnt come up with the mover for the closing bracket when there are more than one closing brackets

I understand as I did not get what you are doing inside the awk statement in here ...

Btw, thanks a lot for your help !

regards,
Manohar.