Solved

Removing special characters from text for a filename

Hi

Anyone have any clever tips for removing special characters from text to make them filename firendly? For example < > { } ) ( etc.

I could do it with a massive nested substitute formula but that seems clunky so hoping there is a cleverer way of doing it.

Best answer by Kamille_Parks11

Use REGEX. This will remove all “non word” characters

REGEX_REPLACE(Name, "[^[:word:]]", "")

This will remove all punctuation

REGEX_REPLACE(Name, "[[:punct:]]", "")

Did this topic help you find an answer to your question?

+15

Use REGEX. This will remove all “non word” characters

REGEX_REPLACE(Name, "[^[:word:]]", "")

This will remove all punctuation

REGEX_REPLACE(Name, "[[:punct:]]", "")

Kamille_Parks11 wrote:

Use REGEX. This will remove all “non word” characters

REGEX_REPLACE(Name, "[^[:word:]]", "")

This will remove all punctuation

REGEX_REPLACE(Name, "[[:punct:]]", "")

Thank you!! You’re amazing Kamile!

2 replies