James, et al -- ...and then James Edward Gray II said... % % On Dec 2, 2003, at 10:44 AM, David T-G wrote: % % > insert into table (f1,f2,f3) values (v1a,v2a,v3a),(v1b,v2b,v3b),... ... % >break these lines at the commas like % > % > insert into table (f1,f2,f3) values (v1a,v2a,v3a), % > (v1b,v2b,v3b), % > ... ... % >but I just can't get it :-) % % Try: % % perl -pe 's/\),\s*/),\n/' old_file.txt > file.mod
Perfect! I had forgotten about -p and so was busy spending all of my time with the spaceship operator and $_. % % It's pretty naive, but I may get lucky. ;) Not at all; I should have been able to figure it out myself :-) % % James Thanks again & HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
pgp00000.pgp
Description: PGP signature
