cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles