Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
tmyanh1993
Level II

Simple way to convert multiple .jmp files into .csv files (no modification) in 2 steps

Hi all, 

 

My daily work requires me to save many .jmp tables as .csv tables, which takes a lot of time if I use Save as function (can save each file only, need to answer repeated questions from JMP, need to choose directories for each file). I learned from JMP community and composed a simple script. Now it takes only 2 steps: 

Step 1: Open all .jmp tables you want to convert to .csv

Step 2: Run the script --> It will ask where you want to store the new .csv files --> Click OK. 

The picked directory will be opened with new .csv created; meanwhile, all .jmp data tables will be closed. 

 

That's it. Hope it help. 

 

Comments

Thanks a lot!!!!!

This is a very useful script!  I also need to output Excel files, so changed the file_path and openDTS[i] lines to

 

file_path = file_dir || one_name || ".csv"; //Use the copied name for the new .csv's name
file_pathE = file_dir || one_name || ".xls"; //Same root for new .xls file
openDTS[i] << Save( file_path ); //Save as csv files
openDTS[i] << Save( file_pathE ); // Save as Excel

 

Article Labels
Article Tags
Contributors