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?
|
Rank: Newbie Groups: Member
Joined: 2/8/2008 Posts: 4 Points: 0
|
Yes, same problem here, is there an update for that?
|
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.
|