Multiple extractions using regex

Help Activities
,
1

Hi, I just want to extract the different airports. If it’s possible to use different expressions for the first half of the trip (arrival and departure airports) then another expression for the second half of the trip (arrival and departure airports). The expressions should work regardless of what kind of airline. This is really challenging and I have no idea how to do…

Text 1:
Leg 1 of Singapore (SIN) toDubai (DXB) Operated by Emirates (equipment owner - Emirales) Flight Check-in: at Departure 349 05Nov2022 05Nov2022 07:10 10:10 Departing SIN, Changi Airport Economy Terminal 1 Saver Seat Status Arrival Confirmed 05Nov2022 13:50 Arriving DXB, Dubai International Terminal 3 Coupon validity: not before 05Nov2022 / not after 05Nov2022 IEl Baggage 2Piece Leg 2of2 Dubai (DXB) loCairo (CAI)

Text 2:
Flight 1 Thu, 23 Mar 2023 1 hours 5 minutes X 12: Singapore (SIN) T4 9 13:15 Kuala Lumpur (KUL) KLIA2 AK 706 1 hours 5 minutes Flight 2 Fri, 24 Mar 2023 1 hours 10 minutes X 20: 45 Kuala Lumpur (KUL) KLIA2 9 21:55 Singapore (SIN)

