Help

Removing special characters from text for a filename

Topic Labels: Formulas
Solved
Jump to Solution
191 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!

Labels