cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
mostarr
Level IV

Do JMP DT Columns with Special Characters in them (/, ., etc.) Need their Special Characters Escaped in Formulas?

I have a column with a backslash in the title, do I need to either escape it or put the column's name in quotes when referencing it in a formula in a JSL script?

Mike

1 REPLY 1
jthi
Super User

Re: Do JMP DT Columns with Special Characters in them (/, ., etc.) Need their Special Characters Escaped in Formulas?

Not completely sure but links these will most likely have answers for you:

Utility Functions - Name(String) (will be depracated)

JSL Syntax Rules - Names 

I think same rules are applied for column names

 

This seems to work fine:

 

Names Default To Here(1);

dt = New Table("Untitled 2",
	Add Rows(2),
	Compress File When Saved(1),
	New Column("Column\",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([1, 2])
	)
);

Show(Col Sum(:Column\));

I wouldn't feel comfortable referencing columns like that even if it would work and would use some other way (AsColumn(), Column(), :"column name"n depending on the case).

 

-Jarmo