topic Re: word function changing a String into separate numeric values in Discussions

word function changing a String into separate numeric values

pcannonsamsung — Wed, 17 Oct 2018 21:28:46 GMT

I currently and trying to separate out numberic values that are stored in a single column as a string in this format: "9@12.5@32"

I am trying to use the word function to create new columns with single numeric values with this jsl:

dt<<New Column("New", Numeric, Continuous,
Formula(word(1,:Column,"@")));

but jmp will automatically change this to a categorical column. Is there a way to force it to be numeric?

Jeff_Perkinson — Wed, 17 Oct 2018 21:32:01 GMT

JMP changes the data type of the column to a character because the Word() function returns a character string.

You can use the Num() function to convert a character string to a numeric value.

dt<<New Column("New", Numeric, Continuous,
Formula(num(word(1,:Column,"@"))));

MathStatChem — Wed, 17 Oct 2018 21:32:57 GMT

Try this:

dt<<New Column("New", Numeric, Continuous,
Formula(Num(word(1,:Column,"@"))));