Regex Special Characters

Question

I'm pulling in data and loading to a table in our data warehouse. The table will not accept special characters and I am trying to figure out a way to have Alteryx remove/update special characters. With the example below I would like for it to come out as Thai Kitchen.

Thai Kitchenâ®

MarqueeCrew · Accepted Answer

@jonathangonzales ,

How about:

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

It will eliminate things not in the ascii range of BLANK to TILDE

Cheers,

Mark

vizAlter · Accepted Answer

Hi @jonathangonzales — Here we go:

REGEX_Replace([Field1], "[^a-zA-Z0-9 .-]", ' ')

^ sign in [ ] in front of given characters will look for other character to remove them.

That means this RegEx will keep a to z, A to Z, 0 to 9, space, decimal, hyphen only