Path: utzoo!censor!geac!jtsv16!uunet!cs.utexas.edu!csd4.csd.uwm.edu!mailrus!iuvax!rutgers!cmcl2!dasys1!parsnips From: parsnips@dasys1.UUCP (David Parsons) Newsgroups: comp.unix.questions Subject: Shell Database Management (?) Keywords: shell database Message-ID: <10596@dasys1.UUCP> Date: 31 Aug 89 01:14:35 GMT Distribution: usa Organization: The Big Electric Cat Lines: 26 I would like to use a Bourne shell script to extract records from a simple database of fixed-length fields terminated with a new-line character. I've tried R'ing TFM to no avail. The problem... the database consists of addresses... positions 99 and 100 in each record contain a two-position abbreviation for the state. It's easy to get cut to read those two characters, and grep to identify the state I want to extract, but how the ^#$&! do you then copy the ENTIRE record thus identified to another file??? Using grep alone is no good because the abbreviation appears in various other places in the record... I KNOW there's a simple answer to this, but it's making me crazy (we gotta buy a database, I know, I know...) Any help would be appreciated! Dave David Parsons ..cmcl2!{ccnysci,cucard,hombre}!dasys1!parsnips -- David Parsons Big Electric Cat Public UNIX ..!cmcl2!{ccnysci,cucard,hombre}!dasys1!parsnips