cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
conroyco
Level I

How to reference columns whose name begin with a number

I am looking to use the select where function within JSL script.

However, it wont let me reference my column as it begins with a letter i.e 20GHz_time

I want to do :20GHz_time <1000 however it won't let me.

 

I cant reference based on what column number it is as the columns can change from data table to data table so I need a way to capture it.

 

What is happening is the :20 is getting highlighted in green and this error is showing;

Invalid date/time ":20" Perhaps there is a missing "," or ")".
Trying to parse arguments of function "Select Where".
Line 63 Column 27: org << Select Where ( ►:20GHz

 

I also tried renaming the column but this script will be used for automation and we can't manually change the data table each time

1 REPLY 1
txnelson
Super User

Re: How to reference columns whose name begin with a number

use
:Name("20GHz_time") < 1000
to reference the column

Jim