Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


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


397 posts

Ultimate Geek

Trusted

# 14857 24-Jul-2007 09:44
Send private message

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

Create new topic
362 posts

Ultimate Geek

Trusted

  # 79391 24-Jul-2007 09:48
Send private message

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

122 posts

Master Geek


  # 79392 24-Jul-2007 09:50
Send private message

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?

 
 
 
 


122 posts

Master Geek


  # 79394 24-Jul-2007 09:52
Send private message

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.

I iz your trusted friend
5846 posts

Uber Geek

Mod Emeritus
Trusted
Lifetime subscriber

  # 79397 24-Jul-2007 10:01
Send private message

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

 



397 posts

Ultimate Geek

Trusted

  # 79399 24-Jul-2007 10:04
Send private message

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.

Create new topic



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Major Japanese retailer partners with smart New Zealand technology IMAGR
Posted 14-Oct-2019 10:29

Ola pioneers one-time passcode feature to fight rideshare fraud
Posted 14-Oct-2019 10:24

Spark Sport new home of NZC matches from 2020
Posted 10-Oct-2019 09:59

Meet Nola, Noel Leeming's new digital employee
Posted 4-Oct-2019 08:07

Registrations for Sprout Accelerator open for 2020 season
Posted 4-Oct-2019 08:02

Teletrac Navman welcomes AI tech leader Jens Meggers as new President
Posted 4-Oct-2019 07:41

Vodafone makes voice of 4G (VoLTE) official
Posted 4-Oct-2019 07:36

2degrees Reaches Milestone of 100,000 Broadband Customers
Posted 1-Oct-2019 09:17

Nokia 1 Plus available in New Zealand from 2nd October
Posted 30-Sep-2019 17:46

Ola integrates Apple Pay as payment method in New Zealand
Posted 25-Sep-2019 09:51

Facebook Portal to land in New Zealand
Posted 19-Sep-2019 18:35

Amazon Studios announces New Zealand as location for its upcoming series based on The Lord of the Rings
Posted 18-Sep-2019 17:24

The Warehouse chooses Elasticsearch service
Posted 18-Sep-2019 13:55

Voyager upgrades core network to 100Gbit
Posted 18-Sep-2019 13:52

Streaming service Acorn TV launches in New Zealand with selection with British shows
Posted 18-Sep-2019 08:55


Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.