String Edit Box Function

anders_bankefor — Thu, 26 May 2016 13:16:37 GMT

Hi,

I've managed to use the Number Edit Box() function combined with Char() to retrive strings from a column in order to delete specific rows from my tables. However my code does not work for all situations, why?

Is there another Edit Box for strings? Does anyone have another sugestion for entering strings (through a edit box), comparing each value in a specified column to that string and if match/not match fill a second column with Yes/No? The values in the specified columns will have format character but be a mix of numbers and chars.

I've got the following code:

Window= New Window( "Statement here...",

ListREF = {};

ListOBJ = {};

H List Box(

Text Box( "Statement here...", " ),

Spacer Box( size( 1, 10 ) ),

editBox= Number Edit Box( "" ),

i = 1;

j = 1;

Spacer Box( size( 1, 10 ) ),

Button Box( "Statement here...", ",

Data Table( "Main Table" ) << Select Where( :Column3== (Char( editBox<< get )) );

editBox<< Set( . );

Data Table( "Main Table" ) << Subset( Invisible, (Selected Rows) );

Selected( Row State( 10 ) ) = 1;

Data Table( "Table" ) << delete rows;

.......

Output:

Before deletion:

Main Table

Col1 Col2[Numeric] Col3 [character]

Obj1 1234 "MyObject"

Obj2 5678 "MyRef1"

in my Edit Box I type MyRef1 and the result is:

Main Table

Col1 Col2[Numeric] Col3 [character]

Obj1 1234 "MyObject"

Subset Main Table

Col1 Col2[Numeric] Col3 [character]

Obj2 5678 "MyRef1"

Re: String Edit Box Function

vince_faller — Thu, 26 May 2016 13:58:50 GMT

Text Edit Box()

Re: String Edit Box Function

msharp — Fri, 27 May 2016 21:45:55 GMT

If you have difficulties learning the JSL syntax, I would recommend getting familiar with the Scripting Index. Help >> Scripting Index. This is a great resource for JSL coding.

Re: String Edit Box Function

txnelson — Fri, 27 May 2016 21:59:05 GMT

I will echo what msharp said, plus I will had that I found reading of the 1st 200 pages of the scripting guide, available in JMP Help==>Books==>Scripting Guide.

I found that it gave me that solid overall understanding of the different JSL structures.

Re: String Edit Box Function

anders_bankefor — Sat, 28 May 2016 00:40:29 GMT

Hi,

yes I was actually searching for edit boxes in the scriptguide but somehow I missed it. Thank you all for your help.

topic Re: String Edit Box Function in Discussions

String Edit Box Function

Re: String Edit Box Function

Re: String Edit Box Function

Re: String Edit Box Function

Re: String Edit Box Function