Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Removing special characters from text for a filename

Topic Labels: Formulas
Solved
Jump to Solution
3233 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!