Hi, how do I write a script to delete columns not containing a certain word? I would like to delete column names that do not have the word "4C4QC30.0" in them
![Column.PNG Column.PNG](https://community.jmp.com/t5/image/serverpage/image-id/14847iF939176AB67C6194/image-size/large?v=v2&px=999)
My script below unfortunately does not work:
For( i = 11, i <= N Cols( dt1_new ), i++, // set number of columns to start looking at
If( (Column( dt1_new, i ) << Get Name) != "4C4QC30.0.Cv", //
dt1_new << Delete Column ;
)
);
thanks!