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

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

Search and Replace Question

Post by 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: 2230
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by 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

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest