regex match special characters

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

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,

Regex

Accepted answers

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

Easy for maintenance also.

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

Regards

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

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

Easy for maintenance also.