A problem with downloading text file into Excel

[dyana]

I tried to download a text file into Excel and I had a problem.

There are rows that have a "*" in front of the row data of the text file. The rows that have the "*" are not able to be parsed upon opening the file in Excel. This results in my not importing many rows of data that I need.

How can I get around this.

Dyana

 

[euskadi]

How are you bringing the data into Excel? I create a simple text file with a few lines beginning with "*" and I opened the files with no issues.

 

[dyana]

That is an interesting question. I don't know how the "*" in front of only some of the rows is being created. I don't even think that MIS know why. I guess that I should try to have MIS fix it, if there is not way to alter it from an importing within Excel perspective.

Thanks for the input,
Dyana

 

[acron]

If the "*" character has no significance, you could tru opening the file in WordPad and doing a Search & Replace, leaving the replace box blank.

It is difficult to figure out they are causing a problem.

A.C.