Save as a Text File

JMP can convert data from a JMP data table to standard text format with rows and columns. To save a data table as a text file, follow the steps below based on your operating system and how you want to save the file.

Text formatting options are:

•

Export Column Names to Text File To save column headings in the first line of text, and to save labels or header information with the data, select Export Table Headers.

•

End of Field Select the radio button next to the character that marks the end of a field (or cell). Select Other and enter a character if the appropriate character is not listed.

•

End of Line Select the radio button next to the character that marks the end of a line (or row). Select Other and enter a character if the appropriate character is not listed.

Notes:

•

If double quotation marks are found when importing text data, the delimiter rules change, and JMP looks for an end double quotation mark. Other text delimiters, including spaces embedded within the quotation marks, are ignored and treated as part of the text string.

•

When importing text data, columns that contain image data must be converted to Expression column property in order to reveal the image. See Column Properties for details.

•

On Windows, when you save a data table as a text file and then modify the data table, the text file is updated. After you save the data table as a text file, unless you save, close and reopen the data table, changes will be autosaved to the text file, not to the data table.

Windows

Select File > Save As.

Select Text Export File from the Save as type list.

Click the Options button and specify end-of-line and end-of-field characters, and choose whether to export column headings as text.

Click OK.