Hi All
Can anyone offer any advice or solution as to how to parse the attached text file?
Creating the field names is fairly straightforward, but I am a little stuck with the body of the file.Thanks in advance.
@mattpears78 Maybe it is from some PDF?
Can you also share what it looks like in orginal format?
Unfortunately the production files are .txt files with the same structure as the one attached with dummy data.
Hey @mattpears78 !
Hope you're doing well.
You'll need to read it as a fixed width text file to get what you want. Then from there parse it to what you need.
I did some basic work for you, and even attached the config file used so you can replicate.
I even created the RunTot Flag concept for you here:
Do as you see fit to get what you need from there.
