word function changing a String into separate numeric values

[#1]

I currently and trying to separate out numberic values that are stored in a single column as a string in this format: "[email protected]@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?

[#2 · Accepted solution]

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,"@"))));

[#3]

Try this:

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