cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
ram
ram
Level IV

JSL List to matrix ?

Prob: needed to get a list or matrix of numbers instead of characters;

 

String="1,2,3,4,5,6";

list=words(String,",");  //output --> {"1","2","3","4","5","6"}

 

required output ={1,2,3,4,5,6};

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: JSL List to matrix ?

All Matrix, List and Character functions are available at

     Help==>Scripting Index==>Functions

Here is a possible answer for you

Names Default To Here( 1 );
String = "1,2,3,4,5,6";
Eval( Parse( "Mat=[" || string || "];" ) );
Jim

View solution in original post

4 REPLIES 4
ram
ram
Level IV

Re: JSL List to matrix ?

No For loop should be used.
Jeff_Perkinson
Community Manager Community Manager

Re: JSL List to matrix ?

Here's one way to do it without a For() loop.

 

String="1,2,3,4,5,6";
list=words(String,",");  
//output --> {"1","2","3","4","5","6"}

x=new table("temp", new column("c", character, values(list)), private);
:c<< data type(numeric);
m = c<< get values;

close(x, nosave);

show(m);
-Jeff
txnelson
Super User

Re: JSL List to matrix ?

All Matrix, List and Character functions are available at

     Help==>Scripting Index==>Functions

Here is a possible answer for you

Names Default To Here( 1 );
String = "1,2,3,4,5,6";
Eval( Parse( "Mat=[" || string || "];" ) );
Jim
ram
ram
Level IV

Re: JSL List to matrix ?

Thank you Jim,
This is exactly i was looking for. Also Thanks for pointing to the link to explore other functions too.