79460_en-US

liliconcom

word function changing a String into separate numeric values

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>

 

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

Re: word function changing a String into separate numeric values

Try this:

 

dt<<NEW column=""></NEW>

Re: word function changing a String into separate numeric values

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>