sager29 Posted May 4, 2010 Share Posted May 4, 2010 Hi, I'm using MySQL 5.0 and am importing a CSV spreadsheet that contains URLs in each line. I'm also using phpMyAdmin. The field containing the URL is varchar. The import goes fine except that my URLs go from this: http://www.greenwichworkshop.com/images/gallery/images/prints/Bean/AB00052lg.jpg to this: http:\www.greenwichworkshop.com/images/gallery/images/prints/Bean/AB00052lg.jpg I would just erase the "http://" part in the spreadsheet but its thousands of lines long, and even with a find and replace command, it just adds another step to my process which will have to be re-uploaded every month. Any suggestions on how I can keep the "http://"? Thank you in advance Link to comment https://forums.phpfreaks.com/topic/200718-importing-a-csv-with-urls/ Share on other sites More sharing options...
fenway Posted May 4, 2010 Share Posted May 4, 2010 Then your import is busted. Link to comment https://forums.phpfreaks.com/topic/200718-importing-a-csv-with-urls/#findComment-1053292 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.