775411_zh-CN

liliconcom

如何使用最简单的脚本来获取子集？

设置表格飞机事件作为样本数据来解释我想要获得什么功能。

• 当列中的字符以“事故编号”开头时，取所有行的子集。
• 有办法-->选择数据过滤器-->填写“LA”-->手动选择所有列出的项目，然后复制以下脚本
• 这个脚本确实很长，另一个缺点是当有一些新的事故编号以“CH”开头但不包含在脚本中指定的字符中时，该项目将被取消选择。它不会遵循“过滤以 CH 开头的项目”的意图

请帮我考虑一些简单的方法来实现它。非常感谢！

// → 数据表（“飞机事故子集”）
数据表(“飞机事故”)<<选择位置(
:事故编号 == “CHI01FA064” | :事故编号 == “CHI01FA067” |
:事故编号 == “CHI01FA077” | :事故编号 == “CHI01FA080” |
:事故编号 == “CHI01FA083” | :事故编号 == “CHI01FA084” |
:事故编号 == “CHI01FA085” | :事故编号 == “CHI01FA089” |
:事故编号 == “CHI01FA093” | :事故编号 == “CHI01FA100” |
:事故编号 == “CHI01FA104” | :事故编号 == “CHI01FA111” |
:事故编号 == “CHI01FA113” | :事故编号 == “CHI01FA117” |
:事故编号 == “CHI01FA128” | :事故编号 == “CHI01FA129” |
:事故编号 == “CHI01FA130” | :事故编号 == “CHI01FA136” |
:事故编号 == “CHI01FA139” | :事故编号 == “CHI01FA146” |
:事故编号 == “CHI01FA165” | :事故编号 == “CHI01FA169” |
:事故编号 == “CHI01FA180” | :事故编号 == “CHI01FA186” |
:事故编号 == “CHI01FA204” | :事故编号 == “CHI01FA206” |
:事故编号 == “CHI01FA209” | :事故编号 == “CHI01FA218” |
:事故编号 == “CHI01FA220” | :事故编号 == “CHI01FA230” |
:事故编号 == “CHI01FA231” | :事故编号 == “CHI01FA232” |
:事故编号 == “CHI01FA233” | :事故编号 == “CHI01FA234” |
:事故编号 == “CHI01FA235” | :事故编号 == “CHI01FA244” |
:事故编号 == “CHI01FA247” | :事故编号 == “CHI01FA256” |
:事故编号 == “CHI01FA257” | :事故编号 == “CHI01FA270” |
:事故编号 == “CHI01FA290” | :事故编号 == “CHI01FA291” |
:事故编号 == “CHI01FA292” | :事故编号 == “CHI01FA297” |
:事故编号 == “CHI01FA298” | :事故编号 == “CHI01FA312” |
:事故编号 == “CHI01FA329” | :事故编号 == “CHI01IA073” |
:事故编号 == “CHI01IA124” | :事故编号 == “CHI01IA211” |
:事故编号 == “CHI01IA246” | :事故编号 == “CHI01IA248A” |
:事故编号 == “CHI01IA248B” | :事故编号 == “CHI01LA057” |
:事故编号 == "CHI01LA060" | :事故编号 == "CHI01LA061" |
:事故编号 == “CHI01LA062” | :事故编号 == “CHI01LA065” |
:事故编号 == "CHI01LA066" | :事故编号 == "CHI01LA068" |
:事故编号 == “CHI01LA069” | :事故编号 == “CHI01LA070” |
:事故编号 == “CHI01LA071” | :事故编号 == “CHI01LA072” |
:事故编号 == “CHI01LA074” | :事故编号 == “CHI01LA075” |
:事故编号 == "CHI01LA076" | :事故编号 == "CHI01LA078" |
:事故编号 == “CHI01LA079” | :事故编号 == “CHI01LA081” |
:事故编号 == “CHI01LA082” | :事故编号 == “CHI01LA086” |
:事故编号 == “CHI01LA088” | :事故编号 == “CHI01LA090” |
:事故编号 == “CHI01LA091” | :事故编号 == “CHI01LA092” |
:事故编号 == “CHI01LA094” | :事故编号 == “CHI01LA095” |
:事故编号 == "CHI01LA096" | :事故编号 == "CHI01LA097" |
:事故编号 == “CHI01LA098” | :事故编号 == “CHI01LA099” |
:事故编号 == "CHI01LA101" | :事故编号 == "CHI01LA103" |
:事故编号 == "CHI01LA105" | :事故编号 == "CHI01LA106" |
:事故编号 == "CHI01LA107" | :事故编号 == "CHI01LA109" |
:事故编号 == "CHI01LA112" | :事故编号 == "CHI01LA114" |
:事故编号 == "CHI01LA115" | :事故编号 == "CHI01LA116" |
:事故编号 == "CHI01LA118" | :事故编号 == "CHI01LA119" |
:事故编号 == "CHI01LA120" | :事故编号 == "CHI01LA121" |
:事故编号 == "CHI01LA122" | :事故编号 == "CHI01LA125" |
:事故编号 == "CHI01LA126" | :事故编号 == "CHI01LA127" |
:事故编号 == “CHI01LA131” | :事故编号 == “CHI01LA132” |
:事故编号 == "CHI01LA133" | :事故编号 == "CHI01LA134" |
:事故编号 == "CHI01LA135" | :事故编号 == "CHI01LA137" |
:事故编号 == "CHI01LA138" | :事故编号 == "CHI01LA140" |
:事故编号 == "CHI01LA141" | :事故编号 == "CHI01LA142" |
:事故编号 == “CHI01LA143” | :事故编号 == “CHI01LA144” |
:事故编号 == "CHI01LA145" | :事故编号 == "CHI01LA147" |
:事故编号 == "CHI01LA148" | :事故编号 == "CHI01LA149" |
:事故编号 == "CHI01LA150" | :事故编号 == "CHI01LA151" |
:事故编号 == "CHI01LA152" | :事故编号 == "CHI01LA153" |
:事故编号 == "CHI01LA154" | :事故编号 == "CHI01LA155" |
:事故编号 == "CHI01LA156" | :事故编号 == "CHI01LA157" |
:事故编号 == "CHI01LA158" | :事故编号 == "CHI01LA159" |
:事故编号 == "CHI01LA160" | :事故编号 == "CHI01LA161" |
:事故编号 == "CHI01LA162" | :事故编号 == "CHI01LA164" |
:事故编号 == "CHI01LA166" | :事故编号 == "CHI01LA167" |
:事故编号 == "CHI01LA168" | :事故编号 == "CHI01LA170" |
:事故编号 == “CHI01LA171” | :事故编号 == “CHI01LA172” |
:事故编号 == "CHI01LA173" | :事故编号 == "CHI01LA174" |
:事故编号 == "CHI01LA175" | :事故编号 == "CHI01LA176" |
:事故编号 == "CHI01LA177" | :事故编号 == "CHI01LA178" |
:事故编号 == “CHI01LA179” | :事故编号 == “CHI01LA181” |
:事故编号 == "CHI01LA182" | :事故编号 == "CHI01LA183" |
:事故编号 == “CHI01LA184” | :事故编号 == “CHI01LA185” |
:事故编号 == “CHI01LA187” | :事故编号 == “CHI01LA188” |
:事故编号 == "CHI01LA189" | :事故编号 == "CHI01LA190" |
:事故编号 == “CHI01LA191” | :事故编号 == “CHI01LA192” |
:事故编号 == "CHI01LA193" | :事故编号 == "CHI01LA194" |
:事故编号 == "CHI01LA195" | :事故编号 == "CHI01LA196" |
:事故编号 == “CHI01LA197” | :事故编号 == “CHI01LA198” |
:事故编号 == "CHI01LA199" | :事故编号 == "CHI01LA200" |
:事故编号 == "CHI01LA201" | :事故编号 == "CHI01LA202" |
:事故编号 == "CHI01LA203" | :事故编号 == "CHI01LA205" |
:事故编号 == "CHI01LA207" | :事故编号 == "CHI01LA208" |
:事故编号 == "CHI01LA210" | :事故编号 == "CHI01LA212" |
:事故编号 == "CHI01LA213" | :事故编号 == "CHI01LA214" |
:事故编号 == "CHI01LA215" | :事故编号 == "CHI01LA216" |
:事故编号 == “CHI01LA217” | :事故编号 == “CHI01LA219” |
:事故编号 == “CHI01LA221” | :事故编号 == “CHI01LA222” |
:事故编号 == "CHI01LA223" | :事故编号 == "CHI01LA224" |
:事故编号 == "CHI01LA225" | :事故编号 == "CHI01LA226" |
:事故编号 == “CHI01LA227” | :事故编号 == “CHI01LA228” |
:事故编号 == “CHI01LA229” | :事故编号 == “CHI01LA236” |
:事故编号 == "CHI01LA237" | :事故编号 == "CHI01LA238" |
:事故编号 == “CHI01LA239” | :事故编号 == “CHI01LA240” |
:事故编号 == “CHI01LA242” | :事故编号 == “CHI01LA243” |
:事故编号 == “CHI01LA245” | :事故编号 == “CHI01LA249” |
:事故编号 == "CHI01LA250" | :事故编号 == "CHI01LA251" |
:事故编号 == "CHI01LA252" | :事故编号 == "CHI01LA253" |
:事故编号 == "CHI01LA254" | :事故编号 == "CHI01LA255" |
:事故编号 == “CHI01LA258” | :事故编号 == “CHI01LA259” |
:事故编号 == “CHI01LA260” | :事故编号 == “CHI01LA261” |
:事故编号 == “CHI01LA262” | :事故编号 == “CHI01LA263” |
:事故编号 == “CHI01LA264” | :事故编号 == “CHI01LA265” |
:事故编号 == "CHI01LA266" | :事故编号 == "CHI01LA267" |
:事故编号 == “CHI01LA268” | :事故编号 == “CHI01LA269” |
:事故编号 == “CHI01LA271” | :事故编号 == “CHI01LA272” |
:事故编号 == “CHI01LA273” | :事故编号 == “CHI01LA274” |
:事故编号 == "CHI01LA275" | :事故编号 == "CHI01LA276" |
:事故编号 == "CHI01LA277" | :事故编号 == "CHI01LA278" |
:事故编号 == “CHI01LA279” | :事故编号 == “CHI01LA280” |
:事故编号 == “CHI01LA281” | :事故编号 == “CHI01LA282” |
:事故编号 == “CHI01LA283” | :事故编号 == “CHI01LA284” |
:事故编号 == “CHI01LA285” | :事故编号 == “CHI01LA286” |
:事故编号 == “CHI01LA287” | :事故编号 == “CHI01LA288” |
:事故编号 == “CHI01LA289” | :事故编号 == “CHI01LA293” |
:事故编号 == “CHI01LA294” | :事故编号 == “CHI01LA295” |
:事故编号 == "CHI01LA296" | :事故编号 == "CHI01LA299" |
:事故编号 == "CHI01LA300" | :事故编号 == "CHI01LA301" |
:事故编号 == "CHI01LA302" | :事故编号 == "CHI01LA303" |
:事故编号 == "CHI01LA304" | :事故编号 == "CHI01LA305" |
:事故编号 == "CHI01LA306" | :事故编号 == "CHI01LA307" |
:事故编号 == "CHI01LA308" | :事故编号 == "CHI01LA309" |
:事故编号 == "CHI01LA310" | :事故编号 == "CHI01LA311" |
:事故编号 == "CHI01LA313" | :事故编号 == "CHI01LA314" |
:事故编号 == “CHI01LA315” | :事故编号 == “CHI01LA316” |
:事故编号 == “CHI01LA317” | :事故编号 == “CHI01LA318” |
:事故编号 == “CHI01LA321” | :事故编号 == “CHI01LA322” |
:事故编号 == “CHI01LA323” | :事故编号 == “CHI01LA324” |
:事故编号 == "CHI01LA325" | :事故编号 == "CHI01LA326" |
:事故编号 == "CHI01LA327" | :事故编号 == "CHI01LA328" |
:事故编号 == "CHI01LA330" | :事故编号 == "CHI01LA331" |
:事故编号 == “CHI01LA332” | :事故编号 == “CHI01LA333” |
:事故编号 == “CHI01MA163” | :事故编号 == “CHI01TA063” |
:事故编号 == “CHI02FA001” | :事故编号 == “CHI02FA006” |
:事故编号 == “CHI02FA009” | :事故编号 == “CHI02FA025” |
:事故编号 == “CHI02FA033” | :事故编号 == “CHI02FA034” |
:事故编号 == “CHI02FA042” | :事故编号 == “CHI02FA049” |
:事故编号 == “CHI02FA059” | :事故编号 == “CHI02FAMS1” |
:事故编号 == "CHI02IA050" | :事故编号 == "CHI02IA058" |
:事故编号 == "CHI02LA002" | :事故编号 == "CHI02LA003" |
:事故编号 == "CHI02LA004" | :事故编号 == "CHI02LA005" |
:事故编号 == "CHI02LA007" | :事故编号 == "CHI02LA008" |
:事故编号 == "CHI02LA010" | :事故编号 == "CHI02LA011" |
:事故编号 == “CHI02LA012” | :事故编号 == “CHI02LA013” |
:事故编号 == “CHI02LA014” | :事故编号 == “CHI02LA015” |
:事故编号 == "CHI02LA016" | :事故编号 == "CHI02LA017" |
:事故编号 == “CHI02LA018” | :事故编号 == “CHI02LA019” |
:事故编号 == "CHI02LA020" | :事故编号 == "CHI02LA021" |
:事故编号 == "CHI02LA022" | :事故编号 == "CHI02LA023" |
:事故编号 == "CHI02LA024" | :事故编号 == "CHI02LA026" |
:事故编号 == "CHI02LA027" | :事故编号 == "CHI02LA028" |
:事故编号 == “CHI02LA029” | :事故编号 == “CHI02LA030” |
:事故编号 == “CHI02LA031” | :事故编号 == “CHI02LA032” |
:事故编号 == "CHI02LA035" | :事故编号 == "CHI02LA036" |
:事故编号 == “CHI02LA037” | :事故编号 == “CHI02LA038” |
:事故编号 == “CHI02LA039” | :事故编号 == “CHI02LA040” |
:事故编号 == “CHI02LA041” | :事故编号 == “CHI02LA043” |
:事故编号 == “CHI02LA044” | :事故编号 == “CHI02LA045” |
:事故编号 == “CHI02LA046” | :事故编号 == “CHI02LA047” |
:事故编号 == “CHI02LA048” | :事故编号 == “CHI02LA052” |
:事故编号 == “CHI02LA053” | :事故编号 == “CHI02LA054” |
:事故编号 == “CHI02LA055” | :事故编号 == “CHI02LA056”
) << 子集（选定行（ 1 ），仅选定列（ 0 ） ）；

