I have a a Multiple Select Field which I am trying to substitute spaces with hyphens. The issue that I am running against is that the is space between items and the formula adds an extra hyphen in the final result. I am using LOWER(SUBSTITUTE(Series, " ", “-”))
See screenshot for field details and results.
Thanks for the help!!
substitute issue|700x237
Best answer by kuovonne
Welcome to the Airtable community!
You can substitute the comma and space between items with something else, then replace spaces with hyphens, and then finally put the comma and spaces back.
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
LOWER(Series),
", ",
"TEMP"
),
" ",
"-"
),
"TEMP",
", "
)
+29Welcome to the Airtable community!
You can substitute the comma and space between items with something else, then replace spaces with hyphens, and then finally put the comma and spaces back.
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
LOWER(Series),
", ",
"TEMP"
),
" ",
"-"
),
"TEMP",
", "
)
Welcome to the Airtable community!
You can substitute the comma and space between items with something else, then replace spaces with hyphens, and then finally put the comma and spaces back.
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
LOWER(Series),
", ",
"TEMP"
),
" ",
"-"
),
"TEMP",
", "
)
That did it. Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.