Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Pulling data out of an array

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

I’ve got a column that has data like this:
[{"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!

1 Solution

Accepted Solutions

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":', ""),
            "]", ""),
        "[", ""),
    '"', ""),
"}", "")

Screen Shot 2020-11-26 at 11.16.12 AM

See Solution in Thread

2 Replies 2

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":', ""),
            "]", ""),
        "[", ""),
    '"', ""),
"}", "")

Screen Shot 2020-11-26 at 11.16.12 AM

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