自动化和脚本基础数据分析与建模数据混合和清理数据探索与可视化回复：如何使用最简单的脚本来获取子集？

如果你只是 :Accident Number 以 CH 开头的行，你可以使用Starts With()

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Aircraft Incidents.jmp");

dt << Select Where(Starts With(:Accident Number, "CH"));

对于子集，我将使用 Get Rows Where

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Aircraft Incidents.jmp");

rows_of_interest = dt << Get Rows Where(Starts With(:Accident Number, "CH"));

dt_ch = dt << Subset(Rows(rows_of_interest), Selected Columns(0), Output Table("CH Accidents"));

回复：如何使用最简单的脚本来获取子集？

看起来这就足够了。

Data Table( "Aircraft Incidents" ) << Select Where( Starts With( :Accident Number, "CH" ) )

回复：如何使用最简单的脚本来获取子集？

谢谢，它运行良好，在另一种情况下，如果我对需求进行一些更改，我想对所有包含“CH”字符的项目进行排序，无论它是前两个字符，可能是“CH”位于事故编号字符串的中间。我应该如何更改脚本？非常感谢！

回复：如何使用最简单的脚本来获取子集？

然后你可以使用Contains()

dt << Select Where(Contains(:Accident Number, "CH"));

我建议阅读这篇较早的博客文章JSL 字符串函数，了解一些基础知识（以及我不使用的 munger）。还有JSL 语法参考 > JSL 函数、运算符和消息 > 字符函数

回复：如何使用最简单的脚本来获取子集？

多谢！