Hi,
I have a CSV FILE
<ROOT>
"81","344","0143857003","3072143","2","XUC","ABC,DBE","dhf"
"81","344","0151564171","2914659","2","XYC","ABC,DEF","dsd"
</ROOT>
Now I am using a XSLT file to transform this data into XML from CSV. The issue is in case of "ABC,DBE" it is looking for the next comma and parsing DBE as the next field ( or data) so all the elements have data pushed down by 1
Can this be helped/
my XSLT for tyhis field looks like this
</xsl:when>
<xsl:when test ="$FieldNum = 6">
<DJF>
<xsl:value-of select ="substring-before($StringToTransform,',')"/>
</DJF>
</xsl:when>
Please help
I have a CSV FILE
<ROOT>
"81","344","0143857003","3072143","2","XUC","ABC,DBE","dhf"
"81","344","0151564171","2914659","2","XYC","ABC,DEF","dsd"
</ROOT>
Now I am using a XSLT file to transform this data into XML from CSV. The issue is in case of "ABC,DBE" it is looking for the next comma and parsing DBE as the next field ( or data) so all the elements have data pushed down by 1
Can this be helped/
my XSLT for tyhis field looks like this
</xsl:when>
<xsl:when test ="$FieldNum = 6">
<DJF>
<xsl:value-of select ="substring-before($StringToTransform,',')"/>
</DJF>
</xsl:when>
Please help