Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Creating a text file comma delimited

2 views
Skip to first unread message

David Palmer

unread,
Nov 2, 1998, 3:00:00 AM11/2/98
to
Try as I might, I can not seem to create a text file with the following
attributes.

Numerical value, numerical value, text value, numerical value Numerical
value, numerical value, text value, numerical value Numerical value,
numerical value, text value, numerical value .......................

I will be reading from lists that already exist and should have no
problems.

What I am trying to do is create a file that when read by MS Excel will
import easily with comma delimited spaces. Now this file will have a
mix of numerical values and text.

I have no problem creating a file with multiple ColumnForm[] numeric,
but I can not figure how to place a comma between them.

What I am getting is ...

Numerical value numerical value text value numerical value Numerical
value numerical value text value numerical value Numerical value
numerical value text value numerical value .......................


This should be easy, right? I checked DejaNews and the MathSource, read
countless pages and I know I am missing something easy.

Any help would be appreciated.

--
David Palmer
TANSTAAFL Research & Trading LLC
nospameve...@tanstaafl.net

Remove nospamever to reply.

Marilyn Justman

unread,
Jan 4, 1999, 3:00:00 AM1/4/99
to
This is a reply to ?David Palmer?'s query about producing a
comma-separated file.
You should know that Excel doesn't CARE what delimiter is used--space or
tab would do as well as comma, and if you're truly strapped, so will
"|" or any other single character. The trouble with space is that your
text items may have spaces in them.
So it only matters what format your data is NOW in, and what tools you
have available. If, for example, you know how to get your data into a
Microsoft Word table, do so, then convert the table to text, specifying
"tabs" between columns, save as ".csv" (this step is important to
Excel), and open in Excel. Or save as comma-separated in Word and
you're done.
If you're assembling this data, e.g. in UNIX with some less friendly
tools, I still suggest your building it so that there's one (and only
one) HT (ASCII 08? or 09? I never remember) between items, AND A CR/LF
at the end of every record...and you've got your file.

0 new messages