Thanks! I’ve been playing with dataview and regex (using https://regex101.com/) and got most of the way there. However I get this odd character showing up and have no clue why…I may open an issue in dataview since the issue doesn’t seem to happen elsewhere.
TABLE WITHOUT ID
regexreplace(Tasks.text, "[⏫🔼🔽]? \[.*$", "") AS Task,
regexreplace(Tasks.text, "[^⏫🔼🔽]", "") AS "Priority"
FROM #testingdates2
WHERE file.tasks
FLATTEN file.tasks AS Tasks