Help

Removing special characters from text for a filename

Topic Labels: Formulas
Solved
Jump to Solution
2905 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Davies
7 - App Architect
7 - App Architect

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.

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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

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

This will remove all punctuation

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

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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!