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