Regex to find and output all special characters in a string

Question

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!

REGEX Special Char example.yxmd

LukeM · Accepted Answer

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 Answer

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,