Getting 2 regex side by side


#1

Hi,

I have this task to return the number and the dollar amount in one line.
I have already have 2 separate regex that return the correct result, but how can I combine them? For example,

Charge
1 EA 3,785.36 EA 3,785.36
22118

0020 S10120 1
1 EA 5,227.52 EA 5,227.52
22119

0030 S10120 1
Charge
1 EA 1,781.50 EA 1,781.50
22116

I used matches to get 3,785.36, 5,227.52 and 1,781.50
and another matches to get 22118, 22119, 22116

I need to make sure that the corresponding number is align with the dollar amount right in front of it:

22118 3,785.36
22119 5,227.52

ideally put them into excel sheet

Main.xaml (10.7 KB)

can’t attach the txt file for some reasons but it looks like this:

Charge
1 EA 3,785.36 EA 3,785.36
22118



0020 S10120 1
1 EA 5,227.52 EA 5,227.52
22119


0030 S10120 1
Charge
1 EA 1,781.50 EA 1,781.50
22116


0050 S10121 1 Fee 1 EA 1,126.52 EA 1,126.52
22118


0060 S10121 1 Fee 1 EA 1,199.38 EA 1,199.38
22119

Charge
1 EA 357.00 EA 357.00
22009


0090 S10120 1
Charge
1 EA 1,804.00 EA 1,804.00
22251


0100 S10120 1
Charge
1 EA 162.00 EA 162.00
22273

Can someone help? Thanks