
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 10:14 AM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 10:53 AM
Use REGEX. This will remove all “non word” characters
REGEX_REPLACE(Name, "[^[:word:]]", "")
This will remove all punctuation
REGEX_REPLACE(Name, "[[:punct:]]", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 10:53 AM
Use REGEX. This will remove all “non word” characters
REGEX_REPLACE(Name, "[^[:word:]]", "")
This will remove all punctuation
REGEX_REPLACE(Name, "[[:punct:]]", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 28, 2022 11:08 AM
Thank you!! You’re amazing Kamile!
