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

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

ScatterChart190 — Sun, 11 Jun 2023 00:01:31 GMT

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\!" ")

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

jthi — Thu, 25 May 2023 06:13:28 GMT

Are you trying to set Associative Array as column property?

Edit:

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);

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

ScatterChart190 — Thu, 25 May 2023 17:38:59 GMT

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

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

jthi — Thu, 25 May 2023 17:40:19 GMT

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));
));

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

ScatterChart190 — Fri, 26 May 2023 21:04:59 GMT

It works! Thanks for your help:)