
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2020 11:08 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2020 11:16 AM
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":', ""),
"]", ""),
"[", ""),
'"', ""),
"}", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2020 11:16 AM
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":', ""),
"]", ""),
"[", ""),
'"', ""),
"}", "")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 26, 2020 11:43 AM
Thank you, that was perfect! You’ve unblocked my Thanksgiving project.
