Regex replace help

[jannis005]

Hi -

I am hoping to get some assistance writing a RegEx replace formula. I have several sub-accounts that roll into a master account (i.e. 1912 through 1916 all roll into master account 1911). I am trying to write a RegEx replace in the formula tool to find those specific sub-account groupings and replace them with the master account number. Please let me know if there is a concise way to do this, other than with a join.

Thanks in advance!

[MarqueeCrew · Accepted solution]

I would construct a lookup table for all discrete values and their master number. You can then use a find replace tool to change the values (string fields).

Cheers,

Mark