Getting 2 regex side by side

Help
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

2

Hello

Patience is a virtue - two years later here we are :smiley:

Try this regex pattern:
(EA\s)(..\d\d)( EA\s..\d\d\n)(\d*)

Then use an ‘Assign’ activity to piece the matches/groups together:
RESULT = INSERTVARIABLE(0).Groups(4).ToString + INSERTVARIABLE(0).Groups(2).ToString

image
image1242×958 286 KB
image
image1061×2140 324 KB

This should solve it!

Please mark as solved if I got it right! :slight_smile:

Cheers