Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to parse Amadeus AIR ticket reservation file
Message
De
22/08/2013 15:18:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to parse Amadeus AIR ticket reservation file
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01581031
Message ID:
01581031
Vues:
164
Amadeous produces AIR file like below for every flyight reservation.
I need to read reservation number and source and destionation airports from this file.

I searched goog for "amadeous air format" but havent found format description.
Wikipedia entry about EDIFACt is a bit different, it does not describe this content.

Where to fnd information about the file structure ?
How to parse this file ?
I have not idea about the file stucture, does it contain records like sql table or is it some reservation protocol instructions like postscript file ?

Application should work in Microsoft Windows and preferably in Visual FoxPro or C# language.
FoxPro or Microsoft Visual Studio 2012 Express can used as programming environment



AIR-BLK206;1A;;236;1500004635;AY14909;001001
AMD 1500044298;1/1;
AY17497;AY14909
MUC1A 2JW8HW022;0101;TLLEE2310;63320320;TLLEE2310;63320320;TLLEE2310;63320320;TLLEE2310;63320320;;;;;;;;;;;;;;;;;;;;;OV 2JW8HW;TK RJ3ZZ7
A-TURKISH AIRLINES;TK 2354
B-TTP/T2
C-7906/ 3103ELSU-3103ELSU-I-0
D-080813;080815;080815
G-X ;;VIEANK;E1
H-019;003OVIE;VIENNA SCHWECHAT ;ESB;ANKARA ESENBOGA ;TK 8726 S S 29AUG1030 1400 29AUG;OK01;HK01;M ;0;320;;;30K;;;ET;0230 ; ;984;;;;;
U-001X;002OTLL;TALLINN ;VIE;VIENNA SCHWECHAT ;OV 0193 W W 29AUG0725 0845 29AUG;OK01;HK01;G ;0;733;;;;;;ET;0220 ; ;;846;;
K-FEUR144.00 ;EEK2255 ;;;;;;;;;;;EEK3096 ;15.64660 ;;
KFTF; EEK470 YR VA; EEK245 ZY AE; EEK126 AT SE;;;;;;;;;;;;;;;;;;;;;;;;;;;
TAX-EEK470 YR ;EEK245 ZY ;EEK126 AT ;
L-
M-SPROW
N-NUC224.01
O-29AUG29AUG
Q-VIE TK ANK224.01NUC224.01END ROE0.642811
I-001;01MELDER/VIVIAN MS;;APBT 6300406 EEVA//RUF;;
SSR OTHS 1A /IRC-2/ADV OTO TKT OR XX BY 20AUG/1200
SSR OTHS 1A /PLS ADV TICKET NUMBERS BY 17AUG2008/2359 OR AUTOCXL TLLOV
T-K235-5783975462
FENONEND/TK ONLY;S3;P1
FM*M*0.00;S3;P1
FPINV,EL;S3;P1
FVTK;S3;P1
TKTL15AUG/TLLEE2310
ENDX
Andrus
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform