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

Remove ALL ascii Characters

Asteroid

What would be the expression to remove all ascii characters via the RegEx tool?

 

The below helps within or outside of a range.   

What if I want to start at 00 NULL and end at 255?

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Elegantly-remove-all-ASCII-characters-...

 

 

https://theasciicode.com.ar/

Magnetar
Magnetar

Hi,


I think using the same regex in that example with different hex values should work, eg:

[^x00-xff]+

I looked up the hexadecimal notation for 0 and 255 to build this, you can replace 00 and ff with whatever the target values are.

Asteroid

 

This is all very confusing.  Just getting into it, not sure if I need to.

So to remove the ascii character, you need to know the HEX

 

So I found this which appears to be a complete table:

https://www.commfront.com/pages/ascii-chart

 

Your response with this table is making more sense now.

 

 

Labels