Hi bernie426
It sounds like you want to have the resulting column be numeric, is that right? If so, Peter's suggestion above is the right way to handle this. When you extract a piece of a string it stays a string, unless you tell JMP that you want to convert the string to be a number. Here is a completed script with the Num() function wrapped around the Word() function, and also one more change to make the new column be numeric when it is created.
Hope this works for you!
julian
//Make a new NUMERIC column
Current Data Table() << New Column("ClassNumberOnly", Numeric);
//stop table update until all changes are made, good for large tables
Current Data Table() << Begin Data Update;
//Apply changes to each row
//The function below will look for a column named "Class"
//if the data are in column with a different name
//change :Class to be whatever the column name is, but
//be sure to retain the : since that lets JMP know you are
//referencing a column.
//this function also wraps the Word() function in Num()
//which will convert the character output to be a number
//allowing the resulting column to stay numeric
For Each Row(
:ClassNumberOnly = Num( Word( 2, :Class ) )
);
// End "Data Update"
Current Data Table() << End Data Update;