Regex

[BRRLL99]

I have following input

Field_1

i|

ARC231

500 - HBAU CARD|JOURNAL BY CODE|FILE DATE 30/01/2027|PAGE|

550 - VISA

|Z Z|

|R R|

i|

ARC231

577 - HBAU CARD|JOURNAL BY CODE|FILE DATE 01/01/2027|PAGE|

551 - VISA

|Z Z|

|R R|

Expected output:  HBAU before digits should be picked

                              VISA before digits should be picked and file date

Field_1	ID_1	ID_2	FILE DATE
i|
ARC231
500 - HBAU CARD|JOURNAL BY CODE|FILE DATE 30/01/2027|PAGE|	500	550	30/01/2024
550 - VISA
|Z Z|
|R R|
i|
ARC231
577 - HBAU CARD|JOURNAL BY CODE|FILE DATE 01/01/2027|PAGE|	577	551	1/1/2027
551 - VISA
|Z Z|
|R R|

[Raj]

@BRRLL99 
please find attached and
mark as done if solved.

[BRRLL99]

500-HBAU

550-VISA

if i remove spaces the regex function is not not working I'm looking for dynamic solution

[Raj · Accepted solution]

@BRRLL99 
update with the following

(\d{3})\s*-\s*HBAU CARD
(\d{3})\s*-\s*VISA
FILE DATE\s*(\d{2}/\d{2}/\d{4})

mark as done if solved.

[PhilipMannering]

@OllieClarke What have you tried?

[BRRLL99]

@PhilipMannering 

Please look into this

Solved: Re: find which combination equals amount - Page 2 - Alteryx Community