Here's a question for y'all
How would I take a file with lines that looked like this:
"A B C Company Incorporated"
"X Y Z University"
"Hospital 1 2 3 of State"
And Convert it to this:
"ABC Company Incorporated"
"XYZ University"
"Hospital 123 of State"
Seems simple enough, but I can't for the life of me figure it out!
Search and Replace Question
Moderators: DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2261
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Hmm.
Try a pattern of
([A-Z0-9][ ])+([A-Z0-9])
add a subfilter to remove all spaces.
Try a pattern of
([A-Z0-9][ ])+([A-Z0-9])
add a subfilter to remove all spaces.
Regards,
Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments
Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments
Who is online
Users browsing this forum: No registered users and 1 guest