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 Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/ Share on other sites More sharing options...
fenway Posted June 23, 2010 Share Posted June 23, 2010 Adjusted how? Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1075880 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 Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1076043 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. Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1076386 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... Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1076574 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. Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1076632 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??? Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1076638 Share on other sites More sharing options...
fenway Posted June 24, 2010 Share Posted June 24, 2010 Oh -- that is strange. Link to comment https://forums.phpfreaks.com/topic/205567-phpmyadmin-importing-csv-getting-quotes-around-some-fields/#findComment-1076695 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.