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.
Use REGEX. This will remove all “non word” characters
REGEX_REPLACE(Name, "[^[:word:]]", "")
This will remove all punctuation
REGEX_REPLACE(Name, "[[:punct:]]", "")
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.