How to get column values from a block's content?

Hi everyone,

I was wondering if there was an easy way to parse out the values of a column when working with the Contents of a block?

For example:

If I had the following block:

{
  "ID": "20250105025033-siepypo",
  "ParentID": "20250105020840-imlhemk",
  "RootID": "20250105020840-imlhemk",
  "Hash": "af426b8",
  "Box": "20250105005939-lczg2b5",
  "Path": "/20250105005942-e9g30xz/20250105020840-imlhemk.sy",
  "HPath": "/testing/1",
  "Name": "",
  "Alias": "",
  "Memo": "",
  "Tag": "",
  "Content": "Costs Table Month Comments Value January Comment 1 2223.34 February Comment 2 4443.34",
  "FContent": "",
  "Markdown": "\u003cdiv data-type=\"NodeAttributeView\" data-av-id=\"20250105034303-njsk40l\" data-av-type=\"table\"\u003e\u003c/div\u003e",
  "Length": 85,
  "Type": "av",
  "SubType": "",
  "IAL": "{: id=\"20250105025033-siepypo\" updated=\"20250105034338\"}",
  "Sort": 30,
  "Created": "20250105025033",
  "Updated": "20250105034338"
}

What would be the easiest way using template scripting to get all the values of e.g. the Value column, which should be 2223.34 and 4443.34 in the above example into e.g. a list?

Or is there another approach altogether that can get me the column data without working with this json structure?

Thanks

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...