Regex to find and output all special characters in a string

[garaya]

Hi,

I´m trying to parse all special characters that I´ve in the Regex expression. The goal is to obtain a string with all the characters that were found. However, I´m able to find only the first ocurrence. Please, If anyone can tell me how I can I get all the characters.

Regards!

[LordNeilLord]

Hey @garaya 

A simpler method maybe to replace the word characters with "" therefore leaving you with the special characters only

[LukeM · Accepted solution]

Hi @garaya 

I've attached two solutions. If you'd like to learn more about regex then I always use Regex101.com to test my code.

Hope this helps. Let us know how you get on.

Luke

[Thableaus · Accepted solution]

Hi @garaya 

Using the Replace function you can obtain what you want.

You can also use REGEX_Replace function and create a new field.

Basically, replace this expression:

([^.,:;]+) with ""

Whatever is not your special characters is replaced by an empty character. Then you're left with just your special characters.

Cheers,

[garaya]

Hi @LordNeilLord 

Thanks for replying! I tried that option, but I need a specific set of special chars.

Regards!