Subject: Re: [xsl] Need help with XSLT tokenize From: "Terry Badger terry_badger@xxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> Date: Tue, 11 Aug 2020 17:34:46 -0000 |
This will do it. Could be compressed but I think it should be easy to see the process this way. Terry Badger <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"> B B B <xsl:template match="/"> B B B B B B B <xsl:result-document href="output.xml"> B B B B B B B B B B B <xsl:apply-templates/> B B B B B B B </xsl:result-document> B B B </xsl:template> B B B <xsl:template match="Payments"> B B B B B B B <xsl:element name="Orders"> B B B B B B B B B B B <xsl:apply-templates/> B B B B B B B </xsl:element> B B B </xsl:template> B B B <xsl:template match="Payment/invoiceDetails"> B B B B B B B <xsl:analyze-string select="." regex="([^;]*)(;)"> B B B B B B B B B B B <xsl:matching-substring> B B B B B B B B B B B B B B B <xsl:element name="Order"> B B B B B B B B B B B B B B B B B B B <xsl:analyze-string select="." regex="([^#]*)(#)([^;]*)"> B B B B B B B B B B B B B B B B B B B B B B B <xsl:matching-substring> B B B B B B B B B B B B B B B B B B B B B B B B B B B <xsl:element name="OrderNumber"> B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B <xsl:value-of select="regex-group(1)"/> B B B B B B B B B B B B B B B B B B B B B B B B B B B </xsl:element>B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B <xsl:element name="Amount"> B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B B <xsl:value-of select="regex-group(3)"/> B B B B B B B B B B B B B B B B B B B B B B B B B B B </xsl:element> B B B B B B B B B B B B B B B B B B B B B B B </xsl:matching-substring> B B B B B B B B B B B B B B B B B B B </xsl:analyze-string> B B B B B B B B B B B B B B B </xsl:element> B B B B B B B B B B B </xsl:matching-substring> B B B B B B B </xsl:analyze-string> B B B </xsl:template> </xsl:stylesheet> On Tuesday, August 11, 2020, 7:34:48 AM EDT, Prady Prady prady.chin@xxxxxxxxx <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote: Team, I need help with XSLT. Below is my requirement. Can somebody help?B ===================== Input xml: <Payments> <Payment> B B <invoiceDetails>order1#amt1;order2#amt2;</invoiceDetails> </Payment> </Payments> I need to be able to convert this to: Output xml:B <Orders> <Order> B B <OrderNumber>order1</OrderNumber> B B <Amount>amt1</Amount> </Order> <Order> B B <OrderNumber>order2</OrderNumber> B B <Amount>amt2</Amount> </Order> </Orders>====================== Thank you very much for yourB help B B XSL-List info and archive EasyUnsubscribe (by email)
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Need help with XSLT token, Liam R. E. Quin liam | Thread | Re: [xsl] Need help with XSLT token, Prady Prady prady.ch |
Re: [xsl] Need help with XSLT token, Leo Studer leo.stude | Date | Re: [xsl] Need help with XSLT token, Dimitre Novatchev dn |
Month |