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
lister

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?

Thanks


My System SpecsSystem Spec
.
01 Sep 2011   #2
carwiz

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
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
File and Folder - Add "Hide" and "Unhide" to Context Menu
How to Add "Hide" and "Unhide" to File and Folder Context Menu in Vista, Windows 7, and Windows 8 This will add Hidden File Attributes and Hidden Folder Attributes to the context menu of files and folders for all users to be able to hide or unhide one or more selected file(s), folder(s), and/or...
Tutorials
"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....
Customization
"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 03:18.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App