Hello everyone, I did an automation that can extract text and paragraphs to Google Sheets. And is it possible to extract the whole paragraph in one row on the C column? I used table extraction to indicate the paragraph and it gonna extract it in each rows

Help Studio
2

Hi @Knowledge,

We need to change the selector bits to achive, if thats not possible we need to concadinate the “C” column values if the “A & B” columns are empty.

dtResult = dtInput.Clone()
dtInput.AsEnumerable().GroupBy(Function(r) r("A").ToString()).Select(Function(g) dtResult.Rows.Add(g.Key, "", String.Join(",", g.Select(Function(r) r("C").ToString()))))

OR

dtResult = dtInput.Clone()

(From g In dtInput.AsEnumerable()
 Group g By key = If(String.IsNullOrWhiteSpace(g("A").ToString()), "temp", g("A").ToString()) Into Group
 Let mergedCol3 = String.Join(" ", Group.Select(Function(r) r("C").ToString()))
 Select dtResult.Rows.Add(If(key = "temp", "", key), "", mergedCol3)).CopyToDataTable()

Regards,
Arivu