Split Array

Question

Hi,

1. Any ideas how to split a = {"c", "d","e"}; into a= {"c"}, {"d"},{"e"}; ? Currently when I did Concat Items (a, ","); , the output will be "c,d,e" instead of "c","d","e" .

2. Concat Items did apply after letter c. However, what if I want to concat "," before c such as ",c,d,e"?

3. Is there any possibilities to combine semicolon together with other strings? For example, " " "|| water || bend || "," || " " " , thus the output will be "water bend,"

jthi · Accepted Answer

That would be read same as if you "removed" first quotes (as it is string) and replaced all \!" with single ".

Check log after running this script (and also created datatable, it will add a_string value to one cell)

Names Default To Here(1);

a_list =  {"c", "d", "e"};
show(a_list);
a_string = "\!"" || Concat Items(a_list, "\!",\!"") || "\!"";
show(a_string);
write("\!NWrite print: "||a_string);

dt = New Table("newtable",
	Add Rows(1),
	Compress File When Saved(1),
	New Column("col", Character, "Nominal", Set Values({""}))
);

column(dt, "col") << Set Each Value(a_string);
write();

I have had my challenges with strings in JMP and it has depended on the use case what I have had to do to manage with them to add quotes.

Jeff_Perkinson · Accepted Answer

@WanCine wrote:Hi,

1. Any ideas how to split a = {"c", "d","e"}; into a= {"c"}, {"d"},{"e"}; ? Currently when I did Concat Items (a, ","); , the output will be "c,d,e" instead of "c","d","e" .

I'm having trouble making sense of this question because a= {"c"}, {"d"},{"e"}; isn't valid JSL. There's no data structure which will hold three separate lists like that. Can you clarify exactly what you're trying to do?

2. Concat Items did apply after letter c. However, what if I want to concat "," before c such as ",c,d,e"?

Try this:

a = {"c", "d", "e"};

z = "," || Concat Items( a, "," );

3. Is there any possibilities to combine semicolon together with other strings? For example, " " "|| water || bend || "," || " " " , thus the output will be "water bend,"

I think @jthi pointed out that you can escape quotation marks with \!".

foo = " \!" "|| "water " || "bend" || "," || " \!" ";