Removing special characters from text for a filename

Ask the community Formulas
#1

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.

#2

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

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

This will remove all punctuation

REGEX_REPLACE(Name, "[[:punct:]]", "")
2 Likes
#3

Thank you!! You’re amazing Kamile!

#4

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.