Path: utzoo!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!pacific.mps.ohio-state.edu!linac!att!pacbell.com!ames!dftsrv!chris From: chris@endgame.gsfc.nasa.gov (Chris Shenton) Newsgroups: comp.sys.mac.apps Subject: Importing text data into FoxBASE? Message-ID: Date: 14 Mar 91 21:43:47 GMT Sender: news@dftsrv.gsfc.nasa.gov Organization: none Lines: 33 I was going to use Hype-Card [sic], but ran into limitations, so now FoxBASE seems the way to go. I need some advice from people who have used it, as I'm just getting into the manuals now. I've got a text file of an old database which is basically a mailing list with entries like the following. I want to load it into records in Fox with fields as shown below: TEXT DATABASE DESIRED FOX FIELDS George Bush FirstName, LastName 1600 Pennsylvania Ave, NW StreetAddress Washington, DC 20001 City, State, Zip 202-666-1212 HomePhone 202-555-1212 WorkPhone $0.50 DonationAmount Andy Warhol 16 Chelsea St New York, NY 12345 ... Currently, the file is a MS-WORD doc saved as plain text. Lines are terminated by RETURN (I think) and a blank line separates records. I could probably massage this so that lines are separated by TABs, records by RETURNS -- would this help? Any suggestions on how I can do this encoding? I don't want to have to type it in... Thanks! -- chris@asylum.gsfc.nasa.gov ...!uunet!asylum.gsfc.nasa.gov!chris