Community

WOW, thanks for your help! I've searched around and this is light years from where I was after several attempts to tackle on my own.

Are you familiar with a topic that covers similar RE's for my own edification? I need to continue refining, but this is an awesome start.

What are you trying to do?

Show some example input as it is and as you would like it to be.

I'd like to get everything in a single row. I'm unsure how to proceed after reformatting or joining the row and then keeping the parent child fields distuniguisable after removing all the blank spaces ...

Greetings!

I'm working on trying to determine how I can formulate an RE given parent child relationship from the file I'm working with. In sum, the file is formatted as follows:

Master record Field1 Field2 Field3 Field4
Parent
Child
Child
Child
Child
Parent
Child
Child
Parent ...