Extracting data from web page using a filter

[bytec]

Hi,

I have a task which extracts data from a web site table. This work fine but what I would like to do is extract only rows of data that meet a criteria.

example rows:
"EZY8664","15:55","LONDRES /GATWICK (LGW)","EASYJET AIRLINE CO. LTD.","N "
"EZY2224","16:05","LONDRES /LUTON (LTN)","EASYJET AIRLINE CO. LTD.","N "
"FR9072","16:10","MANCHESTER (MAN)","RYANAIR","N "
"IBE8906","16:15","IBIZA (IBZ)","IBERIA","N "

Task: extract all rows where the flight number contains "FR" (FR9072) 3rd row.

If someone could provide an example that would be great.

Many thanks in advance.

Dereck

[forumstaff]

Hello Bytec,

You can extract the table to the CSV file in the similar fashion that you are carrying on. After extracting data into the CSV file, you can use "Read from CSV/text" command.

For example:
1 Read From CSV file : 'C:\sample.csv' Delimiter: 'Comma' Header: 'No' Session: 'Default'
2 Start Loop " Each row in a CSV/Text file of Session: Default"
3 If $Filedata Column(1)$ Includes "FR" Then
4 Comment: Please enter the conditional commands here.
5 End If
6 End Loop

On line no. 4, you can put the conditional statement like: log the data in another csv/text file using "Log to file" command.

Thanks & Regards

[bytec]

Hi and many thanks for your fast response.

I have been trying to NOT come back to the forum before I gave it my all in solving the issue I have, but have failed.

The TASK text you provided works but the resulting CSV file is a little odd.

Example before removing the rows that do not contain "FR"

"http://www.aena-aeropuertos.es/csee/Satellite/infovuelos/en/Details.html?accion=detalle&company_code=FR&dia=20 110930&hora_prev=2011-09-30+10%3A30&ncia=FR&numBusqueda=FR906Z&nvuelo=906Z& ordenacionBack=hprevisto&originBack=ALC&originBusq ueda=ALC&strVuelo=FR906Z"
"http://www.aena-aeropuertos.es/csee/Satellite/infovuelos/en/Details.html?accion=detalle&company_code=AB&dia=20 110930&hora_prev=2011-09-30+17%3A25&ncia=AB&numBusqueda=AB7863&nvuelo=7863& ordenacionBack=hprevisto&originBack=ALC&originBusq ueda=ALC&strVuelo=AB7863"
"http://www.aena-aeropuertos.es/csee/Satellite/infovuelos/en/Details.html?accion=detalle&company_code=NLY&dia=2 0110930&hora_prev=2011-09-30+17%3A25&ncia=NLY&numBusqueda=NLY7863&nvuelo=786 3&ordenacionBack=hprevisto&originBack=ALC&originBu squeda=ALC&strVuelo=NLY7863"

You will notice that on the end of each row there is "strVuelo=" to a reference number. In this case its a flight number.

AFTER removing row that do not contain "FR" the reference number (flight number) is incomplete.

"http://www.aena-aeropuertos.es/csee/Satellite/infovuelos/en/Details.html?accion=detalle&company_code=FR&dia=20 110930&hora_prev=2011-09-30+10%3A30&ncia=FR&numBusqueda=FR906Z&nvuelo=906Z& ordenacionBack=hprevisto&originBack=ALC&originBusq ueda=ALC&strVuelo=FR"

Can you think of why this is happening.

I have attached the TASK which may be of help along with:
NaviGateURL.txt (before data)
FR_NaviGateURL.txt (after non FR data removal)

Again, many thanks in advance for any time you can give.

Regards

Dereck

[forumstaff]

Hello bytec,

We have taken a look at your task and we want to have an online meeting with you so that we can try few things at your end. Please give us your contact details on support@automationanywhere.com and we will schedule an online meeting.

Let us know if that works for you.

Thanks & Regards