How to convert a delimited string into xml structure defined in a variable with XSLT

Question

I need to parse a tab-delimited string into an xml node structure defined in a variable. I used tokenize() to get the string into an "array" variable and have a variable that tells me what tag I should give to each element in the array based on its position. I do a for-each on the array and assign each element in it to an xml tag to produce the output.

Here's the input:

<Data>Jane Doe /t Atlantis /t 4-1-1999 /t [email protected]<Data>

Here's the XSLT:

<xsl:variable name="MyXMLStructure">
    <Field Position="1">Name</Field>
    <Field Position="2">Location</Field>
    <Field Position="3">DateOfBirth</Field>
    <Field Position="4">Email</Field>
</xsl:variable>

<xsl:template name="processData">
    <xsl:param name="pText"/>

    <xsl:variable name="DataFields" select="tokenize($pText, '&#x9;')"/>
    <xsl:element name="PersonData">

        <xsl:for-each select="$DataFields">
            <xsl:element name="{$MyXMLStructure/Field[@Position = position()]}">
                 <xsl:value-of select="."/>
            </xsl:element>
        </xsl:for-each>
    </xsl:element>

</xsl:template>

<xsl:template match="/">
    <xsl:call-template name="processData">
        <xsl:with-param name="pText" select="/Data"/>
    </xsl:call-template>
</xsl:template>

Here's the expected output:

<PersonData>
     <Name>Jane Doe</Name>
     <Location>Atlantis</Location>
     <DateOfBirth>4-1-1999</DateOfBirth>
     <Email>[email protected]</Email>
</PersonData>

I get this error:

Invalid Element Name. Invalid QName {Name Location ...}

I'm guessing that the position() of the array isn't working well and the name of the element isn't being assigned properly.

Please help!

EDIT: Edited XSLT code

Martin Honnen · Accepted Answer · 2014-02-25 21:43:06Z

2

I think you want

    <xsl:for-each select="$DataFields">
        <xsl:variable name="pos" select="position()"/>
        <xsl:element name="{$MyXMLStructure/Field[@Position = $pos]}">
             <xsl:value-of select="normalize-space()"/>
        </xsl:element>
    </xsl:for-each>

For a more efficient access you could define a key <xsl:key name="k1" match="Field" use="xs:integer(@Position)"/> and then use <xsl:element name="{key('k1', position(), $MyXMLStructure)}">.

edited Feb 25, 2014 at 21:43

answered Feb 25, 2014 at 17:58

Martin Honnen

169k6 gold badges100 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dhishkaow Over a year ago

That worked! Can't believe it could've been so simple. Thank you!

dhishkaow Over a year ago

@helderdarocha Yes I had to wait 4 minutes to mark it as correct.

Collectives™ on Stack Overflow

How to convert a delimited string into xml structure defined in a variable with XSLT

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related