Replace Function with Table Lookup

[smurof]

I have several records that contain very similar substrings, such as "billable edits" and "edits- billable" that I am trying to standardize (make all "edits-billable" become "billable edits") for simplicity's sake. The challenge is that these substrings occur at the end of lengthy strings. I created a table with two fields, the current substrings and the substrings that I would like to replace them with. How can I connect this table, using a replace function, the edit the original strings? Or is there an alternate way to do this?

[ssanfu]

Detailed info about tables and fields really helps to know how to help solve your question. Several examples of "This is what I have" - "This is what I what to have" also helps.

.... The challenge is that these substrings occur at the end of lengthy strings.......

This tells me you might not have a normalized structure - that you are storing multiple "things" in one field, aka - the field is not atomic.

The easy answer is: you could use VBA code to search and replace. Or there are a couple of programs that will do a search and replace. It all depends on your table/fields.

More info????