Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to remove certain characters

Kuha
7 - Meteor

Hi

Is there any way to remove this character from my data?  

Kuha_0-1680047916829.png

Thanks

Kuha

 

 

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora

@Kuha ,

If you want to keep only ascii character, this formula might work.

REGEX_Replace([Data], "[^\x00-\x7F]", "")

Input / Output

Yoshiro_Fujimori_0-1680049849118.png

Good luck.

Yoshiro_Fujimori
15 - Aurora

Or if you just want to remove a particular character, you may simply put the charactor in ReplaceChar function as below.

ReplaceChar([Data], "↑", "")

Yoshiro_Fujimori_1-1680050764823.png

 

binuacs
20 - Arcturus

@Kuha Another option to remove non ascii characters

 

REGEX_Replace([Field1], "[^ -~]", '')
Labels