Nick Burns
Member
- Joined
- May 24, 2017
- Messages
- 162
- Reaction score
- 0
- Points
- 16
- Excel Version(s)
- Office 365
There's a method to my madness, but go with me here.
I'm reading a Fixed-Length Text file. I'd like to parse it manually rather than PQ doing automatically.
I've got the logic down to the List of each field length, but I'm not sure how to get a list of each "field" from these lengths.
I'm not sure if I'd use List.Accumulate or another List.Transform.
I've attached a file that gets as far as the list of the lengths not sure what my next step is.
I'm reading a Fixed-Length Text file. I'd like to parse it manually rather than PQ doing automatically.
I've got the logic down to the List of each field length, but I'm not sure how to get a list of each "field" from these lengths.
I'm not sure if I'd use List.Accumulate or another List.Transform.
I've attached a file that gets as far as the list of the lengths not sure what my next step is.