Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Travel Desk: Update Travel Port Parse tool #231

Open
dpdavids opened this issue Oct 8, 2024 · 2 comments
Open

Travel Desk: Update Travel Port Parse tool #231

dpdavids opened this issue Oct 8, 2024 · 2 comments

Comments

@dpdavids
Copy link

dpdavids commented Oct 8, 2024

Update the Travel Port Text Parsing tool to parse the raw information.

Parse Example:
In this sample, I am providing two options I think best “to” Toronto and return “to” Whitehorse.

1 . AC 8098 V 12JUL YXYYVR SS1 0500 0721 * E SA 1
OPERATED BY AIR CANADA EXPRESS - JAZZ
2 . AC 34 V 12JUL YVRYYZ SS1 0900 1626 * E SA 1
3 . 4N 509 Y 12JUL YXYYVR GK1 0700 0915 SA
4 . WS 714 B 12JUL YVRYYZ SS1 1315 2047 * E SA
5 . AC 101 S 20JUL YYZYVR SS1 0700 0850 * E SU 2
6 . AC 8099 S 20JUL YVRYXY SS1 1350 1614 * E SU 2
OPERATED BY AIR CANADA EXPRESS - JAZZ
7 . WS 705 B 12JUL YYZYVR SS1 0900 1113 * E SA
8 . 4N 540 Y 12JUL YVRYXY GK1 1415 1640 SA

Information mapping:
1 AC 8098 V 12JUL YXYYVR SS1 0500 0721 * E SA 1

1 flight segment #
AC Airline code - Air Canada). If the is an @ symbol (@ac), it that identifies a co-shard flight, and the flight is operated by another carrier.
8098 flight number)
V booking fare level code
12Jul day/month
YXY Whitehorse – departure city
YVR Vancouver – arrival city
SS holding unconfirmed
1 # of seats
0500 departure time
0721 arrival time
(*) identifies as active
E identifies electronic ticketing
SA day of the week – Saturday
1 identifies married segments or segments that are together and must be changed together

@dpdavids dpdavids converted this from a draft issue Oct 8, 2024
@klondikemarlen
Copy link
Member

Example 1

Note that formatting has been destroyed by copying this out of the email.

Draft – raw data

 

1 . 4N  521 Y  25NOV YXYYVR GK1  1045   1200              MO       

 2 . AC  118 S  25NOV YVRYYZ SS1  1400   2126  *         E MO        

 3 . AC  105 L  30NOV YYZYVR SS1  0945   1149  *         E SA       

 4 . 4N  540 Y  30NOV YVRYXY GK1  1430   1755              SA       

 

 

Converted to readable version – no clean up.

 

Flights:

Air North 4N521

Departure:         25 Nov 10:45    Whitehorse Arpt (YXY)  Terminal:

Arrival:                 25 Nov 12:00    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 15 Minutes

Status:                 Confirmed (Passive)

Class:                   Y

 

 

Air Canada AC118

Departure:         25 Nov 14:00    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 25 Nov 21:26    Lester B Pearson Intl (YYZ)         Terminal: 1

Duration:            4 Hour(s) 26 Minutes

Status:                 Sold

Class:                   S

 

 

Air Canada AC105

Departure:         30 Nov 09:45    Lester B Pearson Intl (YYZ)         Terminal: 1

Arrival:                 30 Nov 11:49    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            5 Hour(s) 4 Minutes

Status:                 Sold

Class:                   L

 

 

Air North 4N540

Departure:         30 Nov 14:30    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 30 Nov 17:55    Whitehorse Arpt (YXY)  Terminal:

Duration:            3 Hour(s) 25 Minutes

Status:                 Confirmed (Passive)

Class:                   Y

 

 

 

“Subject to availability at time of booking, additional charges may apply (baggage fee, seat fee…), includes taxes”

or “conditions may apply, subject to change”

08-10-2024 08:23:47 AM

 

 

 

Converted to readable version – with clean up

 

 

 

Air Cost: $1,060.58

 

Air North 4N521

Departure:         25 Nov 10:45    Whitehorse Arpt (YXY)  Terminal:

Arrival:                 25 Nov 12:00    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 15 Minutes

Class:                   Y

 

 

Air Canada AC118

Departure:         25 Nov 14:00    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 25 Nov 21:26    Lester B Pearson Intl (YYZ)         Terminal: 1

Duration:            4 Hour(s) 26 Minutes

Class:                   S

 

 

Air Canada AC105

Departure:         30 Nov 09:45    Lester B Pearson Intl (YYZ)         Terminal: 1

Arrival:                 30 Nov 11:49    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            5 Hour(s) 4 Minutes

Class:                   L

 

 

Air North 4N540

Departure:         30 Nov 14:30    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 30 Nov 17:55    Whitehorse Arpt (YXY)  Terminal:

Duration:            3 Hour(s) 25 Minutes

Class:                   Y

@klondikemarlen
Copy link
Member

Example 2

Note that formatting has been destroyed by copying this out of the email.

Draft – raw data

 

1 . WS 3566 B  03DEC YXCYYC SS1  0625   0709  *         E TU       

         OPERATED BY WESTJET ENCORE

