Need help parsing a text that has no delimiters
I am stuck parsing out a text file. I have figured out how to mark only the lines of the text that are truly data lines. I have been able to eliminate the fluff lines, i.e. headers, blank lines, footers, etc.
The report is an AP Edit Listing. I can parse out the parts of the data lines that are the:
INVOICE NUMBER, and
Where I am having a problem is the invoice amount. The specific problem is the credit memos. When the report is written it has two oddities. The first is that the numbers are left justified, not right justified. Decimals are not aligned. The second is that the minus sign is at the end of the number, not the beginning.
My calculation that best works is Middle (input_line, 68, 12). i get the number and the minus sign at the end. If i set the field to text, it shows the number as 279.02-. If I change it to show as number, it ends up 279.02. When I use a summary field to total it, it is off exactly by the amount of treating the credit as a debit.
Any suggestions? I am really stumped.