topic Re: Save as CSV File - unclear instructions in Discussions

Save as CSV File - unclear instructions

thebilly31 — Thu, 01 Nov 2018 13:07:55 GMT

I am trying to save a subset of a table which is in sav format into a csv file. Under this link I got clear instructions. However, my JMP14 does not have the option to select a type list to save in.

What can I do?

Re: Save as CSV File - unclear instructions

txnelson — Thu, 01 Nov 2018 13:30:48 GMT

when you select

File==>Save As

Do you have a drop down arrow like in the image below

Re: Save as CSV File - unclear instructions

Jeff_Perkinson — Thu, 01 Nov 2018 13:45:44 GMT

If you're using a Mac you should choose File->Export instead of File->Save As...

Re: Save as CSV File - unclear instructions

thebilly31 — Thu, 01 Nov 2018 13:51:23 GMT

No I don't. I am using JMP14 on a Mac so I guess it is different from Windows, but still in other applications I have such a field where I can save as something.

Re: Save as CSV File - unclear instructions

thebilly31 — Thu, 01 Nov 2018 15:51:22 GMT

Thank you. That is better than no file. Is there a way to export to csv?

Re: Save as CSV File - unclear instructions

Jeff_Perkinson — Thu, 01 Nov 2018 18:14:14 GMT

Choose Text and on the subsequent dialog set the End of Field delimiter to "Comma". Make sure that the "Hide Extension" checkbox in the lower right is off and you can change the extension from ".dat" to ".csv".