Copy & Paste MS Excel to Notepad - stop ' ' around text???

Forums › Microsoft Windows › Copy & Paste MS Excel to Notepad - stop " " around text???

stevonz

397 posts

Ultimate Geek

Trusted

Topic # 14857 24-Jul-2007 09:44

Hi I am ceating text files to to use in various upload tools. The process I use is to select the cells required (which are in the coreect sequence for my data load) and copy & paste these into Notepad to save as .txt file.

A problem has occurred that has added "quotation marks" around cells that contain text values when I paste this into the text file. When I uplaod the file the " " are also included, but definitely not wanted.

Any ideas on how I can overcome this frustration?

Cheers, Stevo

NokiaRocks

362 posts

Ultimate Geek

Trusted

Reply # 79391 24-Jul-2007 09:48

I used a find and replace when i did it for dumping data into an mysql database.
In notepad go edit, replace.
In the Find what put in a "
Leave the replace with: blank
Then do a replace all

rwales

122 posts

Master Geek

Reply # 79392 24-Jul-2007 09:50

Weird. I'm using Excel 2003 & it doesn't do it for me (using Ctrl+C/Ctrl+V, it just pastes the values without quotes). I tried on cells formatted as 'Normal' and 'Text'.

What version are you using & what formatting is applied to the cells?

rwales

122 posts

Master Geek

Reply # 79394 24-Jul-2007 09:52

NokiaRocks: I used a find and replace when i did it for dumping data into an mysql database.

Find/Replaces can be very risky with large chunks of loosely typed data. Unless you're sure the data doesn't contain quotes or quotes have been converted to entity references etc.

chiefie

I iz your trusted friend
5811 posts

Uber Geek
+1 received by user: 140

Mod Emeritus

Trusted

Lifetime subscriber

Reply # 79397 24-Jul-2007 10:01

why don't you just export or save-as "txt"?

Internet is my backyard...

«Geekzone blog: Tech 'n Chips Takeaway» «Personal blog: And then...»

Please read the Geekzone's FUG

stevonz

397 posts

Ultimate Geek

Trusted

Reply # 79399 24-Jul-2007 10:04

NokiaRocks: I used a find and replace when i did it for dumping data into an mysql database.
In notepad go edit, replace.
In the Find what put in a "
Leave the replace with: blank
Then do a replace all

Sweet! That worked a treat!

I did look for this myself as I use this in MS word & Excel

RWales: What version are you using & what formatting is applied to the cells?

Excel 2000 - General formatting

Thanks again.