Text 3:
1 Depari: Singapore to Amriisar Ry TR 508 ( Scoot 789-TRC] - hh05min Depart Singapore (SIN) 15:10 787 Singapore . Changi Airpont Termnal 1 November 2019 Check-in time : Frl. 08 NOv 2019 12:10 Arrive Amritsar (ATQ) 18:45 Fare Class: W1 Amritsar . Amritsar International Termnal 08 November 2019 2 Return: Amritsar to Singapore Ry TR 509 ( Scoot 789-TRC = 5h45min Depart Amritsar (ATQ) 19:45 787 Amitsor * Amntsar Inemnabional Terminal Noverrber 2019 Check-in tme : Frt, 22 Nov 2019 16:45 Arrive Singapore (SIN)

Text 4:
From Jakarta (CGK-Sockamo Inti) Terminal: 2F Depart Sat 29 Dec 2016 18:00 Status: Confirmed To: Singapore (SIN-Changl) Terminal: 3 Arrive: Sat, 29 Dec 2016 20:45 Stopovers: o No vald Basora: 20 Dee 16 Nal VaEd Altr 20 Dec 16 Baggage Allowance: 2 Pes SO 636 Operated by Singapore Aidines Economy Class (Q) From. Singapore (SIN-Changl IntQ Temminal: 3 Depart Sat 29 Des 2016 23:55 Stalus: Confirmed To: Tokyo (NRT-Narlla. Intl)

2

Hi @helpplease

Please specify what is the output you need.

Regards

3

The bolded words are the output i want.

4

Hello

Try this pattern:
\w+(?=\s([A-Z]{3})

Or this pattern for the Capital letters:
(?<=\s\()[A-Z]{3}

image
image1170×1227 176 KB

Capital letters in brackets is better imo.

Cheers

Steve

5

or this way, also can. Which ever is possible
.
.
.

Text 1:
Leg 1 of Singapore (SIN) toDubai (DXB) Operated by Emirates (equipment owner - Emirales) Flight Check-in: at Departure 349 05Nov2022 05Nov2022 07:10 10:10 Departing SIN, Changi Airport Economy Terminal 1 Saver Seat Status Arrival Confirmed 05Nov2022 13:50 Arriving DXB, Dubai International Terminal 3 Coupon validity: not before 05Nov2022 / not after 05Nov2022 IEl Baggage 2Piece Leg 2of2 Dubai (DXB) loCairo (CAI)

Text 2:
Flight 1 Thu, 23 Mar 2023 1 hours 5 minutes X 12: Singapore (SIN) T4 9 13:15 Kuala Lumpur (KUL) KLIA2 AK 706 1 hours 5 minutes Flight 2 Fri, 24 Mar 2023 1 hours 10 minutes X 20: 45 Kuala Lumpur (KUL) KLIA2 9 21:55 Singapore (SIN)

Text 3:
1 Depari: Singapore to Amriisar Ry TR 508 ( Scoot 789-TRC] - hh05min Depart Singapore (SIN) 15:10 787 Singapore . Changi Airpont Termnal 1 November 2019 Check-in time : Frl. 08 NOv 2019 12:10 Arrive Amritsar (ATQ) 18:45 Fare Class: W1 Amritsar . Amritsar International Termnal 08 November 2019 2 Return: Amritsar to Singapore Ry TR 509 ( Scoot 789-TRC = 5h45min Depart Amritsar (ATQ) 19:45 787 Amitsor * Amntsar Inemnabional Terminal Noverrber 2019 Check-in tme : Frt, 22 Nov 2019 16:45 Arrive Singapore (SIN)

Text 4:
From Jakarta (CGK-Sockamo Inti) Terminal: 2F Depart Sat 29 Dec 2016 18:00 Status: Confirmed To: Singapore (SIN-Changl) Terminal: 3 Arrive: Sat, 29 Dec 2016 20:45 Stopovers: o No vald Basora: 20 Dee 16 Nal VaEd Altr 20 Dec 16 Baggage Allowance: 2 Pes SO 636 Operated by Singapore Aidines Economy Class (Q) From. Singapore (SIN-Changl IntQ Temminal: 3 Depart Sat 29 Des 2016 23:55 Stalus: Confirmed To: Tokyo (NRT-Narlla. Intl)

6

Hi @helpplease

\b(?<=\()[A-Z]{3}\b

You can use above regex pattern in Find Matching Patterns Activity.

Matches= System.Text.RegularExpressions.Regex.Matches(yourstringinput,"\b(?<=\()[A-Z]{3}\b")

Datatype of Matches is IEnumerable(System.Text.RegularExpressions.Match)

image
image1429×822 107 KB

Hope it helps!!

7

but it will only extract out the first (XXX) in the texts, I need all of it :sob:

8

i tried the capital letters in brackets, but it will only extract out the first (XXX) in the texts, I need all of it :sob:

9

first airport

10

@helpplease
Try this. This will work.

input="Leg 1 of Singapore (SIN) toDubai (DXB) Operated by Emirates (equipment owner - Emirales) Flight Check-in: at Departure 349 05Nov2022 05Nov2022 07:10 10:10 Departing SIN, Changi Airport Economy Terminal 1 Saver Seat Status Arrival Confirmed 05Nov2022 13:50 Arriving DXB, Dubai International Terminal 3 Coupon validity: not before 05Nov2022 / not after 05Nov2022 IEl Baggage 2Piece Leg 2of2 Dubai (DXB) loCairo (CAI)

Flight 1 Thu, 23 Mar 2023 1 hours 5 minutes X 12: Singapore (SIN) T4 9 13:15 Kuala Lumpur (KUL) KLIA2 AK 706 1 hours 5 minutes Flight 2 Fri, 24 Mar 2023 1 hours 10 minutes X 20: 45 Kuala Lumpur (KUL) KLIA2 9 21:55 Singapore (SIN)

1 Depari: Singapore to Amriisar Ry TR 508 ( Scoot 789-TRC] - hh05min Depart Singapore (SIN) 15:10 787 Singapore . Changi Airpont Termnal 1 November 2019 Check-in time : Frl. 08 NOv 2019 12:10 Arrive Amritsar (ATQ) 18:45 Fare Class: W1 Amritsar . Amritsar International Termnal 08 November 2019 2 Return: Amritsar to Singapore Ry TR 509 ( Scoot 789-TRC = 5h45min Depart Amritsar (ATQ) 19:45 787 Amitsor * Amntsar Inemnabional Terminal Noverrber 2019 Check-in tme : Frt, 22 Nov 2019 16:45 Arrive Singapore (SIN)

From Jakarta (CGK-Sockamo Inti) Terminal: 2F Depart Sat 29 Dec 2016 18:00 Status: Confirmed To: Singapore (SIN-Changl) Terminal: 3 Arrive: Sat, 29 Dec 2016 20:45 Stopovers: o No vald Basora: 20 Dee 16 Nal VaEd Altr 20 Dec 16 Baggage Allowance: 2 Pes SO 636 Operated by Singapore Aidines Economy Class (Q) From. Singapore (SIN-Changl IntQ Temminal: 3 Depart Sat 29 Des 2016 23:55 Stalus: Confirmed To: Tokyo (NRT-Narlla. Intl)"

Matches= System.Text.RegularExpressions.Regex.Matches(input,"\b(?<=\()[A-Z]{3}\b")

Datatype of input is System.String
Datatype of Matches is IEnumerable(System.Text.RegularExpressions.Match)

image
image1063×663 59.2 KB

image
image610×589 13.9 KB

Regards

12

Hello

That is because I didn’t use all the sample data.

Cheers

Steve

13

Curious if this worked?
ryanbrownuipath

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.