Skip to main content

I’ve got a column that has data like this:

e{"Tags":"action"},{"Tags":"sci-fi"},{"Tags":"violence"},{"Tags":"youngadult"}]


I’d like to just extract the words, “action”, “sci-fi”, “violence”, “youngadult” so I can turn this into a multi-select column.


Any idea how I can use a formula or automation to do this? Thanks in advance!

This can be done by using a nested collection of SUBSTITUTE() functions to remove the pieces you don’t want. Here’s what I did:


SUBSTITUTE(

    SUBSTITUTE(

        SUBSTITUTE(

            SUBSTITUTE(

                SUBSTITUTE(Tags, '{"Tags":', ""),

            "]", ""),

        " ", ""),

    '"', ""),

"}", "")

This can be done by using a nested collection of SUBSTITUTE() functions to remove the pieces you don’t want. Here’s what I did:


SUBSTITUTE(

    SUBSTITUTE(

        SUBSTITUTE(

            SUBSTITUTE(

                SUBSTITUTE(Tags, '{"Tags":', ""),

            "]", ""),

        " ", ""),

    '"', ""),

"}", "")


Thank you, that was perfect! You’ve unblocked my Thanksgiving project.

Reply


Terms & Conditions