Hey there, looking to create a simple slug and for some reason the apostrophe isn’t being removed.
Example Title: Zoom Fatigue is real, so let’s deal with it.
So make lowercase, remove apostrophes remove commas, remove full stops and replace spaces with dashes (etc) is what I’m after.
" ", "-"
I cannot fathom why the apostrophe is not being removed. I’m missing something easy… ideas?
Hard to tell because of the resolution of your screenshot, but might that apostrophe be a typographically correct one (
’), not the ASCII single quote (
') your formula is replacing? You can cover that case and get rid of other nested
SUBSTITUTEs by using
REGEX_REPLACE. For instance, this:
REGEX_REPLACE(Name, "['’´,.]+", ""),
will substitute a hyphen for whitespace and remove dots, commas and common apostrophe variants.
My dude! Thank you. I now know about REGEX-REPLACE.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.