11,570 questions
Have you checked the following link:
How to get comma separated values as an array from a string?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 98%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gayara Kumari
65
Reputation points
We are using XSLT 1.0 mapping to transform one xml file to another xml.
We need to transform comma separated string into sequence of parent-child elements as below.
Input String
Expected Output
Please advise on this.
Thank You.
Developer technologies | C#
{count} votes
-
Mahesh Madhusanka 106 Reputation points2023-01-27T08:28:45.2166667+00:00 Hi Team,
Have you any update on this...?
Thanks
Mahesh
-
Gayara Kumari 65 Reputation points
2023-01-27T08:28:58.02+00:00 Thank You @Alireza Aghajani . It's working. But now I want to get the sequence for the repeating tags.
This is the code I tried.
<xsl:if test="string-length($pText) >0"> <OrderNumber> <OrderReference> <xsl:value-of select= "substring-before(concat($pText, ','), ',')"/> </OrderReference> <Sequence><xsl:value-of select="position()"/></Sequence> </OrderNumber> <xsl:call-template name="split"> <xsl:with-param name="pText" select= "substring-after($pText, ',')"/> </xsl:call-template> </xsl:if>Output I am getting is as follows:
<OrderNumberCollection> <OrderNumber xmlns=""> <OrderReference> 4501581480</OrderReference> <Sequence>1</Sequence> </OrderNumber> <OrderNumber xmlns=""> <OrderReference> 4501644842</OrderReference> </OrderNumber> </OrderNumberCollection>Expected Output:
<OrderNumberCollection> <OrderNumber> <OrderReference>1234567</OrderReference> <Sequence>1</Sequence> </OrderNumber> <OrderNumber> <OrderReference>0987654</OrderReference> <Sequence>2</Sequence> </OrderNumber> </OrderNumberCollection>Please Advise.
Thank You.
Br,
Gayara
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky 26,586 Reputation points2023-02-02T19:46:43.9933333+00:00 Did you have a chance to try the proposed solution?
Sign in to comment
Accepted answer
-
Reza Aghaei 4,986 Reputation points MVP Volunteer Moderator2023-01-27T09:00:12.6+00:00 -
Gayara Kumari 65 Reputation points
2023-01-27T10:16:50.98+00:00 Thank You @Reza Aghaei . Using the URL, you have given we were able to split the values. But now we need to bring the sequence numbers equal to the position according to the order number count.
This is the code I tried.
<xsl:template match="text()" name="split"> <xsl:param name="pText" select="."/> <xsl:if test="string-length($pText) >0"> <OrderNumber> <OrderReference> <xsl:value-of select= "substring-before(concat($pText, ','), ',')"/> </OrderReference> <Sequence><xsl:value-of select="position()" /></Sequence> </OrderNumber> <xsl:call-template name="split"> <xsl:with-param name="pText" select= "substring-after($pText, ',')"/> </xsl:call-template> </xsl:if> </xsl:template>Output I am getting is as follows:
<OrderNumberCollection> <OrderNumber xmlns=""> <OrderReference> 4501581480</OrderReference> <Sequence>1</Sequence> </OrderNumber> <OrderNumber xmlns=""> <OrderReference> 4501644842</OrderReference> <Sequence>1</Sequence> </OrderNumber> </OrderNumberCollection>Expected Output:
<OrderNumberCollection> <OrderNumber> <OrderReference>4501581480</OrderReference> <Sequence>1</Sequence> </OrderNumber> <OrderNumber> <OrderReference>4501644842</OrderReference> <Sequence>2</Sequence> </OrderNumber> </OrderNumberCollection>
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
Yitzhak Khabinsky 26,586 Reputation points
2023-01-30T14:58:31.1333333+00:00 Hi @Gayara Kumari,
Please try the following solution.
Input XML
<?xml version="1.0" encoding="UTF-8"?> <root> <PONumber>100, 200, 770</PONumber> </root>XSLT 1.0
<?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" encoding="utf-8" indent="yes" omit-xml-declaration="no"/> <xsl:strip-space elements="*"/> <xsl:variable name="string" select="/root/PONumber"/> <xsl:variable name="cnt" select="1"/> <xsl:template match="/"> <OrderNumberCollection> <xsl:call-template name="tokenize"> <xsl:with-param name="string" select="$string"/> <xsl:with-param name="delim" select="','"/> <xsl:with-param name="cnt" select="$cnt"/> </xsl:call-template> </OrderNumberCollection> </xsl:template> <xsl:template name="tokenize"> <xsl:param name="string"/> <xsl:param name="delim"/> <xsl:param name="cnt"/> <xsl:choose> <xsl:when test="contains($string, $delim)"> <OrderNumber> <Sequence><xsl:value-of select="$cnt"/></Sequence> <OrderReference> <xsl:value-of select="normalize-space(substring-before($string, $delim))"/> </OrderReference> </OrderNumber> <xsl:call-template name="tokenize"> <xsl:with-param name="string" select="substring-after($string, $delim)"/> <xsl:with-param name="delim" select="$delim"/> <xsl:with-param name="cnt" select="$cnt+1"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <OrderNumber> <Sequence><xsl:value-of select="$cnt"/></Sequence> <OrderReference> <xsl:value-of select="normalize-space($string)"/> </OrderReference> </OrderNumber> </xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet>Output XML
<?xml version='1.0' encoding='utf-8' ?> <OrderNumberCollection> <OrderNumber> <Sequence>1</Sequence> <OrderReference>100</OrderReference> </OrderNumber> <OrderNumber> <Sequence>2</Sequence> <OrderReference>200</OrderReference> </OrderNumber> <OrderNumber> <Sequence>3</Sequence> <OrderReference>770</OrderReference> </OrderNumber> </OrderNumberCollection>