Need help sorting a txt files contents
Posted: Fri Feb 18, 2005 11:52 am
I have a text file that has a name type of data on every line then 2 blank lines and then another couple lines of data (not the same number)
so it looks like this:
Name
Street
Address
Phone Fax
Website
Name2
Street2
Address2
Phone Fax2
Website2
comments2
Name3
Street3
Address3
Phone Fax3
Website3
And i want to take that data and make it into a txt file line seperated by a | (not a comma since commas are in the adress fields)
so it would read
Name|Street|Address|Phone Fax|Website
Name2|Street2|Address2|Phone Fax2|Website2|comments2
Name3|Street3|Address3|Phone Fax3|Website3
Any help would be appreciated
so it looks like this:
Name
Street
Address
Phone Fax
Website
Name2
Street2
Address2
Phone Fax2
Website2
comments2
Name3
Street3
Address3
Phone Fax3
Website3
And i want to take that data and make it into a txt file line seperated by a | (not a comma since commas are in the adress fields)
so it would read
Name|Street|Address|Phone Fax|Website
Name2|Street2|Address2|Phone Fax2|Website2|comments2
Name3|Street3|Address3|Phone Fax3|Website3
Any help would be appreciated