Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
twillkickers
Level III

Only select rows where the first character of the contained string is a number, not a letter

How can I use JSL to only select rows that contain a string that begins with a number, while ignoring strings that begin with a letter?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ms
Super User ms
Super User

Re: Only select rows where the first character of the contained string is a number, not a letter

There are several ways to do this. Here are two examples. 

 

dt << select where(!Is Missing(Num(Left(:data[], 1))));

dt << select where(!Is Missing(Regex(Left(:data[], 1), "^\d")));

View solution in original post

1 REPLY 1
Highlighted
ms
Super User ms
Super User

Re: Only select rows where the first character of the contained string is a number, not a letter

There are several ways to do this. Here are two examples. 

 

dt << select where(!Is Missing(Num(Left(:data[], 1))));

dt << select where(!Is Missing(Regex(Left(:data[], 1), "^\d")));

View solution in original post

Article Labels

    There are no labels assigned to this post.