
December 5th, 2003, 04:28 AM
|
|
Registered User
|
|
Join Date: Dec 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Require Some string Manipulation Help
I nee some string manipulation Help::
I have a large file in the office that has about 100 records of employees as below
John Doe
1, Driveway
UTAH 33661
Phone: 45654654
FAX: 654654654
Jane Doe
2, Park Lane
Virginia
Phone: 6545654
FAX: 654654654
I want all this to come on one line as follows(one person per line) separated by a semicolon or some such demarker. I can then take this in excel and save i hope!
John Doe;1, Driveway;UTAH;Phone: 45654654;FAX: 65465465
Jane Doe;2, Park Lane;Virginia;Phone: 6545654;FAX: 654654654
There are several empty lines between the addresses as shown above.
Is it possible?? Help this is urgent!
Raj
|