PC Review


Reply
Thread Tools Rate Thread

copy from multicolumn .txt document

 
 
rea
Guest
Posts: n/a
 
      20th Oct 2006
can somebody help me...
i have a .txt wich holds data in 5 or six colums separated with sign
",".
i manage to copy data from .txt wich holds only one column, but i dont
know how to solve this problem.i need to copy only 1 column from .txt
(lets say third) to .xls .
the number of rows is huge.

 
Reply With Quote
 
 
 
 
NickHK
Guest
Posts: n/a
 
      20th Oct 2006
You can either change the extension to .csv and Excel should open it
normally.
Or in Excel, go File>Open and follow the steps.
Either way, you can then copy and work the data in Excel.

NickHK

"rea" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> can somebody help me...
> i have a .txt wich holds data in 5 or six colums separated with sign
> ",".
> i manage to copy data from .txt wich holds only one column, but i dont
> know how to solve this problem.i need to copy only 1 column from .txt
> (lets say third) to .xls .
> the number of rows is huge.
>



 
Reply With Quote
 
rea
Guest
Posts: n/a
 
      20th Oct 2006
it is one solution, but i need to have a code, becuse mz txt is
generated from another program wich recives data from rs232... so it is
a bit complicated,but the point is that i need to code.

 
Reply With Quote
 
rea
Guest
Posts: n/a
 
      20th Oct 2006
it is one solution, but i need to have a code, becuse mz txt is
generated from another program wich recives data from rs232... so it is
a bit complicated,but the point is that i need to code.

 
Reply With Quote
 
NickHK
Guest
Posts: n/a
 
      20th Oct 2006
Well, record the macro of the Open file option and see the code.

As for the rename, use
Name "mz.txt" As "mz.csv"
adding paths as required.

NickHK

"rea" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> it is one solution, but i need to have a code, becuse mz txt is
> generated from another program wich recives data from rs232... so it is
> a bit complicated,but the point is that i need to code.
>



 
Reply With Quote
 
rea
Guest
Posts: n/a
 
      20th Oct 2006
thnx, but it wont solve my problem for good.
because i need to use variables.i am planning to expand the main code,
but i am missing small piece of code wich would put the selector to a
third colmn of .txt
thnx

 
Reply With Quote
 
NickHK
Guest
Posts: n/a
 
      20th Oct 2006
If you can do it manually, you can (normally) generate the code for the
actions.
Show the code you get and explain why it is not the desired result.

NickHK

"rea" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> thnx, but it wont solve my problem for good.
> because i need to use variables.i am planning to expand the main code,
> but i am missing small piece of code wich would put the selector to a
> third colmn of .txt
> thnx
>



 
Reply With Quote
 
=?Utf-8?B?VG9tIE9naWx2eQ==?=
Guest
Posts: n/a
 
      20th Oct 2006
You can also look at this page an perhaps adapt it to your requirements

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy


"rea" wrote:

> thnx, but it wont solve my problem for good.
> because i need to use variables.i am planning to expand the main code,
> but i am missing small piece of code wich would put the selector to a
> third colmn of .txt
> thnx
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy portion of track changed document into new document Track Changes Microsoft Word Document Management 2 12th Nov 2009 04:37 PM
Last page of multicolumn document jjk98 Microsoft Word Document Management 2 25th Aug 2008 09:56 PM
View and copy document content without opening the document hash Windows Vista General Discussion 4 27th Jul 2007 11:55 PM
View and copy document content without opening the document hash Windows Vista Performance 3 23rd Jul 2007 04:43 PM
Copy from Word Document to E-mail Document =?Utf-8?B?Q2ltYXJyb24gS2lk?= Microsoft Outlook Discussion 1 5th Jan 2005 10:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:28 AM.