Latest Inquiries - Data Extraction Software

Extract data from a table

Submitted: 7/27/2017

Hi,

I have a project (attached) that needs to extract data from a generated table based on some input data (coming from a data source). Could you please instruct me on how I can extract the data from a table in a correct way? I thought it's easy, but it seems to be more complicated than I thought. Also, the data needs to be denormalized.

Thank you,

Laurentiu

Opcom_LE.rip
Dates.csv

Replied: 7/28/2017 5:12:32 AM

Hi Laurentiu,

See attached file. The agent works as it should be. Please take a closer look at the XPath because that's where the magic is.

Best regards,


Opcom_LE.rip

Replied: 7/28/2017 9:56:42 AM

Hi Brian,

It looks nice, however could you please explain to me what preceding-sibling::TR[TD[16]][1]/TD[1] and /TD[last()-14] do?


Thanks,

Laurentiu

Replied: 7/31/2017 3:06:58 PM

Hi Laurentiu,

preceding-sibling::TR[TD[16]][1]/TD[1]  says look backward and capture the TR only if it has 16th TD element, and then look [1] select only the first one.

For /TD[last()-14] look for the last TD string but I don't need the last but the 14th count from the last.