I am extracting a table from mail body using activity “Extract data tables from HTML” and store in a variable as data table array then reading the each item but for each activity is not reading the multiple rows.
When I debug into this and found the data in string format.
Can some one please me on this issue how I can read the each row?
Data :-
[PO Line Number,Error Msg,Failed Product,Correct EDP,Item Desc
10,Product not found for item number(edp):123 SUBST.,123 SUBST,00162805,Test Material VAR Order Processing
20,Product not found for item number(edp):9100005577.,9100005577,00162678,STEREO HEADSET H151
]
I could see this data while debugging into this. From the above data, I am able to get 123 SUBST,00162805 from first row but not getting the data from send row e.g. 9100005577,00162678.
Tried your given solution but it giving me only data from 1st row. Request you to please help.
Thanks