Parsing Help

lwolfie

I need help Regex gurus. I have data in the attached file that needs to be parsed out into 4 columns. I included a screenshot on the output tab of what it should have in the 4 columns. I can get 75% of the way there but I can't get that last bit. I have tried a bunch of different ways, but the problem is that it's not a set width and separated by spaces.

ParseHelp.yxmd

jrlindem

Can you elaborate more on what part you're missing? I see that you've used the start positions to get at the different columns of information. That's the same approach I would have taken.

But you've got records that span across multiple rows of data…

Associating them requires a key that helps us understand what rows are essentially the "same record." Then you could Cross Tab / Transpose / Summarize (or perhaps Multi-Row Formula) the column values back together before applying your column parsing.

Unless I'm missing your ask, this shouldn't be a REGEX solution. Do you have more fields upstream that would help in the multi-row associations? If so, I would start there and try and get the lines of each record into the same "cell."

Hope that helps you get started, -Jay