Help with RegEx

[selsset97]

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.

<Input>

<Desired output>

I am struggling to find a solution to this.

Any advice please?

Thank you!

[flying008 · Accepted solution]

Hi, @selsset97 

Please see the formula:

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

[gabrielvilella · Accepted solution]

You can do this with a simple find and replace.

[grazitti_sapna]

@selsset97 , you can also use simple replace function to get your desired result. Please let me know if it was useful.

Thanks.