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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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 !!

Highlighted
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

Asteroid

Wow !

 

Thats worked perfectly, thank you  !!

Labels