"" stripped from .csv file for MySQL - any ideas why?


  1. lister
    Posts : 259
    Windows 7 Panasonic CF F9 (used to have CF F8)
       New #1

    "" stripped from .csv file for MySQL - any ideas why?


    I have a database that uses .csv files to upload. For some reason when I download the .csv file and open it in notepad the "" are there for each value - therefore the SQL can read each value and all is well.

    HOWEVER, when I save the .csv as a .csv correctly, it strips all the "" so the database cant read the file anymore - any idea why this is?

    Thanks
      My Computer
    Quote Quote

  3. carwiz
    Posts : 4,161
    Windows 7 Pro-x64
       New #2

    lister said:
    ...HOWEVER, when I save the .csv as a .csv correctly, ...
    What EXACTLY do you mean by this?

    It isn't Notepad that's stripping the characters. It doesn't care--It's just two characters. What are you using to save the csv file?
      My Computer
    Quote Quote

 

  Related Discussions
Hi guys, this has been something I've trying to solve for a little while and frankly I'm about ready to admit defeat. I must admit to reading a few threads on here that seem to pertain to similar issues, but as of yet I've been unable to solve this issue despite days and days of troubleshooting....
Hi, how can I change this? Some background - this may not be the issue I need to solve at the end of the day: I believe the location is causing crashes, since I blew up lots of Library registry values (in an attempt to remove them from the OS), and I think it defaults to the library page....
I am sorry for posting incomplete information, but I'm trying to help my daughter who is away at college troubleshoot something. She has a Sony VAIO laptop running Windows 7. A couple weeks ago the CPU fan broke, and the computer started shutting down after short times due to thermal issues. ...
This is driving me bonkers and I have almost no hair left. I really hope someone can help. When I attempt to copy or move a file or folder from my Win7 box to my WinXP (SP3) media server, the operation nearly always fails. Take, for example, my trying to copy the VLC Media Player folder (704...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 20:17.
Find Us