SOLVED
Search for a word within a string
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lagos-a1
6 - Meteoroid
‎01-05-2023
10:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
I am trying to extract the #pax word from the following strings.
Input | Output |
1IFCHK 22.08 COLLAB (6 pax) VC AC | 6 |
9HUNTER 9.04 Collab (10 pax) VC AC WB | 10 |
1IFCHK 23.14 TEAM (6 pax) VC AC | 6 |
1IFCHK23.11TEAM5paxVCAC | 5 |
1IFCHK23.12TEAM7paxVCAC | 7 |
9HUNTER 9.17 Collab (14 pax) VC AC WB | 14 |
1IFCHK 18.05 Shared (6 pax) VC AC | 6 |
1IFCHK 18.03 COLLAB (2 pax) VC AC | 2 |
9HUNTER 9.09 Collab (8 pax) VC AC WB | 8 |
Notice that some are with () and other are without any space.
I have tried a couple of ways, but I have not been able to achieve the final output. Any clue?
Many thanks.
Solved! Go to Solution.
3 REPLIES 3
Felipe_Ribeir0
16 - Nebula
‎01-05-2023
10:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-05-2023
10:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your help. Your solution worked!
Felipe_Ribeir0
16 - Nebula
‎01-06-2023
03:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @lagos-a1
I am glad it worked. Could you please accept my answer as a solution so the topic can be considered closed?
Thanks!