I am attempting to get multiple items from a text string. I have the following text [example]. My thinking is to match [ACH Credit Received] first and then pull the required information. The data I am trying to pull is in BOLD. In theory we want to not pull anything after “ACH Credit Received Total”
What I have so far is below, but I am having problems grabbing all the information.
ACH\sCredit\s\sReceived\s.\s(\d*,?\d*,?\d+.\d+)
Description Amount (USD)
ACH Credit Received
PEPSI LOGISTICS,CORP PAY,06200001000953
3,423.62 3,423.62
ACH Credit Received
DISNEY LOGISTICS,CORP PAY,062000016164953
5,423.62 3,423.62
ACH Credit Received
CHICAGO LOGISTICS,CORP PAY,0620000920124953
7,423.62 3,423.62
9801156643,0000342362,MHC FINANCIAL SERVICES
ACH Credit Received
MURPHY BROWN,GENERATED,A C H,02015560212358
706,041.57 706,041.57
9801148443,0070604157,FL# 20153000158,MHC
ACH Credit Received Total: 4 Item(s) 709,465.19 .00 .00 709,465.19