Hello,
I have a .prn file with variable length delimiters, I am able to parse the data, but I need to throw in the reconcilliation records from the file into another excel/ csv file, please help, thank you in advance. The below lines will be mid of file. The number of lines in between Retriement Category and the --------------- can change from day to day.
Final Report Totals
Totals For Tax Year 2023
-------------------------
Retirement Category Accounts Tran Total
Contribution & Roth Conv Dep 11 350.00
IRA Death W/d (4) 12 -4,000.19
IRA W/d before 59 1/2 (1) 1 -5,000.00
IRA W/d over age 59 1/2 (7) 110 -63,000.17
Tfr to bank, cu, invest 5 -2,000.73
Totals For Tax Year Other
-------------------------
Retirement Category Accounts Tran Total
Category Not Specified 115 0.00
