Importing text data into FoxBASE?

Article View: comp.sys.mac.apps

Article #7771

#7771

From: Chris Shenton
Date: Thu, 14 Mar 1991 21:43

33 lines
1524 bytes

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

Technical Details

Message-ID: <CHRIS.91Mar14164347@endgame.gsfc.nasa.gov>

Path:

arc1-ca.pugleaf.net!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

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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: <CHRIS.91Mar14164347@endgame.gsfc.nasa.gov>
Date: 14 Mar 91 21:43:47 GMT
Sender: news@dftsrv.gsfc.nasa.gov
Organization: none
Lines: 33