Publication date: 08/13/2020

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 as follows:

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.

Add quotation marks to all column names, Add quotation marks to all character values, Add quotation marks to all numeric values

Select an option to add quotation marks even when they are not required. Some programs that import CSV files might need the quotation marks to display the text correctly. Quotation marks are always added to fields that contain special characters such as the field delimiter (typically a comma or tab), the line separator (typically a carriage return), or quotation marks.

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 a double quotation mark is 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 you import text data, columns that contain image data are assigned the Expression data type.

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

1. Select File > Export.

2. Select Text and then click Next.

3. Enter the file name in the File name box.

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

5. Click OK.

6. (Optional) To avoid opening the file in the default text editor after saving, deselect Open the file after saving.

7. Click Save.

An alert appears regarding loss of formulas, formatting information, and other metadata.

8. Click Yes.

macOS

1. Select File > Export.

2. Select Text and then click Next.

3. Enter a name for the file in the Save As box.

4. Specify end-of-line and end-of-field characters, and choose whether to export column headings as text.

5. (Optional) To avoid opening the file in the default text editor after saving, deselect Open the file after saving.

6. Click Export.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).
.