Separate Special Character from a cell

[rohit782192]

Hey Alteryx Champs,

How we separate the special character from a cell into another column.

Data

150%

200#

300!

[Qiu]

@rohit782192 
By special characters, you mean not digit or characters?

[OllieClarke · Accepted solution]

Hi @Qiu 

Nice answer 🙂 I just want to point out that '\w' includes '\d' within it (as '\w' is a short hand for '[A-Za-z0-9_]') so you could just write '(\w+)(.)'

Ollie

[Qiu]

@OllieClarke 
Thanks for the comment.
I though I know this, but it turns out I am still mising some details.

Will keep that in mind.

Have a great day!