How to get separeted line values from a output datatable

Dear colleagues,

i would like to know to how get the line values, line per line, because i would like to add, i am able to get the intire data table output, but i would like to have the line per line values, them it would be easier to add them as queue items in the orchestrator.

Here is what i got now:

Heres is what i want:

And i also would like to know, how to not show the null values gathered in the datatable.

Hello @Lucas_Silva

Thank you for your inquiry

Take a look:

try Split(pdfText,Environment.NewLine(0))(5) <=== this (0)(5) means that I’m getting line 5


If this post answer your question don’t forget to mark it as solved, your like is always appreciated.:wink:

happy automation.


Edit; Typo

Hi @beesheep,

I tried to use your solution but somehow it didnt worked, could you explain it for me ?

1 Like

As it is a Datatable you can

Filter Out the Null values - Filter Datatable Activity

Iterate over the rows - for each row Activity

Hi man… would you mind to upload your xaml


The filter part actually worked, but when i got the For Each activity it doesnt not get line per line, how could i possibly develop it ?

Dont Mix IT Up with for each Activity. Go for the for each row Activity

1 Like

For each row is used for DataTables, and For each is used for general purposes.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.