Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Slug from Title with hyphens - avoid double hyphens

Topic Labels: Formulas
932 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi… the forumulas are quite challenging for me. I am using Airtable with the Airpower Shopify App. A total game changer but I have had to learn Airtable.

I want to create a new column where I take my Product Title and make it into a slug (for a webpage title). However I often use hyphens in my titles and all my attempted formulas still create a double – hyphen.

Example {Product Title}: Vintage Futa Lures - 9" Slant - MOP Slabs - Like New
Result: vintage-futa-lures-9"-slant-mop-slabs–like-new (between slabs and like there is a double hypen but looks like a long dash here)
What I want: vintage-futa-lures-9"-slant-mop-slabs-like-new

Formula: LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( {Product Title}, " - ", " "), “–”, " “), " -”, " "), "- ", " "), " ", " "), " ", “-”))

Thanking you in advance for any suggestions!

0 Replies 0