Search and Replace Question

Discuss DetachPipe.com huge attachment service and DetachPipe attachment management Add On for Microsoft Outlook. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

jring
Posts: 18
Joined: Tue Sep 23, 2003 3:13 am

Search and Replace Question

Postby jring » Tue Sep 23, 2003 3:16 am

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!

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Fri Oct 03, 2003 5:35 am

Hmm.

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


Return to “DetachPipe.com and DetachPipe Add On Support”

Who is online

Users browsing this forum: No registered users and 2 guests