Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Slug from Title with hyphens - avoid double hyphens

Topic Labels: Formulas
453 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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