I wanted to loop from the result of each matches and then match the index of the result .
The first regex match is to get the dates and the second one is to get company names
first regex is to get dates : “^(\d{2}/\d{2}/\d{2} | \s)”
2nd regex to get company : “”(?<=\d{3,8}\s+)[A-Z].?(?=\s+[A-Z]{3}\s$)“”
Data where I am extracting the date ang company name which is a string
RajivKumar12
I was talking about this data:
"Filtered Data: −−DATE−− ECOA KOB MEMBER−NO
06/12/20 B QM 02004946 TEST DATA MORTGAGE TRU
04/22/20 B BC 2844550 COMPANY XCYS XPN
BC 03575459 CAPITAL ONE TRU
BB 484BB05812 CAPITALTWO EFX
04/16/20 B FR 3996926 CRET XPN
181ZB14416 CREDOS EFX
FM 01207005 BANK R TRU"
Output I wanna chieved.
06/12/20 TEST DATA MORTGAG
04/22/20 COMPANY XCYS
04/22/20 CAPITAL ONE
04/22/20 CAPITALTWO
04/16/20 CRET
04/16/20 CREDOS
04/16/20 BANK R
Any idea thanks.