regex match special characters

[EtamSoko]

hi everyone,

I need a little help with cleaning my dataset. I have a regex already for my exercise but it isn't covering everything.

I need to replace characters in a field itself if it has only:

*

-

---

--

-

..

.

/

blank

empty

0

Is it possible to have all this in 1 expression? for now I have "^(\W)$" for now which replaces some of them but not obviously all the above.

Can someone let me know if that is possible at all?

I would also look for an option to create a macro and spread across my org to kind of use it to any dataset going forward.

thanks,

M

[RishiK]

@EtamSoko it is a personal preference and maybe easier to understand.  Use the Formula tool and the replace functions such as the one below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replacing-characters-within-a-data-fie...

[Qiu · Accepted solution]

@EtamSoko 
Or prepare a library of these special characters and use Find and Replace tool?

Easy for maintenance also.

[EtamSoko]

@Qiu 

That sounds good!

How do I get to create the library? Can you help me out there with an example? I do not have experience on that.

thanks a lot!

M

[afv2688 · Accepted solution]

Hello @EtamSoko,

I don't know it this is exaclty the idea but hope it helps to suit your needs 🙂

Regards

[Qiu]

@EtamSoko 

Thanks  to @afv2688 , this is exactly what I meant.😁

[EtamSoko]

ok. I thought there is another more sophisticated way for library 🙂 thanks all of you for the help. Library solution will be the way forward.

cheers,

M