topic Only select rows where the first character of the contained string is a number, not a letter in Discussions https://community.jmp.com/t5/Discussions/Only-select-rows-where-the-first-character-of-the-contained/m-p/225591#M44790 <P>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?</P> Thu, 12 Sep 2019 17:28:40 GMT twillkickers 2019-09-12T17:28:40Z Only select rows where the first character of the contained string is a number, not a letter https://community.jmp.com/t5/Discussions/Only-select-rows-where-the-first-character-of-the-contained/m-p/225591#M44790 <P>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?</P> Thu, 12 Sep 2019 17:28:40 GMT https://community.jmp.com/t5/Discussions/Only-select-rows-where-the-first-character-of-the-contained/m-p/225591#M44790 twillkickers 2019-09-12T17:28:40Z Re: Only select rows where the first character of the contained string is a number, not a letter https://community.jmp.com/t5/Discussions/Only-select-rows-where-the-first-character-of-the-contained/m-p/225600#M44791 <P>There are several ways to do this. Here are two examples.&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-jsl">dt &lt;&lt; select where(!Is Missing(Num(Left(:data[], 1)))); dt &lt;&lt; select where(!Is Missing(Regex(Left(:data[], 1), "^\d"))); </CODE></PRE> Thu, 12 Sep 2019 17:47:07 GMT https://community.jmp.com/t5/Discussions/Only-select-rows-where-the-first-character-of-the-contained/m-p/225600#M44791 ms 2019-09-12T17:47:07Z