Removing special characters from text for a filename

[Andrew_Davies]

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.

[Kamille_Parks · Accepted solution]

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

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

This will remove all punctuation

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

GitHub

Syntax · google/re2 Wiki

RE2 is a fast, safe, thread-friendly alternative to backtracking regular expression engines like those used in PCRE, Perl, and Python. It is a C++ library. - Syntax · google/re2 Wiki

[Andrew_Davies]

Thank you!! You’re amazing Kamile!