Search and Replace Question

[jring]

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!

[DataMystic Support]

Hmm.

Try a pattern of

([A-Z0-9][ ])+([A-Z0-9])

add a subfilter to remove all spaces.