Hey Alteryx Champs,
How we separate the special character from a cell into another column.
Data |
150% |
200# |
300! |
Solved! Go to Solution.
@rohit782192
By special characters, you mean not digit or characters?
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
@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!