I’m trying to take a simple comma-separated list and convert it into unique values so that I can parse them in other tables.
For example: I have the text “dog, cat, fish” in a cell. Coda sees this as one value of “dog, cat, fish”.
When I try to convert above text into a list - either using List() or ListCombine() - Coda returns [(dog, cat, fish)] instead of [(dog),(cat),(fish)]. Unique() doesn’t do what I need it to here either, because it sees only one value instead of three.
Context: I am trying to format a column as a multi-select list - I want to be able to select any/all of “dog”, “cat”, or “fish”, but I cannot get them to appear as unique values - they always appear as “dog, cat, fish” instead. See below - Nth(1) should return “dog”, but instead it returns “dog, cat, fish”.
How do I do this? Sorry if the formatting in my question is weird, I’m not a natural programmer.