Cut'n'Pasting data

  • Thread starter Thread starter Robin Clay
  • Start date Start date
R

Robin Clay

Greetings !

I have a CSV data file wot looks something like this -

"1529.17698720957","133.597550559965"
"1685.21901149326","132.817184396522"
"1900.00000000000","130.300887834893"
"2193.34485206410","121.730777157435"
"2363.17295960769","114.937652855693"
"2523.01169878763","108.544103288496"
"3240.77088467590","87.805735336415"
"3590.69860622591","81.680775462264"
"4229.19543928027","78.487652800160"

This data is extracted by Excel with

Input #1, myLine

and then parsed.

If I generate some replacement data in another Excel
spreadsheet, it appears in the cells like this :

1+901.0000 +131.3009
2+192.3449 +122.7308
2+363.1730 +113.9377
2+524.0117 +104.5441

with cell borders.

What I do at the moment is - wait for it ! -

I copy those cell values into another location, with
inverted commas in a column before the first data column
and in a column after the last data column, with the data
columns separated by a column containing "," (quote comma
quote), so that it looks like the first sample above.

I then select those cells, and "Paste Special" into
WordPad.

I select that data again, and copy into WORD, where I do a
Find'n'Replace to eliminate the Tabs. I also change the
font, as otherwise the data runs over onto the next line,
throwing in line breaks.

I then select that data once more, and paste it into the
correct location in the data file, using NotePad.

Now, is that TEDIOUS, or WHAT ????

These four programs are ALL Microsoft products, and yet....

Help !
 
Hi

Have you tried to use Data menu in Excel and Import Text
file.

If your file has been pasted into Wordpad - the file is
tnem comma delimited and can be brought into Excel using
the Text Import Wizard.

Follow the steps from the Data - Get External Data menu
and see if that works?

Ann
 
Thank you, Ann and Don, for your responses.

I'm afraid that I have not made myself clear. The data
file is some 60 lines in length, but I only want to
replace about five of them.

I suppose I COULD load up the entire file into Excel,
paste in what I want and then re-save as a CSV file ?

That just might be quicker than what I have been doing...

Would that eliminate the Tabs, I wonder...
 
I wrote, 7/29/2003 6:52:26 AM
-----Original Message-----
The data file is some 60 lines in length,
but I only want to
replace about five of them.
Click to expand...

Erm... 60 PAGES ! About 1200 lines...
I suppose I COULD load up the entire file into Excel,
paste in what I want and then re-save as a CSV file ?
That just might be quicker than what I have been doing...
Click to expand...

I tried that - it was a DISASTER.

No quotes, and when I inserted them, it made them Hi-
ASCII....

What a PAIN !!!
 
I don't quite understand the situation, but if you get the data into excel, you
could use Earl Kiosterud's Text Write program:

It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Earl has a bunch of options (including, IIRC, wrapping each cell in double
quotes)

Or maybe write your own:
Chip Pearson has some nice get-started code at:
http://www.cpearson.com/excel/imptext.htm
 
Back
Top