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

mostarr — Sat, 10 Jun 2023 23:29:56 GMT

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

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

jthi — Thu, 06 May 2021 19:17:00 GMT

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

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

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

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