community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Find and replace Regex

Asteroid

Hi all

 

I have chunks of texts where the character  is coming before every instance of ².

 

Is there a way of replacing the special character, and then closing the gap ?

 

EG CO² will become CO²

 

Thank you !!

Alteryx Certified Partner

Hey @CalDowd98 

 

You could try something like this:

 

Replace([Field1], CharFromInt(194), "")

 

194 is Â, i found this number by spliting out your text into individual characters and then using CharToInt() to find the number

Highlighted
Asteroid

Wow !

 

Thats worked perfectly, thank you  !!

Labels