JSL Feature or Bug?

Question

I have a function that relies on knowing whether a substring of a larger string represents a number or not, and I simply use the result of the Num() command -- if it returns a missing value I assume the substring does not represent a number.

However, a user pointed out a bug that had as the root-cause the fact that the Num() command is perfectly happy with any number preceded by the literal "R".

Is anyone aware of this as a feature or bug?  I tried looking in the scripting index but cannot think of a well-posed query for this.

Thanks!

Print( Num( "R404" ) );
Print( Num( "R123.456" ) );
Print( Num( "r99" ) );

/*
404
123.456
.
*/

Benjamin_Fuerst · Answer

@Audrey_Shull 
I was having an issue with a column imported as character. 
I could not see anything not numerical by eye.
But when making it a numeric, most values disappeared. (with JMP 16.2 Pro)

But using JMP 17EA I could straight away transform from character to numeric without values disappearing.
So there was some progress there.

Hope that helps!

Ben

Audrey_Shull · Answer

Greetings all. It looks like some work has been done for this issue in the JMP 17 timeframe. Specifically, an additional argument has been added to Num() and Informat() to help you control what is considered a valid number. Any JMP 17 EA7 (or later) users can try this out now; others will need to wait until JMP 17 is available in Fall of 2022. Thanks for reporting this! We do monitor these forums and look to fix things like this when possible.

Craige_Hales · Answer

I sent a note to JMP's doc and development teams. Thanks!