cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • See how to interactively organize and restructure data for analysis. Register for May 29 webinar, 2pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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:)

Recommended Articles