Regex to extract amount in a multi line data

I wanted to extract every amount after 8 Ending Inventory (5+6+7) . for example on the text file below the output are 0.00 and 2,270,059.60 . It should get all the amount on multi lines after 8 Ending Inventory (5+6+7) . Thanks for any idea .

The data is in the text file
datatext.txt (873 Bytes)


Can you try the following pattern?

"(?<=8 Ending nventory \(5\+6\+7\)\s*)[.,\d]+" (2.7 KB)


1 Like

maybe we can bind it on the 9 as an achor:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.