Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

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

01 Sep 2011   #1

Windows 7 Panasonic CF F9 (used to have CF F8)
"" 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?


My System SpecsSystem Spec
01 Sep 2011   #2

Windows 7 Pro-x64

Quote   Quote: Originally Posted by lister View Post
...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 System SpecsSystem Spec

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

Thread Tools

Similar help and support threads
Thread Forum
"Static sound" problem; out of ideas to solve/fix
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....
Sound & Audio
Default "Browse for file" location in web browser "choose file" box
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....
"No audio output" after laptop repair - ideas?
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. ...
Sound & Audio
Win7 "workstation" to WinXP "server" file copy FAIL
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...
Network & Sharing

Our Sites

Site Links

About Us

Find 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 05:20.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App