Hi there,
I have an XML with data as below:
<row>
<c1>Name1></c1>
<c2>Name2</c2>
<c6>Addressline</c6>
<c6 m=1 s=2>Addressline 2 </c6>
<c6 m=1 s=1>Addressline 3 </c6>
<c6 m=2 s=1>Addressline 4</c6>
<c6 m=2 s=2>Addressline 5</c6>
<c6 m=2 s=3>Addressline 6</c6>
</row>.
I require the following output, but unfortuantely I could not find any help anywhere.
Fld 1 fld2 fld3
Name1 Name2 Addressline$Addressline 2$Addressline 3£Addressline 4$Addressline 5$Addressline 6
Means the values in "m" should be concatenated with $ and both "m" should be seprated with £
Thanks
Regards,
Wasif Hassan