--- TIC-TECH message:
Hello Sean, How are you exporting the data to a text file? Is this a
Follet function. There are a lot of different types of text files and a
number of them have control characters inserted into them, like "soft
carriage returns". I would load the text file into Microsoft Word and see
if any squares, control characters, show up. When you try to read it in
Word, you will probably be given a choice of a lot of converters. If you
find the right one, one that strips out all of the control characters, you
can probably just save the file back under another name and open it in Excel.
Good Luck.
-Wes
wfelty@gte.net
At 02:02 PM 05/14/2001 -0700, you wrote:
>--- TIC-TECH message:
>I am wondering if anyone has any suggestions for how I might do the
>following.
>
>I am trying to import data from a text file into Excel. I want to be able
>to sort on one of the fields in the file.
>
>Specifically I am outputting to a text file a bunch of information off my
>library database - title, author, etc. , about 12 fields in all. Because
>there are so many fields the data gets wrapped around so that a single
>record occupies two lines in the text file. It looks something like this:
>
> THE CAT IN THE HAT GEISEL, THEODORE
>12/30/2000
> 3027699000000231 15.00
>
>When I import this into Excel, (I've tried both fixed and comma delimited)
>each line gets treated as a unique record. What I want is to somehow get
>all this info on one line. Ideally the vendor's (Follett) software would
>give me this option, but it doesn't, and it forces me to choose all 12
>fields, not just the three that I need.
>
>Any suggestions would be much appreciated.
>
>Thank you.
>
>-Sean
>
- End TIC-TECH message. To join, leave, or visit
the message archive, go to Tic-Tech on the Web:
http://fp.seattleschools.org/fpclass/tic-tech/
This archive was generated by hypermail 2b29 : Tue May 15 2001 - 08:08:03 PDT