rac@rti.rti.org (Roger Connor) (03/23/91)
I have a ASCII text file that I need to edit inorder to import the
information into dBase. I am using vi/ex/ed/sed as necessary.
The records are as follows:
000001;VENDOR1;PO BOX;CITY1;STATE1;ZIP1;ADDRESS;CITY2;ST2;ZIP2;(000)000-0000;LASTNAME;FIRSTNAME;NET ??*;MANY CHARACTERS OF JUNK TO END OF LINE
Note that NET can be followed by 10, 30, INVOICE, or some other
series of characters.
What I need to do is locate NET*; on the line, and delete the rest of
the line from the semicolon, including the semicolon.
I have tried: g/;NET.*;/s/;.*$// g/\<;NET.*;\>/s/\>.*$//g
and sed -e '/^\C.*;NET.*;\)\(.*)$/s//\1/'
Any suggestions welcome. Please email as I do not normally read this
group.
Thanks VERY much; it's a 4Meg file!!
Roger
--
USENET: rac@rti.rti.org.UUCP \___/ Roger A. Connor, Jr.
landline: (919)541-6285 (O(O) 3211-25 University Station Rd.
/```\ Durham, NC 27705