World Statistics Day was yesterday, but we’re celebrating all week long! This celebration means acknowledging the impact statistics has on our world. Who is your favorite statistician? Share with us who they are and why they top your favorites list.
Jan 9, 2015 11:22 AM
| Last Modified: Oct 18, 2016 3:19 PM
JSL to find the formulas in a JMP data table and write a CSV (comma separated value) file. There is an open issue for exporting formulas to Excel; maybe this script can serve as a starting point to determine what is really needed.
The code also demonstrates a simple use of Regex, user functions, and saving a file to the $TEMP directory.
This code has only been tested on the included data table.
which opens this table
which the attached JSL exports to this CSV text
If the .CSV file is opened in Excel, the formulas are character fields.