Remove repeated string in xslt



I need to remove duplicate entries of a string or merge contents of a complex type element.


My current result:



<?xml version="1.0" encoding="UTF-8"?>
<EMailData>

<property name="EVENTINFO">


<property name="City">
<value>City1111</value>
</property>
<property name="Country">
<value>Country1112</value>
</property>
<property name="Zip">
<value>Zip1113</value>
</property>

<property name="Household">
<row>
<property name="HouseholdNumber">
<value>HouseholdNumber1173</value>
</property>
<property name="HouseholdName">
<value>HouseholdName1174</value>
</property>
<property name="HouseholdStatus">
<value>HouseholdStatus1175</value>
</property>
<property name="HouseholdPrimaryContactID">
<value>HouseholdPrimaryContactID1176</value>
</property>
</row>
</property>
<property name="Household">
<row>
<property name="HouseholdNumber">
<value>HouseholdNumber1177</value>
</property>
<property name="HouseholdName">
<value>HouseholdName1178</value>
</property>
<property name="HouseholdStatus">
<value>HouseholdStatus1179</value>
</property>
<property name="HouseholdPrimaryContactID">
<value>HouseholdPrimaryContactID1180</value>
</property>
</row>
</property>
<property name="Household">
<row>
<property name="HouseholdNumber">
<value>HouseholdNumber1181</value>
</property>
<property name="HouseholdName">
<value>HouseholdName1182</value>
</property>
<property name="HouseholdStatus">
<value>HouseholdStatus1183</value>
</property>
<property name="HouseholdPrimaryContactID">
<value>HouseholdPrimaryContactID1184</value>
</property>
</row>
</property>
<property name="FFStatus">
<row>
<property name="FFCount">
<value>FFCount1187</value>
</property>
<property name="FFCycleStartDate">
<value>2015-02-05</value>
</property>
<property name="FFSubclassName">
<value>FFSubclassName1188</value>
</property>
</row>
</property>
<property name="FFStatus">
<row>
<property name="FFCount">
<value>FFCount1189</value>
</property>
<property name="FFCycleStartDate">
<value>2015-02-05</value>
</property>
<property name="FFSubclassName">
<value>FFSubclassName1190</value>
</property>
</row>
</property>
</property>
</EMailData>


I want to Change this into this format::



<?xml version="1.0" encoding="UTF-8"?>
<EMailData>

<property name="EVENTINFO">

<property name="City">
<value>City1111</value>
</property>
<property name="Country">
<value>Country1112</value>
</property>
<property name="Zip">
<value>Zip1113</value>
</property>

<property name="Household">
<row>
<property name="HouseholdNumber">
<value>HouseholdNumber1173</value>
</property>
<property name="HouseholdName">
<value>HouseholdName1174</value>
</property>
<property name="HouseholdStatus">
<value>HouseholdStatus1175</value>
</property>
<property name="HouseholdPrimaryContactID">
<value>HouseholdPrimaryContactID1176</value>
</property>
</row>
<row> // **Second occurance as new row and not new element itself**
<!-- Values -->
</row>
</property>
<property name="FFStatus">
<row>
<!-- Values -->
</row>
<row>
<--values-->
</row>
</property>
....


How can I do this in xslt.


I tried using translate(). But I am stuck as I need to remove from the second occurance of the string only.


No comments:

Post a Comment