How to concatenate rows in a given column to a string in JSL?

Neo — Sat, 10 Jun 2023 23:54:31 GMT

If I have a datatable dt with one column col1 and several rows containing characters e.g. a, b, c, d i.e. one character per row. How do I get a string of the form myString = 'a','b', 'c', 'd' ?

If I do this

x = Associative Array( dt:"col1" ) << Get Keys; show (x);

it gives me

x = {"a", "b", "c", "d"};

whereas I would like to get a string

myString = 'a', 'b', 'c', 'd'

to use further in my next line of code.

Any directions would be helpful.

Thanks.

Re: How to concatenate rows in a given column to a string in JSL?

jthi — Thu, 22 Sep 2022 16:59:56 GMT

Use Concat Items after you have the list

Names Default To Here(1);

x = {"a", "b", "c", "d"};

my_string = "'" || Concat Items(x, "','") ||"'";

Write(my_string); // 'a','b','c','d'

topic Re: How to concatenate rows in a given column to a string in JSL? in Discussions

How to concatenate rows in a given column to a string in JSL?

Re: How to concatenate rows in a given column to a string in JSL?