2 . WS  107 B  03DEC YYCYVR SS1  0900   0947  *         E TU       

 3 . 4N  564 Y  03DEC YVRYXY GK1  1430   1755              TU       

 4 . AC 8299 K  03DEC YXCYVR SS1  1610   1639  *         E TU       

         OPERATED BY AIR CANADA EXPRESS - JAZZ

5 . 4N  594 Y  03DEC YVRYXY GK1  2050   0015 +            TU/WE    

 6 . 4N  519 Y  07DEC YXYYVR SS1  0820   0935  *         E SA       

 7 . AC 8298 K  07DEC YVRYXC SS1  1300   1521  *         E SA       

         OPERATED BY AIR CANADA EXPRESS – JAZZ

 

 

Converted to readable version – no clean up.

 

Flights:

WestJet WS3566 - Operated By: WESTJET ENCORE

Departure:         03 Dec 06:25    Cranbrook Municipal (YXC)       Terminal:

Arrival:                 03 Dec 07:09    Calgary Intl Arpt (YYC)  Terminal:

Duration:            0 Hour(s) 44 Minutes

Status:                 Sold

Class:                   B

 

 

WestJet WS107

Departure:         03 Dec 09:00    Calgary Intl Arpt (YYC)  Terminal:

Arrival:                 03 Dec 09:47    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 47 Minutes

Status:                 Sold

Class:                   B

 

 

Air North 4N564

Departure:         03 Dec 14:30    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 03 Dec 17:55    Whitehorse Arpt (YXY)  Terminal:

Duration:            3 Hour(s) 25 Minutes

Status:                 Confirmed (Passive)

Class:                   Y

 

 

Air Canada AC8299 - Operated By: AIR CANADA EXPRESS - JAZZ

Departure:         03 Dec 16:10    Cranbrook Municipal (YXC)       Terminal:

Arrival:                 03 Dec 16:39    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 29 Minutes

Status:                 Sold

Class:                   K

 

 

Air North 4N594

Departure:         03 Dec 20:50    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 04 Dec 00:15    Whitehorse Arpt (YXY)  Terminal:

Duration:            3 Hour(s) 25 Minutes

Status:                 Confirmed (Passive)

Class:                   Y

 

 

Air North 4N519

Departure:         07 Dec 08:20    Whitehorse Arpt (YXY)  Terminal:

Arrival:                 07 Dec 09:35    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 15 Minutes

Status:                 Sold

Class:                   Y

 

 

Air Canada AC8298 - Operated By: AIR CANADA EXPRESS - JAZZ

Departure:         07 Dec 13:00    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 07 Dec 15:21    Cranbrook Municipal (YXC)       Terminal:

Duration:            1 Hour(s) 21 Minutes

Status:                 Sold

Class:                   K

 

 

 

“Subject to availability at time of booking, additional charges may apply (baggage fee, seat fee…), includes taxes”

or “conditions may apply, subject to change”

10-10-2024 08:00:11 AM

 

 

Converted to readable version – with clean up

 

Departure

 

A)$318.79

 

WestJet WS3566 - Operated By: WESTJET ENCORE

Departure:         03 Dec 06:25    Cranbrook Municipal (YXC)       Terminal:

Arrival:                 03 Dec 07:09    Calgary Intl Arpt (YYC)  Terminal:

Duration:            0 Hour(s) 44 Minutes

Class:                   B

 

 

WestJet WS107

Departure:         03 Dec 09:00    Calgary Intl Arpt (YYC)  Terminal:

Arrival:                 03 Dec 09:47    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 47 Minutes

Class:                   B

 

 

Air North 4N564

Departure:         03 Dec 14:30    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 03 Dec 17:55    Whitehorse Arpt (YXY)  Terminal:

Duration:            3 Hour(s) 25 Minutes

Class:                   Y

 

 

B)$351.79

 

Air Canada AC8299 - Operated By: AIR CANADA EXPRESS - JAZZ

Departure:         03 Dec 16:10    Cranbrook Municipal (YXC)       Terminal:

Arrival:                 03 Dec 16:39    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 29 Minutes

Class:                   K

 

 

Air North 4N594

Departure:         03 Dec 20:50    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 04 Dec 00:15    Whitehorse Arpt (YXY)  Terminal:

Duration:            3 Hour(s) 25 Minutes

Class:                   Y

 

 

Return

 

$353.79

 

Air North 4N519

Departure:         07 Dec 08:20    Whitehorse Arpt (YXY)  Terminal:

Arrival:                 07 Dec 09:35    Vancouver Intl Arpt (YVR)           Terminal: M

Duration:            1 Hour(s) 15 Minutes

Class:                   Y

 

 

Air Canada AC8298 - Operated By: AIR CANADA EXPRESS - JAZZ

Departure:         07 Dec 13:00    Vancouver Intl Arpt (YVR)           Terminal: M

Arrival:                 07 Dec 15:21    Cranbrook Municipal (YXC)       Terminal:

Duration:            1 Hour(s) 21 Minutes

Class:                   K

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: 🔖 Ready
Development

No branches or pull requests

2 participants