Help with RegEx

Question

Hi Community, I have this list of project names with crashed characters. I would like to have the following expressions changed: * Co_{2} to be replaced to CO2 * Eor to be replaced by EOR. Here Eor has to be preceded by a space (\s) or a dash (\-). Please refer to the screenshots attached. I am struggling to find a solution to this. Any advice please? Thank you! Help with RegEx.yxmd

flying008 · Accepted Answer

Hi, @selsset97

Please see the formula:

REGEX_Replace(Replace([Plant], "Co_{2}", "CO2"), "(\s|-)Eor$", "$1EOR")

gabrielvilella · Accepted Answer

You can do this with a simple find and replace.