In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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
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
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

 

binu_acs
21 - Polaris

@Kuha Another option to remove non ascii characters

 

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