By newkid.7955
I have a file which extracts data from an HTML file
For Eg HTML file contains:
For Eg HTML file contains:
Code:
New York;ABC;145;Yes;YES;No
New York;BCD;113;Yes;YES;No
New York;NAS;63;Yes;YES;No
------------------------
London-48;CBT;16;Yes;YES;No
London-48;CME;17;Yes;YES;No
London-48;EUR;52;Yes;YES;No
London-48;EUR;188;Yes;YES;No
London-48;USx;66;Yes;YES;No
London-48;AMS;172
178;Yes
Yes;YES
YES;no
no
London-48;LIFE;172
174
178;Yes
Yes
Yes;YES
YES
YES;no
no
no
London-48;EUEd;175;Yes;YES;no
London-48;FOXN;177;Yes;YES;no
London-48;BIRD;177;Yes;YES;no
London-48;MOND;177;Yes;YES;no
London-48;EUI;174;Yes;YES;no
London-48;XEC;15;Yes;No;No
London-48;BRUS;95;Yes;No;No
London-48;NYMC;15;Yes;No;No
-----------------------------
London-47;WBOx;28;Yes;YES;No
London-47;BCD;20;Yes;No;No
London-47;MCe;89;Yes;YES;No
London-47;DUBL;87;Yes;YES;No
London-47;CIHX;34;Yes;YES;No
London-47;Ctaf;203;Yes;No;No
London-47;LUXA;95;Yes;YES;No
London-47;LUXB;95;Yes;YES;No
London-47;LUXP;95;Yes;YES;No
London-47;NEBX;95;Yes;YES;No
London-47;NXEL;95;Yes;YES;No
London-47;misc;95;Yes;YES;No
London-47;BXNJ;95;Yes;YES;No
London-47;LANT;95;Yes;YES;No
London-47;LANB;95;Yes;YES;No
London-47;MASD;95;Yes;YES;No
London-47;BRUS;95;Yes;YES;No
London-47;LISB;95;Yes;YES;No
London-47;LIST;95;Yes;YES;No
London-47;PARF;95;Yes;YES;No
London-47;JSEB;31;Yes;YES;No
London-47;LoND;33;Yes;YES;No
As a TXT file, it gets:
It is in the format of
Code:
Server;Country;Num;Data1;Data2;Data3
If there are multiple Num column, then it is in the format
Code:
Server;Country;
Num1
Num2;Data1ofNum1
Data1ofNum2;Data2ofNum1
Data2ofNum2;Data3ofNum1
Data3ofNum2
Now I need to write a uniq script where the user needs to find a server which has routing and Data2 lets say:
FOR EG of entered data: BRUS Data2
I want to see if data 2 + BRUS is available on a server, it should return London-47, London-48
but the problem is that the txt file grabs data per column and not by row.
If this question is not so clear please inform me.