Sometimes export filters place something other than quotation marks around fields. In these instances, specify the delimiter in the Settings window under Unusual Files.
Text in a CSV file might also contain escape sequences such as a backslash instead of doubling the quotation mark. You also specify the delimiter in the Settings window under Unusual Files.
Tips:
• Keep dialog open is off by default, but you might turn it on while testing. This enables you to import files to see what the data looks like, edit the source files if necessary, and reimport them with the same settings.
• When you import files that are not supported, a data table called “@ Unused Files” is created. The file names are listed in the Files table script. Right-click the script and select Edit. To output the file names of unsupported files in this data table, select Add file name column on the Multiple File Import window.
• Right-click the Files list and select Sort by Column to change the way the Files list is sorted.
• The Import button is unavailable if no files match the filters that you selected.
• JMP automatically changes the CSV settings when you select either of the two options for Text Explorer-style data (the bottom center radio buttons). A delimiter is not specified, which loads all data in one column. JMP also changes the CSV settings to not use an end-of-line character, which loads the entire file in one row. You can also change the CSV settings. If you try the manual approach, be sure to set No Headers and First Data Line to 1.