Re: Importing tab-delimited data files?
- To: mathgroup at smc.vnet.net
- Subject: [mg62865] Re: Importing tab-delimited data files?
- From: "Hans Michel" <hmichel at cox.net>
- Date: Tue, 6 Dec 2005 23:11:08 -0500 (EST)
- Reply-to: <hmichel at cox.net>
- Sender: owner-wri-mathgroup at wolfram.com
This may have posted but
This is a Tabular separated values with empty fields.
So use
Import["yourfilehere","TSV", ConversionOptions -> {"EmptyField" -> ""} ]
No tab or newline options needed.
"AES" <siegman at stanford.edu> wrote in message
news:dmh9o2$908$1 at smc.vnet.net...
>I create a text file "filedata" with the following content using a text
> editor, with tabs between each number or string (5 tabs per line), and
> no content -- not even a space, just successive adjacent tabs -- in the
> empty slots.
>
> (The columns should line up if your reader uses monospaced type.)
>
> 11 aaa 22 bbb 33 ccc
> 22 bbb 33 ccc
> 33 ccc
>
> Opening Mathematica and using !!filedata reproduces exactly same thing:
>
> 11 aaa 22 bbb 33 ccc
> 22 bbb 33 ccc
> 33 ccc
>
> Trying to follow this with
>
> fileDataAsViewed = !!fildata
>
> or
>
> fileDataAsViewed = %
>
> doesn't work, however.
>
> Using the Mathematica expression
>
> Import["datafile", "Table",
> ConversionOptions->{"TableSeparators"->{{"\r","\n"},{"\t"}}}]
>
> gives:
>
> 11 aaa 22 bbb 33 ccc
> 22 bbb 33 ccc
> 33 ccc
>
> Recreating the text file with a space between the tabs in the empty
> slots and applying the same Import[ ] expression, however, gives the
> "right" answer:
>
> 11 aaa 22 bbb 33 ccc
> 22 bbb 33 ccc
> 33 ccc
>
> I suppose this is not exactly unexpected. The problem is, the app that
> creates the (much larger) tab-delimited filedata text file I really want
> to load into a Mathematica Table creates numerous blank cells, i.e.
> adjacent and unspaced tabs. I guess I'll just have to go at it with a
> smart text editor and separate adjacent tabs before trying to load it.
>