Dear All,
Let me ask a question regarding Text Edit Box() function
Goal
Copy and Paste Excel values (Certain SerialNumber) into text edit box and sort the Panel box (inserted SerialNumber)
I created some script referring to examples in JMP community as below.
The script is needs to be updated though.
Delete Symbols();
Names Default To Here( 1 );
//Define Seperate function
SeparateString = Function( {TheString},
TheList = Words(TheString," ");
Return( TheList );
);
dt = Current Data Table();
Summarize( sn = by( :SN ) );
serial_total = sn;
//dt2 = New table("tmp", New Column("serialnumber",character, set values(sn)));
New Window("Debug",
H List Box(
V List Box(TEXT BOX("Copy and Paste SerialNumber list", <<SET font="" style=""></SET>
By the way, when I input below values in text edit box, it seems the extracted string has delimiter " ", but it cannot be splitted as I thought.
I added simple script to check if it is splitted well, as you can see below figure, "str" can be splitted, however, "tmp" cannot.
When I put the values to excel and compare it with Exact function, both value is just same, but seems like JSL classified two variable as different one.
tmp =Eval(item_search_teb <str = "MD5 MD6 MD7 MD8 ";
split_str = Words(str," ");
split_tmp = Words(tmp," ");
Could you find out what is the difference and let me know the solution?
Many thanks!
