Table range activity

Hi

im getting my output by using get table range as below
i want my last line like Grand Total and…i.e last line how i can do that

output:
01/01/2019 00:00:00,1582288,475176,86496,2143960
02/01/2019 00:00:00,985219,306336,41064,1332619
03/01/2019 00:00:00,1263157,78888,38160,1380205
04/01/2019 00:00:00,1195024,42984,7488,1245496
05/01/2019 00:00:00,859141,33112,7992,900245
06/01/2019 00:00:00,500792,7680,508472
07/01/2019 00:00:00,282679,10464,293143
Grand Total,1653095

1 Like

You want to extract last line that is 1653095.Right?

If “Grand total” is in “column0” then you can use filter activity for filtering column 0 which contains “Grand Total” with output column containing its value.

Fine
if the above text is in a string variable named str_input
then to get the output value of grand total
str_output = System.Text.RegularExpressions.Regex.Match(str_input,"(?<=Grand Total,).*").ToString

where str_input and str_output is a string variable
if the above mentioned output is not a string then we can get that string using OUTPUT DATATABLE activity as well

hope this would help you
kindly try this and let know for any queries or clarification
Cheers @venkateshtangudu

i want complete line

@venkateshtangudu

Iterate it using For Each Row
If condition Row contains Grand total get the value and assign it to variable
Or
Use FilterDatatable or filter range filter first column contains grand total then get the value.

Thanks,
Suresh J

Don’t iterate Filter it out, if count >0 then print(“GrandTotal,”+DataTable.Rows(0)(1).ToString)

so i should covert into array

is the data in Table or not??

it is in Pivort…so im using read table range and for reading the data

then filter the table based on column name or index and take the Adjacent value.

Its in table format? Or it’s a string?

hi

its a data table

table.xaml (10.7 KB)

Check if table is in this format then its working fine. And if its in other format please share