Passing multiple values to a string variable in BLS Transaction

[aravinth_anandhan]

Hi All,

How to pass multiple values to a string variable in a transaction, For example i my document 3 rows are there like

Test1

Test2

Test3

Now i need to get these values in a string variable like Test1, Test2, Test3.

Is there any way to get these values in a single line with comma separated?

--Aravinth

[suhas_nagaraju · Accepted solution]

During each iteration keep appending the value to a string variable.

Thanks,

Suhas

[agentry_src · Accepted solution]

To expand on what Suhas mentioned,

Create a transaction property of type string.

In your expression editor window you will set

Transaction.StringProperty = Transaction.StringProperty &","&  Repeater.Output{/<stringnode>}

This should continually add the output of the repeater to your property.

Good luck,

Mike

Edited by: Michael Appleby on Mar 5, 2012 4:08 PM

[aravinth_anandhan]

Hi,

Thank you very much Suhas, Mike and Pradeep. Now it is adding values to the same string. Thanks again.

--Aravinth

[suhas_nagaraju]

For that you have to use repeater action block so as iterate over the rows and concatenate the strings as I mentioned in the previous post.

Thanks,

Suhas

[aravinth_anandhan]

Hi,

Suppose i am using repeater action to concatenate values, it ll hold the last value came from repeater. It is not storing all values from repeater.

[suhas_nagaraju]

Hi Aravinth,

Please refer this thread - [Concatenate strings|;.

Also when you mean document, is it an xml?

Thanks,

Suhas

[aravinth_anandhan]

Hi Suhas,

It is in my Document action block, and also my document is having only one column with multiple rows.

Example:

NAME (Column Name)

test1(Row1)

test2(Row2)

test3(Row3)

I want these rows to be stored in a single Variable with comma separated. If i am having a multiple columns with singe Row, then i can able to use '&' to concatenate in to a single variable. Here the issue is, i am having single column has multiple rows.

Edited by: Aravinth A on Mar 2, 2012 6:39 AM

[Former Member]

hi Aravinth,

try repeating through the document and concatenate each row to a String variable with a "," in between.

Regards,

Pradeep D

Edited by: Pradeep Dwarakanath on Mar 2, 2012 7:29 AM