Page 1 of 1

modify lines

Posted: Wed Mar 15, 2006 5:04 pm
by dabombst
Hi

I need help deleting a files with these lines...

1120,"Alvarez, Carlos","6076","Non-Responsive","6075","Autoriz Operac 1117,"Alvarez, Carlos","6073","Responsive","6073","Msg0020_DCF Plan
6,"Alvarez, Carlos","1013","Non-Responsive","1013
176,"Gabarro, Salvador","2200","Non-Responsive","2200","Essexcel.pdf"

after deleting I need the each line to look like this...
6076","Non-Responsive","6075","Autoriz Operac
6073","Responsive","6073","Msg0020_DCF Plan
1013","Non-Responsive","1013
2200","Non-Responsive","2200","Essexcel.pdf

thanks for the help
stan

Posted: Wed Mar 15, 2006 5:37 pm
by Bob Hansen
Looking to delete everything from beginning, up to and including the third "
Is that correct?

Posted: Wed Mar 15, 2006 5:54 pm
by dabombst
yes sir

Thanks

Posted: Wed Mar 15, 2006 8:03 pm
by Bob Hansen
Search for:
^([^"]*"){3}

Replace with nothing

Posted: Wed Mar 15, 2006 10:27 pm
by dabombst
that work and Thank You for the quick reply. :P