Skip to main content

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!

Be the first to reply!

Reply