For The String Extraction Experts

J

Jeff C

I am trying to parse a single field to clean up an old database of addresses
for a friend.

How can I remove the word "and" as in John and Jane Doe while preserving the
fields that have "John's Automation Service"??


Thank you in advance
 
O

Ofer Cohen

If you are going to update the existing data, please back up your data first.

Try with the use of the Replace function to replace the " and " word with
empty value ""

Replace([FieldName]," and " , "")
 
Top