Delete Specific Text Strings in a Field

[JET]

I have a text field that I want to remove specific text strings from.
For example:
Work Order ListtasksCAT5, Connect CCC Internet, Connect Cable, Connect PH Fiber, DRIVE TIME, Deliver STB (3), MK+MISC ADVERTISING,

I want to specifically remove all instances of the words CAT5, CONNECT, DRIVE TIME, DELIVER from all records in the table to shorten its length.

This is a self taught project that i've been able to stumble my way through quite well, but for the life of me i can't seem to find out how to accoplish this.



Thanks in advance for any possible help in the matter.

[pbaldy]

You can use an update query with the Replace() function.

[JET]

Thanks for such a speedy reply.

That was the path i was taking. I've succesfully got it to work with one string of text, but can't figure out how perform this for the other 4 or so strings i want to remove.

Do I just input the same code with different criteria in separate columns for each string?

[pbaldy]

If it's a one-time thing you can just run the query once for each string. You can also nest Replace() functions, along the lines of:

Replace(Replace(FieldName, "abc", ""), "def", "")

[JET]

It will have to be performed repeatedly as new data is imported.
Looks like the nested replace will fit the bill.
Thank you very much for the help.

[pbaldy]

Happy to help, and welcome to the site!