How to 'extract' rows from the hand filled text+rows column?

6

Hey @Alexey_Demin,

Here’s the solution you’re looking for; indeed it uses some hacks to extract @-references out of the text.

In a single formula that’d be:

RegexExtract(
  _Merge(thisRow.Description) + "",
  '{[^{}]*?"type":"ref"[^{}]*?}', "g"
).FormulaMap(
  ParseJSON('{"val":' + CurrentValue + '}')._Deref_object("val")
)

And if you need not the bubbles but the @-references concatenated by commas exactly like in your example, do this:

RegexExtract(
  _Merge(thisRow.Description) + "",
  '{[^{}]*?"type":"ref"[^{}]*?}', "g"
).FormulaMap(
  Concatenate(
    ", ",
    ParseJSON('{"val":' + CurrentValue + '}')._Deref_object("val")
  )
).Concatenate().Slice(3)
2 Likes