Alteryx Designer Desktop Discussions

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

Remove ALL ascii Characters

Number4
8 - 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/

2 REPLIES 2
Claje
14 - 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.

Number4
8 - 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