Creating a Mass Replacement Macro According to Arbitrary Conversion Parameters

[verbconjugator]

So, I have a 40x2 table of non-systematic strings to be converted to other strings - think "LM" needs to become "2P9" and "ATT" needs to be "Y4," all just according to this table. I have long groups of things that need to be convered seperated by dashes (so something like "LM-ATT-etc-etc-etc," which should become "2P9-Y4-etc-etc-etc") but housed together in one field. I want to write a macro that goes through and automatically changes every "LM" type thing into a "2P9" category one, and that also converts the dashes to semicolons in one go.

Help appreciated, thanks!

 

[verbconjugator]

Additionally, the dash-seperated groups of things don't always contain the same number of elements... I just need the code to iterate over and replace all of the eligible ones.