Page 1 of 1

XML output formatting

Posted: Wed Dec 21, 2011 3:48 pm
by kapil_nj
i am getting the output message as
<parentinfo>
<personid>1
</personid>
<name>
<fn>micheal
</fn>
<ln>
johnson
</ln>
</name>
<age>40
</age>
</parentinfo>

<relatedstudent>
<stud_FN>james
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>
</relatedstudent>



<parentinfo>
<personid>2
</personid>
<name>
<fn>kevin
</fn>
<ln>scott
</ln>
</name>
<age>45
</age>
</parentinfo>

<relatedstudent>
<stud_FN>kelly
</stud_FN>
<stud_LN>
</stud_LN>scott
</stud_FN>
</relatedstudent>






<parentinfo>
<personid>1
</personid>
<name>
<fn>micheal
</fn>
<ln>johnson
</ln>
</name>
<age>40
</age>
</parentinfo>

<relatedstudent>
<stud_FN>linda
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>
</relatedstudent>

Required Format is : since 1st and 3rd person are same because of same person_id=1 so both related student should come under same person/tag.

<parentinfo>
<personid>1
</personid>
<name>
<fn>micheal
</fn>
<ln>
johnson
</ln>
</name>
<age>40
</age>
</parentinfo>

<relatedstudent>
<stud_FN>james
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>
<stud_FN>linda
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>

</relatedstudent>



<parentinfo>
<personid>2
</personid>
<name>
<fn>kevin
</fn>
<ln>scott
</ln>
</name>
<age>45
</age>
</parentinfo>

<relatedstudent>
<stud_FN>kelly
</stud_FN>
<stud_LN>
</stud_LN>scott
</stud_FN>
</relatedstudent>

Re: XML output formatting

Posted: Wed Dec 21, 2011 3:53 pm
by samdsx
since it is in one parentinfo, you need to remove duplicate after reading complete file.