I have a string in which i have to find PNR number. To get PNR number i have to check two condition
(a) First in Passenger should be more than one.
(b) Second String contain ITINERARY REBOOKED.
if both upper condition exist then only PNR number extract from the string otherwise no
example of strings
string First=@"RT29WHVE
--- TST RLR ---
RP/NYC1S21DD/NYC1S21DD WS/SU 6MAY13/0503Z 29WHVE // This is PNR number
NYC1S21DD/9525GY/6MAY13
1.KHOON/FRANCIS 2.MEH/SAY 3.MEH/PRAY 4.MEH/MAW //Passenger more than one
5.REH/LAW 6.REH/PAE 7.REH/DO 8.REH/LEE 9.REH/HEH
10 US 152 T 12MAY 7 GEGPHX HK9 300P 534P 12MAY E US/A4PRHM
11 US 184 T 12MAY 7 PHXLAS HK9 815P 923P 12MAY E US/A4PRHM
12 US 392 K 13MAY 1 LASCLT HK9 115A 827A 13MAY E US/A4PRHM
13 US4286 K 13MAY 1 CLTFAY HK9 955A1050A 13MAY E US/A4PRHM
OPERATED BY SUBSIDIARY/FRANCHISE
14 MIS 1A HK9 NYC 11JAN-THANK YOU FOR YOUR BUSINESS
15 AP NYC9103161516
16 APE FRANCISKHON@GMAIL.COM
17 TK OK06MAY/NYC1S21DD//ETUS
18 SSR DOCS US HK1 ////09NOV83/M//KHOON/FRANCIS/P1
19 SSR DOCS US HK1 ////01JAN92/M//MEH/SAY/P2
20 SSR DOCS US HK1 ////01JAN62/M//MEH/PRAY/P3
21 SSR DOCS US HK1 ////01JAN96/M//MEH/MAW/P4
22 SSR DOCS US HK1 ////15APR89/M//REH/LAW/P5
23 SSR DOCS US HK1 ////11NOV97/M//REH/PAE/P6
24 SSR DOCS US HK1 ////01JAN59/M//REH/DO/P7
25 SSR DOCS US HK1 ////05OCT88/M//REH/LEE/P8
)>SP1
--- TST RLR ---
-ASSOCIATE PNR-
RP/NYC1S21DD/NYC1S21DD WS/SU 6MAY13/0503Z XXXXXX
1.KHOON/FRANCIS
2 US 152 T 12MAY 7 GEGPHX HK1 300P 534P 12MAY E US/A4PRHM
3 US 184 T 12MAY 7 PHXLAS HK1 815P 923P 12MAY E US/A4PRHM
4 US 392 K 13MAY 1 LASCLT HK1 115A 827A 13MAY E US/A4PRHM
5 US4286 K 13MAY 1 CLTFAY HK1 955A1050A 13MAY E US/A4PRHM
OPERATED BY SUBSIDIARY/FRANCHISE
6 MIS 1A HK1 NYC 11JAN-THANK YOU FOR YOUR BUSINESS
7 AP NYC9103161516
8 APE FRANCISKHON@GMAIL.COM
9 TK OK06MAY/NYC1S21DD//ETUS
10 SSR DOCS US HK1 ////09NOV83/M//KHOON/FRANCIS
11 OSI US TKT NO 037-7244752856
12 OSI US TKT NO 037-7244752857
13 OSI US TKT NO 037-7244752858
14 OSI US TKT NO 037-7244752859
15 OSI US TKT NO 037-7244752860
16 OSI US TKT NO 037-7244752861
17 OSI US TKT NO 037-7244752862
18 OSI US TKT NO 037-7244752863
FXR
01 KHOON/FRANC*
ITINERARY REBOOKED //It contain ITINERATY REBOOKED so fetch that PNR numebr
LAST TKT DTE 06MAY13 - SEE ADV PURCHASE
------------------------------------------------------------
AL FLGT BK DATE TIME FARE BASIS NVB NVA BG
GEG
XPHX US 152 K * 12MAY 1500 KXA0NL6P 12MAY12MAY 0P
LAS US 184 K * 12MAY 2015 KXA0NL6P 12MAY12MAY 0P
XCLT US 392 K 13MAY 0115 KXA7NJ6 13MAY13MAY 0P
FAY US 4286 K 13MAY 0955 KXA7NJ6 13MAY13MAY 0P
USD 290.24 12MAY13GEG US X/PHX US LAS144.19KXA0NL6P
US X/CLT US FAY146.05KXA7NJ6 USD290.24END
USD 21.76US ZP GEG3.90PHX3.90LAS3.90CLT3.90XT USD
USD 5.00AY 15.60ZP USD 9.00XF GEG4.50PHX4.50
USD 24.60XT
USD 341.60
BG CXR: US
PRICED WITH VALIDATING CARRIER US - REPRICE IF DIFFERENT VC
> PAGE 2/ 3
>";
string Second=@"rt298BFB
--- TST RLR MSC ---
RP/NYC1S21DD/NYC1S21DD UA/RM 6MAY13/0452Z 298BFB // This is PNR number
NYC1S21DD/9999WS/6MAY13
1.BELIEU/KENNETH E(ADT) 2.BELIEU/RUTH J(ADT)
3 UA 646 Q 22JUN 6*PDXORD HK2 603A1150A 22JUN E UA/GW0LVJ
4 UA1735 Q 22JUN 6*ORDBWI HK2 115P 409P 22JUN E UA/GW0LVJ
5 UA 209 S 01JUL 1*BWIIAH HK2 545A 800A 01JUL E UA/GW0LVJ
6 UA 258 S 01JUL 1*IAHPDX HK2 856A1120A 01JUL E UA/GW0LVJ
7 MIS 1A HK2 NYC 11JAN-THANK YOU FOR YOUR BUSINESS
8 MCO XD ARC 06MAY/USD 44.00/*SERVICE FEE/P1
9 AP NYC5093952712
10 API CHEAPOAIR, 213 WEST 35TH STREET, SUITE 1201, NEW YORK,
NY 10001
11 TK OK06MAY/NYC1S21DD//ETUA
12 SSR SEAT UA KK2 PDXORD/36AN,P1/36BN,P2/RB/S3
13 SSR SEAT UA KK2 ORDBWI/31FN,P1/31EN,P2/RB/S4
14 SSR SEAT UA KK2 BWIIAH/24EN,P1/24FN,P2/RB/S5
15 SSR SEAT UA KK2 IAHPDX/25AN,P1/25BN,P2/RB/S6
16 SSR DOCS UA HK1 ////18JUL41/M//BELIEU/KENNETH/E/P1
17 SSR DOCS UA HK1 ////23JUL49/F//BELIEU/RUTH/J/P2
18 OSI UA TKT NO 016-7244752674
19 OSI UA TKT NO 016-7244752675
)>sp1
--- TST RLR MSC ---
-ASSOCIATE PNR-
RP/NYC1S21DD/NYC1S21DD UA/RM 6MAY13/0452Z XXXXXX
1.BELIEU/KENNETH E(ADT)
2 UA 646 Q 22JUN 6*PDXORD HK1 603A1150A 22JUN E UA/GW0LVJ
3 UA1735 Q 22JUN 6*ORDBWI HK1 115P 409P 22JUN E UA/GW0LVJ
4 UA 209 S 01JUL 1*BWIIAH HK1 545A 800A 01JUL E UA/GW0LVJ
5 UA 258 S 01JUL 1*IAHPDX HK1 856A1120A 01JUL E UA/GW0LVJ
6 MIS 1A HK1 NYC 11JAN-THANK YOU FOR YOUR BUSINESS
7 MCO XD ARC 06MAY/USD 44.00/*SERVICE FEE
8 AP NYC5093952712
9 API CHEAPOAIR, 213 WEST 35TH STREET, SUITE 1201, NEW YORK,
NY 10001
10 TK OK06MAY/NYC1S21DD//ETUA
11 SSR SEAT UA KK1 PDXORD/36AN,P1/RB/S2
12 SSR SEAT UA KK1 BWIIAH/24EN,P1/RB/S4
13 SSR SEAT UA KK1 IAHPDX/25AN,P1/RB/S5
14 SSR SEAT UA KK1 ORDBWI/31FN,P1/RB/S3
15 SSR DOCS UA HK1 ////18JUL41/M//BELIEU/KENNETH/E
16 OSI UA TKT NO 016-7244752674
17 OSI UA TKT NO 016-7244752675
18 AI AN2124780335
)>FXR
FXR
01 BELIEU/KENNE*
NO REBOOKING REQUIRED FOR LOWEST AVAILABLE FARE //it contain no booking so dont want that PNR number
LAST TKT DTE 07MAY13 - SEE ADV PURCHASE
------------------------------------------------------------
AL FLGT BK DATE TIME FARE BASIS NVB NVA BG
PDX
XCHI UA 646 Q 22JUN 0603 QA7KN 22JUN22JUN 0P
BWI UA 1735 Q 22JUN 1315 QA7KN 22JUN22JUN 0P
XHOU UA 209 S 01JUL 0545 SA7KN 01JUL01JUL 0P
PDX UA 258 S 01JUL 0856 SA7KN 01JUL01JUL 0P
USD 547.91 22JUN13PDX UA X/CHI UA BWI323.72QA7KN UA
X/HOU UA PDX224.19SA7KN USD547.91END
USD 41.09US ZP PDX3.90ORD3.90BWI3.90IAH3.90XT USD
USD 10.00AY 15.60ZP USD 16.50XF PDX4.50ORD4.50BWI4.50
USD 32.10XT IAH3.00
USD 631.10
BG CXR: UA
PRICED WITH VALIDATING CARRIER UA - REPRICE IF DIFFERENT VC
>";
The regex i am using rite now is (\s[A-Z0-9]{6}\s{2})(?=(.*ITINERARY.REBOOKED.?))
it will give me PNR number which contain ITINERARY REBOOKED but i want first condition to
Thanks in advance
Submit an article or tip