Remove columns from a table

Question

Hi everybody,

I need to export several tables (txt files containing 20 columns) under JMP, but only 10 columns are useful for my use.

How can I include in a script the deleting of specified columns? I have attached one example file: (1) the txt source (2) the JMP version with all columns (3) the final JMP version with 10 columns.

Thanks in advance,

Paul

Ebdo064-cleared.jmp

Ebdo064.jmp

Ebdo064.txt

paul_apicella · Answer

Thanks txnelson,

You're absolutely right, the solutions (at least the simple ones) are in the scripting guide. We're always in a hurry to take the time to check it out.

All works well.

Have a good day

Paul

txnelson · Answer

Here is the very simple script to delete the unwanted columns. names default to here(1); dt=current data table(); dt << delete columns("I-delai", "I-durée", "I-pos", "R-delai", "N°-Rec", "E-durée", "TR-max", "TM-max", "code-PP", "cod-R-d"); The details are covered in the scripting index Help==>Scripting Index To get started with scripting, I suggest you read the Scripting Guide Help==>JMP Documentation Library==>Scripting Guide