|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
|
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
I think each line has a paragraph marker at the end of the line. Go to find & replace, in the find textbox type ^p and in the replace box type , [if that is the delimiter you want], now your document will hvae commas at the end of each line. This is the easiest way to tokenize.
|
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Require Some string Manipulation Help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
![]() |
|