Import txt file

[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?

 

[Guest]

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

 

[Guest]

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

HTH

 

[Greg]

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?