myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

CSV import treatment of text Options · View
kn2
Posted: Friday, November 09, 2007 7:23:31 PM
Rank: Newbie
Groups: Member

Joined: 11/9/2007
Posts: 1
Points: 0
Location: US
The CSV import tool is based on a non-conventional interpretation of the CSV file format. Although there's no formal standard for CSV, it's been in use for a couple of decades by everything from spreadsheets to database sofwtare.

Common practice is to use " to delimit text values (which enables a text value to include commas). Numeric values are not delimited by ".

So a CSV file might have

IDNumber FirstName LastName Age Email Comment

1,"John","Smith",28,"john@mylitleadmin.com","Works well"
2,"Jessica","Alba",24,"jessica@mylittleadmin.com","Yo, good job"
3,"George","Bush",61,"arbusto@whitehouse.gov","Cool tool!"

The CSV import wizard will successfuly import such a file, but it includes the " delimiter for data stored in VARCHAR columns. In other words, the last names in the table should be Smith, Alba and Bush, but the CSV import tool stores "Smith", "Alba" and "Bush". Note that specifying ," as the delimiter would result in column values such as Smith".

Will there be an update that permits storing imported text without the quote delimiters?
JX
Posted: Friday, February 08, 2008 11:54:05 PM
Rank: Newbie
Groups: Member

Joined: 2/8/2008
Posts: 4
Points: 0
Yes, same problem here, is there an update for that?
elian
Posted: Saturday, February 09, 2008 9:31:35 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
No there is no update available for this query yet.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.