In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Removing special characters using formula tool

dunkindonut7777
8 - Asteroid

Hi, I have a data here that has special characters, I want to remove it in a formula tool.

 

NameExpected output
Non-paymentNon payment
Paid/SpecialPaid Special

 

Just want to know how to formulate it in a formula tool. Thank you

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @dunkindonut7777 

 

Here's an example using regex replace. the [^A-Za-z] means any character that is not (^) A-Z.

 

REGEX_Replace([Name], '[^A-Za-z]', ' ')

 

image.png

MilindG
12 - Quasar

@dunkindonut7777 Heres couple ways you can do this.

Labels
Top Solution Authors