Hi Community,
I have this list of project names with crashed characters.
I would like to have the following expressions changed:
<Input>
<Desired output>
I am struggling to find a solution to this.
Any advice please?
Thank you!
Solved! Go to Solution.
Hi, @selsset97
Please see the formula:
REGEX_Replace(Replace([Plant], "Co_{2}", "CO2"), "(\s|-)Eor$", "$1EOR")
@selsset97 , you can also use simple replace function to get your desired result. Please let me know if it was useful.
Thanks.