Two Regex Scenarios

[BRRLL99]

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

[aatalai · Accepted solution]

@BRRLL99 take a look at the workflow attached, did both in one hope it helps

[flying008 · Accepted solution]

Hi, @BRRLL99 

FYI.

[BRRLL99]

@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 · Accepted solution]

@BRRLL99 this should do the trick

[flying008 · Accepted solution]

Hi, @BRRLL99 

Please change the regex expression (?:\/\/)(\w+?)(?=\s) to (\/\/\w+?)(?=\s)

Then try again.