Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Substitute Spaces with Hyphens on Multiple Select Field

Topic Labels: Formulas
Solved
Jump to Solution
660 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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",
    ", "
)

See Solution in Thread

2 Replies 2

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!