Parsing a value with a Quote

bcurley

Hi,

I have a larege set of data a parse through and create plots and adds them to a jounal based on a unique set of column values.  I want to add a script button so that for a paticular plot I have I can quickly get back to the data the created it.  The problem I have is that when one of the values contains a quote I can't parse it to create the unique script.  Here's a very simplified version of what I'm doing where a represents the value I've gotten from my data table:

a = "Example 4\!" Test";

scrbutt = Button Box("Get Data");

scr = "dt << Select Where(:MyColumn==\!"" || a || "\!")";

eval(parse("scrbutt << set script(" || scr || ")"));

The parse will always fail because it see's the quote after 4 as the end of a string and no matter what I try and can't get it to not to.  Any ideas on what I could do?

FYI, this is with JMP9.

Thanks,
Bob

ms

Parsing fails also in JMP 10.

One workaround may be to build the command from expressions instead of strings as in the example below (works in JMP 10).

//Example table

dt = New Table( "Ex", Add Rows( 3 ), New Column( "MyColumn", Character, Nominal, Set Values( {"Example 4\!" Test", "X", "Y"} ) ) );

//Example code

a = "Example 4\!" Test";

scr = Expr( dt << Select Where( :MyColumn == _a_ ) );

Substitute Into( scr, Expr( _a_ ), a );

New Window( "test", scrbutt = Button Box( "Get Data" ), Text Box( Name Expr( scr ) ) );

scrbutt << set script( scr );