Replacing Middle Initial

[tjb24]

I'm trying to write a regualr expression to delete the middle initial in a flat file that also contains names without initials.

Example:
John C Doe
Jane Doe

Any help?

[mrainey56]

These might work, depending on what other text is in your file.

Regular expression search, match case

Unix Style:
Search: ([A-Z][a-z]*) [A-Z] ([A-Z][a-z]*)
Replace: \1 \2

UltraEdit Style:
Search: ^([A-Z][a-z]+^) [A-Z] ^([A-Z][a-z]+^)
Replace: ^1 ^2

[tjb24]

Thanks! That works perferctly. Did I mention how much UltraEdit rocks!