cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Wei1
Level II

How to export a txt file without double quotes?

Hi All,

 

I'd like to export a txt file without double quotes,is there another way?

thank you.

 

<Datatable>

Wei1_0-1687609104870.png

 

<Export Options>

Wei1_1-1687609128939.png

 

<txt file>

Wei1_2-1687609160792.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to export a txt file without double quotes?

The issue seems to be that there are commas in the column.  I added a comma to the first row's name in the Big Class data table

txnelson_0-1687616439794.png

and then saved it as a txt file using your export settings, and what I got was

txnelson_1-1687616525076.png

What I suggest is for you to separate each comma field into separate columns

txnelson_2-1687616654569.png

Set your export preferences to

txnelson_3-1687616719850.png

and you will get

txnelson_4-1687616844968.png

 

 

Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: How to export a txt file without double quotes?

The issue seems to be that there are commas in the column.  I added a comma to the first row's name in the Big Class data table

txnelson_0-1687616439794.png

and then saved it as a txt file using your export settings, and what I got was

txnelson_1-1687616525076.png

What I suggest is for you to separate each comma field into separate columns

txnelson_2-1687616654569.png

Set your export preferences to

txnelson_3-1687616719850.png

and you will get

txnelson_4-1687616844968.png

 

 

Jim