Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

Re: Import CSV can not understand string correctly

• To: mathgroup at smc.vnet.net
• Subject: [mg131725] Re: Import CSV can not understand string correctly
• From: Itai Seggev <itais at wolfram.com>
• Date: Tue, 24 Sep 2013 04:16:14 -0400 (EDT)
• Delivered-to: l-mathgroup@mail-archive0.wolfram.com
• Delivered-to: l-mathgroup@wolfram.com
• Delivered-to: mathgroup-outx@smc.vnet.net
• Delivered-to: mathgroup-newsendx@smc.vnet.net
• References: <20130921083610.2A1EC6A34@smc.vnet.net>

On Sat, Sep 21, 2013 at 04:36:10AM -0400, Joug Raw wrote:
> 
> In my CSV file, I have string fields like 3D22 or so.
> While I imported the CSV file in mathemtaica, the 3D22 string was converted
> to number 3x10^22.
> 
> How dose this happened??? How can I avoid this kind of transformation and
> keep my original string when Import a CSV file?

You can set the option "Numeric"->False which will keep everything as
strings.  Numbers will need to be explicitly converter to them, though.

--
Itai Seggev
Mathematica Algorithms R&D
217-398-0700 

• References:
  • Import CSV can not understand string correctly
    • From: Joug Raw <jougraw@gmail.com>