Skip different delimiter for csv data (ION Mapper)

I have XSLT code convert csv data to BOD and define the delimiter to be (;) but i have this input data .......;INSERTO RCV1000;Aico S.p.A R&D Verona;....

so it reads the (&) as a delimiter not a part of the text and shows me this error in testing

Could not transform xml with the given xslt.
org.xml.sax.SAXParseException; lineNumber: 20;
columnNumber: 85; The reference to entity "D" must
end with the ';' delimiter.

is there a way to skip reading & as a delimiter and see it as a part of the text ?

Find more posts tagged with

ION Connect

Accepted answers

All comments

Mats Ornvall

You can replace the & sign with & in the xslt

lamis-alaa

The & sign gets from input csv file from another system , i could not change anything in the data "it is a company name"

and this my code for defining the delimiter

<xsl:call-template name="tokenize">
<xsl:with-param name="text" select="."/>
<xsl:with-param name="delimiter" select="';'"/>
<xsl:with-param name="name" select="'cell'"/>
</xsl:call-template>

Mats Ornvall

If it is xslt 2.0 you should be able to use:
translate(string, from characters, to characters)

Copyright © 2025 Infor. All rights reserved.