Extract highlights from canvas column

Is it possible for me to use a formula to extract highlighted text from a canvas column into another column? I’d like to try using Coda for progressive summarization.


It is possible with some black magic:

The formula will be:

ParseJson(thisRow.Notes._Merge() + "", "$..[?(@.highlight == 'Yellow')].text")

Returned value is a list of text values. You can then concatenate it, make a bullet list or whatever. There will be issues if there’s other formatting present in parts of the line (e.g. there’s a bold word in the highlighted line) — you’ll then get it split up in chunks of different formatting. It is possible to recreate it all but takes more effort than this.


That works perfectly! Thank you!!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.