SOLVED
Two Regex Scenarios
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
BRRLL99
11 - Bolide
‎03-18-2024
01:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have 2 regex scenarios
first:
ABC OUR A/C 315-915073-590 AKL-MY |
HSC BANK A/C 123-654321-100 AUD-MY |
ABCHSBC BANK A/C 321-123456-900 |
HSC BANK ACCOUNT NO 143-654321-100 AUD-MY |
Expected out: ( All numbers should be separate column, and in Last if MY contains then MY should be shown)
i tried using (\d{3})-(\d{6})-(\d{3}) , after this i have to add formula tool
315 | 915073 | 590 | MY |
123 | 654321 | 100 | MY |
321 | 123456 | 900 | |
143 | 654321 | 100 | MY |
Second:
id |
1009088 //03788810 OUTGOING ABCBANK |
SRE 97004 //NZS0123E45J9 1/ INTERNATIONAL SERVICE |
ARE 91004 //AUD99123E45ZX9 GLOBAL ACCOUNT |
1119088 //05788810 OUTGOING ABCBANK SERVICES |
Expected output:
3788810 |
NZS0123E45J9 |
AUD99123E45ZX9 |
5788810 |
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
5 REPLIES 5
aatalai
14 - Magnetar
‎03-18-2024
01:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BRRLL99 take a look at the workflow attached, did both in one hope it helps
flying008
15 - Aurora
‎03-18-2024
07:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-20-2024
11:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@aatalai @flying008
In the expected out i would like to include //
id |
1009088 //03788810 OUTGOING ABCBANK |
SRE 97004 //NZS0123E45J9 1/ INTERNATIONAL SERVICE |
ARE 91004 //AUD99123E45ZX9 GLOBAL ACCOUNT |
1119088 //05788810 OUTGOING ABCBANK SERVICES |
Expected output:
//3788810 |
//NZS0123E45J9 |
//AUD99123E45ZX9 |
//5788810 |
aatalai
14 - Magnetar
‎03-21-2024
01:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BRRLL99 this should do the trick
flying008
15 - Aurora
‎03-21-2024
04:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @BRRLL99
Please change the regex expression (?:\/\/)(\w+?)(?=\s) to (\/\/\w+?)(?=\s)
Then try again.
