Split a long column begins with a keyword and ends 1 row before another keyword is reached

new_2_JMP

Split a long column begins with a keyword and ends 1 row before another keyword is reached. Please see attached example Excel file for the data table before and after the split

 

Number of test per frequency is not always the same from as high as test20 to as low as test 13
Number of frequency test is not in an increment of 100 but they can be place in a list. In our example, 
the frequency list is (100, 200, 300, 400, 500, 550, 650)

 

Thanks

new_2-JMP

JMP_split_by_keywords.xlsx

txnelson

Just create a new column that increments by 1, every time the Original column has Freq in it's value.  Then split on the new column.

Here is a simple script that does it

names default to here(1);
dt=current data table();
dt<<new column("split");
for each row(if(row()==1,hold=0);
	if(left(:Original,4) == "Freq", hold++);
	:split=hold
);

dt << Split(
	Split By( :split ),
	Split( :Original ),
	Sort by Column Property
);