community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Elegantly remove all ASCII characters outside the range 32 -126

Alteryx Partner

@Jordken Change the expression to read as follows:

 

regex_replace([_CurrentField_],"[^\xA,\xD,\x20-\x7e]+",'')

 

[_CurrentField_] being whatever your field name is if you are using the formula tool and not the multi field tool

Alteryx Certified Partner
Alteryx Certified Partner
[ -~]

That's the range as elegantly as possible.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels