341505_en-US

liliconcom

How can efficiently write qualifying line numbers into different variables?

Using "Big Class.jmp".

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt<<NEW column=""></NEW>

When a name contains the letter "B", the line number of that name is written to a different variable.
For example: r1=8;r2=9;r3=17...

Thanks!

ScriptingRe: How can efficiently write qualifying line numbers into different variables?

r = {"", "", "", "", "", "", "", "", ""};
i = 0;
dt << New Column( "rows",
 formula(
  If( Contains( name, "B" ),
   i = i + 1;
   r[i] = Row();
   Row();
  )
 )
);
dt << run formulas;
Column( "rows" ) << deleteFormula;