Welcome to the community, William! :grinning_face_with_big_eyes: Converting the pipe-separated tags into something else is actually pretty easy. First, make a new field that uses SUBSTITUTE to replace the pipes with commas:
The formula for the {Comma-separated} field is:
SUBSTITUTE(Source, "|", ",")
This {Comma-separated} field can then be converted into either a multi-select field, or one that links to a [Tags] table, depending on your preference. I actually did one of each in my test:
Airtable will recognize the commas as separating independent items, and convert them appropriately, adding entries for a multi-select type, or new records in the [Tags] table for the link type. Repeated tags will match existing ones, so you won’t have duplicate entries in either case.
In terms of which I’d prefer, I might lean toward the [Tags] table. In that table you can see (and add a field to count) how many posts use each tag, which would be difficult (if not impossible) with a multi-select. In other words, if you have any inclination to do more with these tags in Airtable than just add them and be done, then I’d go with a table.
