Group Abstract Group Abstract

Message Boards Message Boards

0
|
12K Views
|
8 Replies
|
0 Total Likes
View groups...
Share
Share this post:

Export numbers in two columns, without braces or commas?

David Kirkby
Posted 4 years ago
POSTED BY: David Kirkby
8 Replies
Sort By:
Rohit Namjoshi
Rohit Namjoshi
Posted 4 years ago

Another way

Export["t.txt", t, "Table", "FieldSeparators" -> " "]
POSTED BY: Rohit Namjoshi
David Kirkby
David Kirkby
Posted 4 years ago

Thank you. That's essentially the same as Sean's. I assume your posts overlapped, as they were posted within a few minutes of each other. .
POSTED BY: David Kirkby
Sean Cheren
Sean Cheren, Wolfram
Posted 4 years ago

Check ref/format/Table for more options but FieldSeparators is what you're looking for:

Export["test.txt", t, "Table", "FieldSeparators" -> " "]
POSTED BY: Sean Cheren
David Kirkby
David Kirkby
Posted 4 years ago

Thank you. That works, and the meaning is quite clear.

POSTED BY: David Kirkby

This will work.

StringReplace[ExportString[t, "CSV"], "," -> " "]

Possibly there is an option setting that will obviate the need for StringReplace. Alternatively, use "TSV" as the format.
POSTED BY: Daniel Lichtblau
David Kirkby
David Kirkby
Posted 4 years ago

Daniel, Thank you for the reply. However, I'm totally lost on how to apply this when exporting a file - there's no filename in your code.

POSTED BY: David Kirkby
Andrew Burnett
Andrew Burnett
Posted 4 years ago

I have no doubt there are better ways of doing this, but I think the following will give you what you want.

Export["text1.txt", 
 StringJoin[ToString[#[[1]]], "\t", ToString[#[[2]]], "\r"] & /@ 
  t, "Text"]

It will create a text file containing all the number pairs, separated by a tab, and with each line ended by a return.
POSTED BY: Andrew Burnett
David Kirkby
David Kirkby
Posted 4 years ago

Thank you. Since I want a space, not a tab, it suites my needs if I replace the "\t" with " ". I was hoping there would be a simpler way.

POSTED BY: David Kirkby
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard