How to get comma separated values as an array from a string?

Question

How to get comma separated values as an array from a string?

Gayara Kumari 65

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

User's image

Expected Output

User's image

Please advise on this.

Thank You.

Mahesh Madhusanka 106 Reputation points

2023-01-27T08:28:45.2166667+00:00

Hi Team,

Have you any update on this...?

Thanks

Mahesh

Gayara Kumari 65

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

Yitzhak Khabinsky 27,106 Reputation points

2023-02-02T19:46:43.9933333+00:00

@Gayara Kumari,

Did you have a chance to try the proposed solution?

Answer accepted by question author

1 additional answer

Your answer

Mahesh Madhusanka 106 Reputation points

2023-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
Yitzhak Khabinsky 27,106 Reputation points

2023-02-02T19:46:43.9933333+00:00

@Gayara Kumari,

Did you have a chance to try the proposed solution?

Answer 1

Reza Aghaei 4,996 Volunteer Moderator

Have you checked the following link:

Split function in XLST1.0

Gayara Kumari 65

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>

Answer 2

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>

Share via

How to get comma separated values as an array from a string?

1 additional answer

Your answer