viewing special characters

[jakekap10]

is there way way to parse out data in a column that contains any special character? 

situation is i have lets say 6000 rows of data I am trying to see if any of those 6000 contain special characters such as &,$,%....... is there any way to do that ?? 

[atcodedog05 · Accepted solution]

Hi @jakekap10 

It is possible. Here is a example.

Configure the Regex tool like below

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Hi @jakekap10 

If you are looking to remove all the special character you can use data cleanse tool to remove all characters.

https://help.alteryx.com/current/designer/data-cleansing-tool

By configuring to remove punctuations. 

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @jakekap10 

Cheers and Happy Analyzing 😀

[jakekap10]

Thank you!!