Topic
  • 2 replies
  • Latest Post - ‏2012-07-12T02:33:40Z by Silver.Su
Silver.Su
Silver.Su
24 Posts

Pinned topic How to concatenate a group of string with comma delimiter

‏2012-07-11T17:09:33Z |
Hello,

I have a group of string that comes from an XML input in following:
10
1A
EA
90

All of these strings like 10, 1A, EA or 90 are collected in the A item in the type tree.
So, the A item has multiple occurrence like A(s).

How can I write the output rule that concatenate all of the strings with comma delimiter like this:

10,1A,EA,90

I tried to use SeriesToText() function with the A item as parameter, but the result of that is 101AEA90.
Updated on 2012-07-12T02:33:40Z at 2012-07-12T02:33:40Z by Silver.Su
  • JGibby
    JGibby
    49 Posts

    Re: How to concatenate a group of string with comma delimiter

    ‏2012-07-11T17:28:02Z  
    Just add your delimiter like this example

    
    =TRIMRIGHT(SERIESTOTEXT(Text:Input+
    ","),
    ",")
    


    John
  • Silver.Su
    Silver.Su
    24 Posts

    Re: How to concatenate a group of string with comma delimiter

    ‏2012-07-12T02:33:40Z  
    • JGibby
    • ‏2012-07-11T17:28:02Z
    Just add your delimiter like this example

    <pre class="jive-pre"> =TRIMRIGHT(SERIESTOTEXT(Text:Input+ ","), ",") </pre>

    John
    Hello, JGibby.

    Thanks for your reply, and it works now. Thanks a lot.