On 19 Oct 2020, at 22:15, Charlie0 charlieo0(_at_)comcast(_dot_)net
<xsl-list-service(_at_)lists(_dot_)mulberrytech(_dot_)com> wrote:
Greetings,
I have an issue that I think is a grouping problem but I just can't seem to
figure it out. I have no code to show as I'm that lost on this.
I have the following XML that needs to transform to a comma delimited text
file. See text after the XML. Any assistance to get me in the right direction
is appreciated.
XML:
<work_package id="M2183892350419">
<eqpcond>
<targetfile id="O1012492350419"/>
</eqpcond>
<eqpcond>
<targetfile id="O1003092350419">
<targetfile id="O1012492350419"/>
<targetfile id="O1000492350419"/>
<targetfile id="O1002492350419">
<targetfile id="O1012492350419"/>
<targetfile id="O1000192350418"/>
<targetfile id="O1000192350416"/>
<targetfile id="O1000192350417"/>
<targetfile id="O1000192350415"/>
<targetfile id="O1000192350414"/>
</targetfile>
</targetfile>
</eqpcond>
<eqpcond>
<targetfile id="M2184292350419">
<targetfile id="O1012492350419"/>
<targetfile id="M2171392350419">
<targetfile id="O1012492350419"/>
<targetfile id="M2171492350419">
<targetfile id="O1012492350419"/>
<targetfile id="M2171292350419"/>
</targetfile>
<targetfile id="M2171192350419">
<targetfile id="O1012492350419"/>
</targetfile>
</targetfile>
<targetfile id="M2183992350419">
<targetfile id="O1012492350419"/>
<targetfile id="O1003092350419">
<targetfile id="O1012492350419"/>
<targetfile id="O1000492350419"/>
<targetfile id="O1002492350419"/>
</targetfile>
<targetfile id="O1011492350417">
<targetfile id="O1012492350419"/>
</targetfile>
</targetfile>
<targetfile id="M2007992350419">
<targetfile id="O1012492350419"/>
<targetfile id="O1003092350419">
<targetfile id="O1012492350419"/>
<targetfile id="O1000492350419"/>
<targetfile id="O1002492350419"/>
</targetfile>
</targetfile>
</targetfile></eqpcond></work_package>
Desired output:
M2183892350419,O1012492350419
M2183892350419,O1003092350419
M2183892350419,,O1012492350419,O1000492350419,O1002492350419
M2183892350419,,,O1012492350419,O1000192350418,O1000192350416,O1000192350417
M2183892350419,M2184292350419
M2183892350419,,O1012492350419,M2171392350419
M2183892350419,,,O1012492350419,M2171492350419
M2183892350419,,,,O1012492350419,M2171292350419
M2183892350419,,,M2171192350419
M2183892350419,,,,O1012492350419
M2183892350419,,M2183992350419
M2183892350419,,,O1012492350419,O1003092350419
M2183892350419,,,,O1012492350419,O1000492350419,O1002492350419
M2183892350419,,,O1011492350417
M2183892350419,,,,O1012492350419
M2183892350419,,M2007992350419
M2183892350419,,,O1012492350419,O1003092350419
M2183892350419,,,,O1012492350419,O1000492350419,O1002492350419
Regards,
CharlieO