For the latest version of JMP Help, visit JMP.com/help.


Publication date: 11/10/2021

Save JMP Data as a Text File

JMP can convert data from a JMP data table to standard text format with rows and columns.

Text Formatting Options

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.

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.

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).