589659_en-US

liliconcom

Re: Need help to find out the difference of two variables listed here

Try using "\!N" as separator for tmp instead of " ".

Most likely the separator is some sort of row change and not " " when you copy-paste values from Excel. I'm not sure where your variable image is from (JSL Debugger?) but maybe it cannot show row changes properly?

 

Edit: Also depending on your application, sometimes you might be better off replacing all white spaces (or just different kinds of row changes) with some character (I usually use ¤) using Regex and then using Words to split on that character. I usually do this, because the copy-pasted values might have all kinds of weird whitespace characters and just splitting on \!N won't be enough.

 

Names Default To Here(1);

str = "asd b 

\!na
\!rb";
Print(str);

new_separator = "¤";
l = Words(Regex(str, "\s", new_separator, GLOBALREPLACE), new_separator);
Show(l);

 

 

Re: Need help to find out the difference of two variables listed here

Thanks for kind explanation and good way for the debugging!

It's first time I learned Regular Expression (Regex) in JSL.

 

Many thanks!

 

FYI, I captured debugger tool for the snapshot as you mentioned.

 

 

 

Need help to find out the difference of two variables listed here

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.

 

 

MD5

MD6

MD7

MD8

 

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!

Data Blending and Cleanup