Let's say we have a table with 3 columns (example below). I create a subset of tables by the "city code" column that will include all 3 columns.
| City code | Registration Number | Registration Date |
| 032 | 0320537648 | 20201026 |
| 160 | 1600084082 | 20201020 |
| 281 | 2821162566 | 20201020 |
| 325 | 3250488500 | 20201024 |
| 420 | 4200618843 | 20201101 |
| 511 | 5110680174 | 20201027 |
| 720 | 7200054737 | 20200825 |
I would like to save only the subset files as text files as follows: city code value.txt
I found the following jsl script on the forum which was very helpful in saving the files as text files. The issue is that the files are saved as city code = value.txt
The main data table is also saved a text file, which I don't want.
//Save as txt file
openDTs = {};
For( i = 1, i <= N Table(), i++,
Insert Into( openDTs, Data Table( i ) )
);
For( i = 1, i <= N Items( openDTs ), i++,
one_name = openDTS[i] << get name;
file_path = one_name || ".txt";
openDTS[i] << Save(file_path);
);
I am new to both JMP and scripting, so any ideas are very much appreciated.
@txnelson Thank you so much! Worked like a charm.
