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

1

Hello guys
Thanks you are here.
Check the embed doc please. Who knows how to crack this task? Please

2

Hi @Alexey_Demin,

could you please change doc’s permissions so that we can have a look and dig into it?

Thank you!

3

@Federico_Stefanato Done. (I`m stupid not to do it before, excuse me)

4

Thank you @Alexey_Demin!

I got your point.
I think there are no easy ways to achieve that but only with some hacks (and you might accept they could be discontinued).

I’ll have a look by tomorrow.

1 Like
5

@Federico_Stefanato I appreciate your effort thank you so much.

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
7

@Paul_Danyliuk Thanks a lot. Looks like the exact solution I`m looking for. Formula you provided looks scary : ))) but I will try to understand. Get back with results.

Thank you again

8

@Paul_Danyliuk Magic! It works!!!
Thank you so much.
Subscribed to your newsletter