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

How to add a custom column property that contains double quote and equal sign?

Hi:

I wonder if there is a good way to add a custom column property that contains double quote and equal sign? The goal is to set the column property shown in the picture with JSL script. For double quote I have tried escape character \!", however; it doesn't work and still shows \!" in the column property. 

 

Thank you,

 Guanxiong

 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt:name<<Set Property("DATA", " \!"CLASS_TYPE\!" ")

 

ScatterChart190_0-1684972131966.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to add a custom column property that contains double quote and equal sign?

Maybe you have to evaluate it. Below is one option

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
aa = ["CLASS_TYPE" => "CLASS", "DATA_SOURCE" => "WEB"];
Eval(EvalExpr(
	dt:name << Set Property("DATA", Expr(aa));
));
-Jarmo

View solution in original post

4 REPLIES 4
jthi
Super User

Re: How to add a custom column property that contains double quote and equal sign?

Are you trying to set Associative Array as column property?

 

Edit:

jthi_0-1684995187909.png

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
aa = ["CLASS_TYPE" => "CLASS", "DATA_SOURCE" => "WEB"];
dt:name << Set Property("DATA", aa);

 

-Jarmo

Re: How to add a custom column property that contains double quote and equal sign?

Hi Jarmo:

Thanks for your help; however, for my JMP14, the script still gives "aa" instead of an array in the column property. Do you have any idea or suggestion?

 

Best,

Guanxiong 

ScatterChart190_0-1685036195791.png

 

jthi
Super User

Re: How to add a custom column property that contains double quote and equal sign?

Maybe you have to evaluate it. Below is one option

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
aa = ["CLASS_TYPE" => "CLASS", "DATA_SOURCE" => "WEB"];
Eval(EvalExpr(
	dt:name << Set Property("DATA", Expr(aa));
));
-Jarmo

Re: How to add a custom column property that contains double quote and equal sign?

It works! Thanks for your help:)