https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775439#M95764 <P>Thanks, it works well, in another case, if i changes a little bit for the requirment, i want sort all items which contains "CH" charaters no matter it is the first two charaters, may be the "CH" is in the middle for Accident Number string. how i should change the script ? Thanks a lot!</P> Thu, 25 Jul 2024 17:26:08 GMT Sean_ShCn0 2024-07-25T17:26:08Z https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775411#M95761 <P>set table aircraft incidents as a sample data to explain what function I want to get.</P><UL><LI>subset all row, when the charators in column starts "Accident Number".&nbsp;</LI><LI>there is way--&gt; select data filter--&gt;filling "LA"--&gt;manual select all list out items, then copy the scripts as following</LI><LI>this script is really very long, another disadvantage is when there are some new accident number start with "CH" but not include in the specified charaters in the script, this item will be unselected. it will not flollow the intention "filter our items start with CH"</LI></UL><P>Please help me to consider some simple way to make it. thanks a lot!</P><P>&nbsp;</P><P>// → Data Table( "Subset of Aircraft Incidents" )<BR />Data Table( "Aircraft Incidents" ) &lt;&lt; Select Where(<BR />:Accident Number == "CHI01FA064" | :Accident Number == "CHI01FA067" |<BR />:Accident Number == "CHI01FA077" | :Accident Number == "CHI01FA080" |<BR />:Accident Number == "CHI01FA083" | :Accident Number == "CHI01FA084" |<BR />:Accident Number == "CHI01FA085" | :Accident Number == "CHI01FA089" |<BR />:Accident Number == "CHI01FA093" | :Accident Number == "CHI01FA100" |<BR />:Accident Number == "CHI01FA104" | :Accident Number == "CHI01FA111" |<BR />:Accident Number == "CHI01FA113" | :Accident Number == "CHI01FA117" |<BR />:Accident Number == "CHI01FA128" | :Accident Number == "CHI01FA129" |<BR />:Accident Number == "CHI01FA130" | :Accident Number == "CHI01FA136" |<BR />:Accident Number == "CHI01FA139" | :Accident Number == "CHI01FA146" |<BR />:Accident Number == "CHI01FA165" | :Accident Number == "CHI01FA169" |<BR />:Accident Number == "CHI01FA180" | :Accident Number == "CHI01FA186" |<BR />:Accident Number == "CHI01FA204" | :Accident Number == "CHI01FA206" |<BR />:Accident Number == "CHI01FA209" | :Accident Number == "CHI01FA218" |<BR />:Accident Number == "CHI01FA220" | :Accident Number == "CHI01FA230" |<BR />:Accident Number == "CHI01FA231" | :Accident Number == "CHI01FA232" |<BR />:Accident Number == "CHI01FA233" | :Accident Number == "CHI01FA234" |<BR />:Accident Number == "CHI01FA235" | :Accident Number == "CHI01FA244" |<BR />:Accident Number == "CHI01FA247" | :Accident Number == "CHI01FA256" |<BR />:Accident Number == "CHI01FA257" | :Accident Number == "CHI01FA270" |<BR />:Accident Number == "CHI01FA290" | :Accident Number == "CHI01FA291" |<BR />:Accident Number == "CHI01FA292" | :Accident Number == "CHI01FA297" |<BR />:Accident Number == "CHI01FA298" | :Accident Number == "CHI01FA312" |<BR />:Accident Number == "CHI01FA329" | :Accident Number == "CHI01IA073" |<BR />:Accident Number == "CHI01IA124" | :Accident Number == "CHI01IA211" |<BR />:Accident Number == "CHI01IA246" | :Accident Number == "CHI01IA248A" |<BR />:Accident Number == "CHI01IA248B" | :Accident Number == "CHI01LA057" |<BR />:Accident Number == "CHI01LA060" | :Accident Number == "CHI01LA061" |<BR />:Accident Number == "CHI01LA062" | :Accident Number == "CHI01LA065" |<BR />:Accident Number == "CHI01LA066" | :Accident Number == "CHI01LA068" |<BR />:Accident Number == "CHI01LA069" | :Accident Number == "CHI01LA070" |<BR />:Accident Number == "CHI01LA071" | :Accident Number == "CHI01LA072" |<BR />:Accident Number == "CHI01LA074" | :Accident Number == "CHI01LA075" |<BR />:Accident Number == "CHI01LA076" | :Accident Number == "CHI01LA078" |<BR />:Accident Number == "CHI01LA079" | :Accident Number == "CHI01LA081" |<BR />:Accident Number == "CHI01LA082" | :Accident Number == "CHI01LA086" |<BR />:Accident Number == "CHI01LA088" | :Accident Number == "CHI01LA090" |<BR />:Accident Number == "CHI01LA091" | :Accident Number == "CHI01LA092" |<BR />:Accident Number == "CHI01LA094" | :Accident Number == "CHI01LA095" |<BR />:Accident Number == "CHI01LA096" | :Accident Number == "CHI01LA097" |<BR />:Accident Number == "CHI01LA098" | :Accident Number == "CHI01LA099" |<BR />:Accident Number == "CHI01LA101" | :Accident Number == "CHI01LA103" |<BR />:Accident Number == "CHI01LA105" | :Accident Number == "CHI01LA106" |<BR />:Accident Number == "CHI01LA107" | :Accident Number == "CHI01LA109" |<BR />:Accident Number == "CHI01LA112" | :Accident Number == "CHI01LA114" |<BR />:Accident Number == "CHI01LA115" | :Accident Number == "CHI01LA116" |<BR />:Accident Number == "CHI01LA118" | :Accident Number == "CHI01LA119" |<BR />:Accident Number == "CHI01LA120" | :Accident Number == "CHI01LA121" |<BR />:Accident Number == "CHI01LA122" | :Accident Number == "CHI01LA125" |<BR />:Accident Number == "CHI01LA126" | :Accident Number == "CHI01LA127" |<BR />:Accident Number == "CHI01LA131" | :Accident Number == "CHI01LA132" |<BR />:Accident Number == "CHI01LA133" | :Accident Number == "CHI01LA134" |<BR />:Accident Number == "CHI01LA135" | :Accident Number == "CHI01LA137" |<BR />:Accident Number == "CHI01LA138" | :Accident Number == "CHI01LA140" |<BR />:Accident Number == "CHI01LA141" | :Accident Number == "CHI01LA142" |<BR />:Accident Number == "CHI01LA143" | :Accident Number == "CHI01LA144" |<BR />:Accident Number == "CHI01LA145" | :Accident Number == "CHI01LA147" |<BR />:Accident Number == "CHI01LA148" | :Accident Number == "CHI01LA149" |<BR />:Accident Number == "CHI01LA150" | :Accident Number == "CHI01LA151" |<BR />:Accident Number == "CHI01LA152" | :Accident Number == "CHI01LA153" |<BR />:Accident Number == "CHI01LA154" | :Accident Number == "CHI01LA155" |<BR />:Accident Number == "CHI01LA156" | :Accident Number == "CHI01LA157" |<BR />:Accident Number == "CHI01LA158" | :Accident Number == "CHI01LA159" |<BR />:Accident Number == "CHI01LA160" | :Accident Number == "CHI01LA161" |<BR />:Accident Number == "CHI01LA162" | :Accident Number == "CHI01LA164" |<BR />:Accident Number == "CHI01LA166" | :Accident Number == "CHI01LA167" |<BR />:Accident Number == "CHI01LA168" | :Accident Number == "CHI01LA170" |<BR />:Accident Number == "CHI01LA171" | :Accident Number == "CHI01LA172" |<BR />:Accident Number == "CHI01LA173" | :Accident Number == "CHI01LA174" |<BR />:Accident Number == "CHI01LA175" | :Accident Number == "CHI01LA176" |<BR />:Accident Number == "CHI01LA177" | :Accident Number == "CHI01LA178" |<BR />:Accident Number == "CHI01LA179" | :Accident Number == "CHI01LA181" |<BR />:Accident Number == "CHI01LA182" | :Accident Number == "CHI01LA183" |<BR />:Accident Number == "CHI01LA184" | :Accident Number == "CHI01LA185" |<BR />:Accident Number == "CHI01LA187" | :Accident Number == "CHI01LA188" |<BR />:Accident Number == "CHI01LA189" | :Accident Number == "CHI01LA190" |<BR />:Accident Number == "CHI01LA191" | :Accident Number == "CHI01LA192" |<BR />:Accident Number == "CHI01LA193" | :Accident Number == "CHI01LA194" |<BR />:Accident Number == "CHI01LA195" | :Accident Number == "CHI01LA196" |<BR />:Accident Number == "CHI01LA197" | :Accident Number == "CHI01LA198" |<BR />:Accident Number == "CHI01LA199" | :Accident Number == "CHI01LA200" |<BR />:Accident Number == "CHI01LA201" | :Accident Number == "CHI01LA202" |<BR />:Accident Number == "CHI01LA203" | :Accident Number == "CHI01LA205" |<BR />:Accident Number == "CHI01LA207" | :Accident Number == "CHI01LA208" |<BR />:Accident Number == "CHI01LA210" | :Accident Number == "CHI01LA212" |<BR />:Accident Number == "CHI01LA213" | :Accident Number == "CHI01LA214" |<BR />:Accident Number == "CHI01LA215" | :Accident Number == "CHI01LA216" |<BR />:Accident Number == "CHI01LA217" | :Accident Number == "CHI01LA219" |<BR />:Accident Number == "CHI01LA221" | :Accident Number == "CHI01LA222" |<BR />:Accident Number == "CHI01LA223" | :Accident Number == "CHI01LA224" |<BR />:Accident Number == "CHI01LA225" | :Accident Number == "CHI01LA226" |<BR />:Accident Number == "CHI01LA227" | :Accident Number == "CHI01LA228" |<BR />:Accident Number == "CHI01LA229" | :Accident Number == "CHI01LA236" |<BR />:Accident Number == "CHI01LA237" | :Accident Number == "CHI01LA238" |<BR />:Accident Number == "CHI01LA239" | :Accident Number == "CHI01LA240" |<BR />:Accident Number == "CHI01LA242" | :Accident Number == "CHI01LA243" |<BR />:Accident Number == "CHI01LA245" | :Accident Number == "CHI01LA249" |<BR />:Accident Number == "CHI01LA250" | :Accident Number == "CHI01LA251" |<BR />:Accident Number == "CHI01LA252" | :Accident Number == "CHI01LA253" |<BR />:Accident Number == "CHI01LA254" | :Accident Number == "CHI01LA255" |<BR />:Accident Number == "CHI01LA258" | :Accident Number == "CHI01LA259" |<BR />:Accident Number == "CHI01LA260" | :Accident Number == "CHI01LA261" |<BR />:Accident Number == "CHI01LA262" | :Accident Number == "CHI01LA263" |<BR />:Accident Number == "CHI01LA264" | :Accident Number == "CHI01LA265" |<BR />:Accident Number == "CHI01LA266" | :Accident Number == "CHI01LA267" |<BR />:Accident Number == "CHI01LA268" | :Accident Number == "CHI01LA269" |<BR />:Accident Number == "CHI01LA271" | :Accident Number == "CHI01LA272" |<BR />:Accident Number == "CHI01LA273" | :Accident Number == "CHI01LA274" |<BR />:Accident Number == "CHI01LA275" | :Accident Number == "CHI01LA276" |<BR />:Accident Number == "CHI01LA277" | :Accident Number == "CHI01LA278" |<BR />:Accident Number == "CHI01LA279" | :Accident Number == "CHI01LA280" |<BR />:Accident Number == "CHI01LA281" | :Accident Number == "CHI01LA282" |<BR />:Accident Number == "CHI01LA283" | :Accident Number == "CHI01LA284" |<BR />:Accident Number == "CHI01LA285" | :Accident Number == "CHI01LA286" |<BR />:Accident Number == "CHI01LA287" | :Accident Number == "CHI01LA288" |<BR />:Accident Number == "CHI01LA289" | :Accident Number == "CHI01LA293" |<BR />:Accident Number == "CHI01LA294" | :Accident Number == "CHI01LA295" |<BR />:Accident Number == "CHI01LA296" | :Accident Number == "CHI01LA299" |<BR />:Accident Number == "CHI01LA300" | :Accident Number == "CHI01LA301" |<BR />:Accident Number == "CHI01LA302" | :Accident Number == "CHI01LA303" |<BR />:Accident Number == "CHI01LA304" | :Accident Number == "CHI01LA305" |<BR />:Accident Number == "CHI01LA306" | :Accident Number == "CHI01LA307" |<BR />:Accident Number == "CHI01LA308" | :Accident Number == "CHI01LA309" |<BR />:Accident Number == "CHI01LA310" | :Accident Number == "CHI01LA311" |<BR />:Accident Number == "CHI01LA313" | :Accident Number == "CHI01LA314" |<BR />:Accident Number == "CHI01LA315" | :Accident Number == "CHI01LA316" |<BR />:Accident Number == "CHI01LA317" | :Accident Number == "CHI01LA318" |<BR />:Accident Number == "CHI01LA321" | :Accident Number == "CHI01LA322" |<BR />:Accident Number == "CHI01LA323" | :Accident Number == "CHI01LA324" |<BR />:Accident Number == "CHI01LA325" | :Accident Number == "CHI01LA326" |<BR />:Accident Number == "CHI01LA327" | :Accident Number == "CHI01LA328" |<BR />:Accident Number == "CHI01LA330" | :Accident Number == "CHI01LA331" |<BR />:Accident Number == "CHI01LA332" | :Accident Number == "CHI01LA333" |<BR />:Accident Number == "CHI01MA163" | :Accident Number == "CHI01TA063" |<BR />:Accident Number == "CHI02FA001" | :Accident Number == "CHI02FA006" |<BR />:Accident Number == "CHI02FA009" | :Accident Number == "CHI02FA025" |<BR />:Accident Number == "CHI02FA033" | :Accident Number == "CHI02FA034" |<BR />:Accident Number == "CHI02FA042" | :Accident Number == "CHI02FA049" |<BR />:Accident Number == "CHI02FA059" | :Accident Number == "CHI02FAMS1" |<BR />:Accident Number == "CHI02IA050" | :Accident Number == "CHI02IA058" |<BR />:Accident Number == "CHI02LA002" | :Accident Number == "CHI02LA003" |<BR />:Accident Number == "CHI02LA004" | :Accident Number == "CHI02LA005" |<BR />:Accident Number == "CHI02LA007" | :Accident Number == "CHI02LA008" |<BR />:Accident Number == "CHI02LA010" | :Accident Number == "CHI02LA011" |<BR />:Accident Number == "CHI02LA012" | :Accident Number == "CHI02LA013" |<BR />:Accident Number == "CHI02LA014" | :Accident Number == "CHI02LA015" |<BR />:Accident Number == "CHI02LA016" | :Accident Number == "CHI02LA017" |<BR />:Accident Number == "CHI02LA018" | :Accident Number == "CHI02LA019" |<BR />:Accident Number == "CHI02LA020" | :Accident Number == "CHI02LA021" |<BR />:Accident Number == "CHI02LA022" | :Accident Number == "CHI02LA023" |<BR />:Accident Number == "CHI02LA024" | :Accident Number == "CHI02LA026" |<BR />:Accident Number == "CHI02LA027" | :Accident Number == "CHI02LA028" |<BR />:Accident Number == "CHI02LA029" | :Accident Number == "CHI02LA030" |<BR />:Accident Number == "CHI02LA031" | :Accident Number == "CHI02LA032" |<BR />:Accident Number == "CHI02LA035" | :Accident Number == "CHI02LA036" |<BR />:Accident Number == "CHI02LA037" | :Accident Number == "CHI02LA038" |<BR />:Accident Number == "CHI02LA039" | :Accident Number == "CHI02LA040" |<BR />:Accident Number == "CHI02LA041" | :Accident Number == "CHI02LA043" |<BR />:Accident Number == "CHI02LA044" | :Accident Number == "CHI02LA045" |<BR />:Accident Number == "CHI02LA046" | :Accident Number == "CHI02LA047" |<BR />:Accident Number == "CHI02LA048" | :Accident Number == "CHI02LA052" |<BR />:Accident Number == "CHI02LA053" | :Accident Number == "CHI02LA054" |<BR />:Accident Number == "CHI02LA055" | :Accident Number == "CHI02LA056"<BR />) &lt;&lt; Subset( Selected Rows( 1 ), Selected columns only( 0 ) );</P> Thu, 25 Jul 2024 17:03:29 GMT https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775411#M95761 Sean_ShCn0 2024-07-25T17:03:29Z https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775424#M95762 <P>If you just the rows in which :Accident Number starts with CH you can use <A href="https://help.jmp.com/help?keyword=JSL%20Starts%20With&amp;lang=en&amp;os=win&amp;source=application&amp;version=17.2.0" target="_blank" rel="noopener">Starts With()</A></P> <PRE><CODE class=" language-jsl">Names Default To Here(1); dt = Open("$SAMPLE_DATA/Aircraft Incidents.jmp"); dt &lt;&lt; Select Where(Starts With(:Accident Number, "CH"));</CODE></PRE> <P>And with subset I would use Get Rows Where</P> <PRE><CODE class=" language-jsl">Names Default To Here(1); dt = Open("$SAMPLE_DATA/Aircraft Incidents.jmp"); rows_of_interest = dt &lt;&lt; Get Rows Where(Starts With(:Accident Number, "CH")); dt_ch = dt &lt;&lt; Subset(Rows(rows_of_interest), Selected Columns(0), Output Table("CH Accidents"));</CODE></PRE> Thu, 25 Jul 2024 17:15:54 GMT https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775424#M95762 jthi 2024-07-25T17:15:54Z https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775427#M95763 <P>It looks like this would suffice.</P><P>&nbsp;</P><PRE><CODE class=" language-jsl">Data Table( "Aircraft Incidents" ) &lt;&lt; Select Where( Starts With( :Accident Number, "CH" ) )</CODE></PRE> Thu, 25 Jul 2024 17:17:18 GMT https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775427#M95763 mmarchandFSLR 2024-07-25T17:17:18Z https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775439#M95764 <P>Thanks, it works well, in another case, if i changes a little bit for the requirment, i want sort all items which contains "CH" charaters no matter it is the first two charaters, may be the "CH" is in the middle for Accident Number string. how i should change the script ? Thanks a lot!</P> Thu, 25 Jul 2024 17:26:08 GMT https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775439#M95764 Sean_ShCn0 2024-07-25T17:26:08Z https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775475#M95766 <P>Then you can use <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/character-functions-2.shtml?os=win&amp;source=application#ww2467451" target="_blank" rel="noopener">Contains()</A></P> <PRE><CODE class=" language-jsl">dt &lt;&lt; Select Where(Contains(:Accident Number, "CH"));</CODE></PRE> <P>I suggest reading this bit older blog post <LI-MESSAGE title="JSL Character String Functions" uid="21323" url="https://community.jmp.com/t5/Uncharted/JSL-Character-String-Functions/m-p/21323#U21323" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-blog-thread lia-fa-icon lia-fa-blog lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;for some basic (and munger which I don't use). Also <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/character-functions-2.shtml#ww2427289" target="_blank" rel="noopener"> JSL Syntax Reference &gt; JSL Functions, Operators, and Messages &gt; Character Functions</A></P> Thu, 25 Jul 2024 19:13:30 GMT https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775475#M95766 jthi 2024-07-25T19:13:30Z https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775480#M95767 <P>Thanks a lot!</P> Thu, 25 Jul 2024 19:34:58 GMT https://community.jmp.com/t5/Discussions/How-to-use-a-simplest-script-for-subset/m-p/775480#M95767 Sean_ShCn0 2024-07-25T19:34:58Z