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â®
Solved! Go to Solution.
How about:
REGEX_Replace([Field1], "[^ -~]", '')
It will eliminate things not in the ascii range of BLANK to TILDE
Cheers,
Mark
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