Possible to read many rows and store it in one string variable?

[bibalesecret (Dennis)]

Hello everyone,

sorry for so many new topics, but I am new to UiPath

I have a datatable “dtVodafone”. In this datatable there are three columns “Number”, “Name”, and “Paynumber”.

I want to read each row to have the following output:

12345,Dennis,09876

23456,James,07654

How can I store each row to one single variable string?

Thanks in advance,
Dennis

(I couldn’t find a topic that really has the same intention as me)

[kumar.varun2 (Varun Kumar)]

Hi @bibalesecret

Try this approach

strData = String.Join(vbcrlf, Dt_Data.AsEnumerable.Select(Function(r) String.Join(",", r.ItemArray.Select(Function(x) x.ToString))))

Refer the xaml file

StoreRowsInOnesStringVariable.xaml (7.0 KB)

[bibalesecret (Dennis)]

That worked fine, thanks!

What shall I do to get the following output without “vbcrlf”?:

12345,Dennis,09876,23456,James,07654

Thanks in advance,
Dennis

[kumar.varun2 (Varun Kumar)]

@bibalesecret

Instead of vbcrlf use the emtpty string “”

strData = String.Join("", Dt_Data.AsEnumerable.Select(Function(r) String.Join(",", r.ItemArray.Select(Function(x) x.ToString))))

[bibalesecret (Dennis)]

Fantastic, thank you!!!