glennn.php Posted June 22, 2010 Share Posted June 22, 2010 i have fields such as this in a csv file: 6" X 4" Document Placard but when they're imported into my db, they end up as "6"" X 4"" Document Placard" i can't discover why this is happening not how to prevent it. anyone? i HAVE adjusted the "fields terminated by" and "fields enclosed by" fields in the import, with no change... help? thanks much Quote Link to comment Share on other sites More sharing options...
fenway Posted June 23, 2010 Share Posted June 23, 2010 Adjusted how? Quote Link to comment Share on other sites More sharing options...
glennn.php Posted June 23, 2010 Author Share Posted June 23, 2010 Fields Terminated by , Fields enclosed by 'EMPTY' (default is " - i left this field blank) Fields escaped by \ thanks for your help. GN Quote Link to comment Share on other sites More sharing options...
fenway Posted June 24, 2010 Share Posted June 24, 2010 What produced that CSV file? it looks like your double-quotes are being escaped by double-quotes -- easy enough to fix with a good text editor. Quote Link to comment Share on other sites More sharing options...
glennn.php Posted June 24, 2010 Author Share Posted June 24, 2010 MS Excel. it's not being done in MS Excel - they're correct in the spreadsheet. only after the data is imported into mysql are the quotes added... Quote Link to comment Share on other sites More sharing options...
fenway Posted June 24, 2010 Share Posted June 24, 2010 That's a known issue with excel. As I mentioned earlier, just clean it up with a regex. Quote Link to comment Share on other sites More sharing options...
glennn.php Posted June 24, 2010 Author Share Posted June 24, 2010 ok, i appreciate it - but what i don't get is that the data is WITHOUT the quotes IN Excel - it happens during the import INTO the database - so how is it that Excel is causing it? even after the .csv import, the data in the .csv file is fine (WITHOUT the quotes). only the data in mysql is affected... when you say "clean it up with regexp", you mean to clean the mysql data with regexp??? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 24, 2010 Share Posted June 24, 2010 Oh -- that is strange. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.