Subject: | |
From: | |
Reply To: | |
Date: | Fri, 5 Sep 1997 17:24:08 GMT |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Stephen Pennine ([log in to unmask]) wrote:
: BA is adding a new area code to certain exchanges in Massachusetts and we
: need to update all our databases that carry phone numbers, to correct
: the currently loaded (old) area codes.
: Can anyone provide guidance on any utilities/techniques that will
: search a database, scanning all the fields in all the datasets within
: it, looking for a certain value? Preferably a wildcard such as
: @phone@ (a caseless search) that would cover instances of fieldnames
: such as 'phone', 'telephone', 'tele-phone', 'phone-no', 'phone#', etc,
: which I've seen searching source libraries.
Query can do most of what you desire. The FORM command will show all the field
names in a database and the associated sets. The FIND command with a MATCH
operator
can be used on character items to find those fields that may need to be
updated.
Just redirect the FORM output to a disc file, search that file with your
favorite
search tool. <PLUG ON> HPSEARCH is my favorite (but then I support it) <PLUG
OFF>
Sorry there is no easy way to search ALL fields on a database for a value in
QUERY.
--
James Overman HP SSG R&D Roseville, CA
|
|
|