Hey Alteryx Champs,
How we separate the special character from a cell into another column.
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
@rohit782192 By special characters, you mean not digit or characters?
@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!