Import txt file

G

Greg

Can you please assist.

I have a file that has tabs, CR, and LF, so I have delimeted the Txt
file by using a ^. eg a field can be any combination of ^text
.....CR....TAB....^

I wish to import the txt without the tabs, CR and LF. The file
contains about 24 columns, by about 200 rows.

What are my bext options?
 
J

Jim Thomlinson

I'll start wiht the obvious just to find out if this requires something more
inticate. Copy the data into Excel and use Data -> Text To Columns...

HTH
 
J

Jim Thomlinson

To avoid that whole pesky exercise you can also use data -> getdata -> Text
File

HTH
 
G

Greg

=?Utf-8?B?SmltIFRob21saW5zb24=?= said:
To avoid that whole pesky exercise you can also use data -> getdata -> Text
File

HTH

Thank you HTH

The issue is I wish to prevent the CR LF TAB being imported from
fields of text - sentences. It may be easier to clean the file in
word to remove, or replace all the non text characters, or to catch
the non text at the time of import, rather than cleaning up after the
importation.

I tried to find data -> getdata -> Text using xl 2002 however, I found
data -> Import External Data -> Import Data. All the data is placed
in one column and I used Text to columns to delimeter the column.

This works, is this still my best option?

If it is, during the Text to Columns process, is there a way to make
all the columns string rather than general?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top