Problem:
We want to be able to do a find on a field name for a certain value. For instance, we want to find a street address in a field within many records in a data file. How can this be done?
Resolution:
In order to search for a particular value in a particular field
in the Micro Focus Data File Editor, one needs to take
several steps. This works ONLY if one loads a .STR file then
uses Hex AND if one has clicked in the right hand pane on
the field being searched in the Structure View.
Here are the steps:
- Create a .STR file for your sequential or indexed file
(see Online Help, Index tab, type in 'record layout')
- Open the data file using the Data File Editor then
load the structure file
(File>Data Tools>Load Record Layouts)
- Open the Data File Find and Replace via Search>Data
Tools>Data File Find and Replace
- Click in the right hand pane on the field to be searched
- Enter the search argument in the hex display area
- To search on another field, click on the field in the
right hand pane then click on the 'refresh' button that
looks like this: <-F
There are several attachments to this article.
The attached screen captures show a find when clicking in the
left hand pane and typing in a value or character string.
(See Find1/2.Jpg). And then a click on the field in the right hand
pane using a hex entry (See Find3/4.Jpg). Notice that the
field length changes when a new field is selected (See Find5.Jpg).
The Online Help entries are shown for MFE31 in Help1/2.Jpg.
Attachments:
#EnterpriseDeveloper
#MFDS
