Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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