topic Re: Convert collection to a text string separated by ( ; ) in Product Forum

Convert collection to a text string separated by ( ; )

FatimaAlcaraz — Fri, 04 Feb 2022 16:34:24 GMT

I have a collection of data and I need to get those values but in this format. Example: 000123;000235;000654...
I need a (;) between each value, since that's the only way they'll work for me.
Attached is the capture of the collection obtained.

I would be grateful if you could tell me how I could obtain the result that I need.

Re: Convert collection to a text string separated by ( ; )

krishna.kodimurali9 — Fri, 04 Feb 2022 17:51:29 GMT

Hi Fatima,

You can use below expression in calculate stage within the loop to get the desired output.

[Final String]&[Collection.Column 0]&";" and store the result in [Final String]

Re: Convert collection to a text string separated by ( ; )

FatimaAlcaraz — Fri, 04 Feb 2022 18:23:11 GMT

Thank you very much for helping me solve my problem!