[General Help]
~General Information:~

 ~Start Up~
 You may choose the path to the options file by including it on  the command
 line.  For example: EXTRACT C:\THISDIR

 ~Exporting~
 The Export function will save the data in standard ASCII delimited text
 format.  When you import this data into your spreadsheet/database you'll
 need to choose this format.  The default file extension is .ASC

 ~ESC~
 will always take you back one level (except exiting the program) without
 saving any changes.

 ~Alt-H~
 will usually display a help screen specific to the area you are in.

 ~Tab/Shift-Tab~
 moves you from one section of a dialog box to another.

 ~Cursor Keys~ (includes Page Up/Page Down/Home/End)
 will move any highlight bars, text, or cursor.  In addition if you use the
 Ctrl key with the left or right cursor keys you will move more than one
 space at a time.

 ~Scroll Lock~
 locks the highlight bar to a fixed position moving the text instead of the
 cursor/bar.  It is not used in any of the dialog boxes.

 If You have selected an input file you may use the following keys:

 ~Alt-A~ Define a new area.
 ~Alt-C~ Allows you to edit conditions for an area.
 ~Alt-E~ Use to edit to Add, Delete, or Change a field or area.
 ~Alt-G~ Go to a specific line number.
 ~ALT-M~ Display a pop up menu.
 ~ALT-N~ New Specification File.  (Clears Current Settings)
 ~ALT-O~ Select the order of the exported fields.

 ~DETAIL INFORMATION~

[Include][Area]
[Include][Conditions]
[Include][Edit]
[Include][Menu]
[Include][Order Fields]

[Area]
 ~Alt-A~
 Define a new area.  An area is a section of the report file that can be
 identified as being either a Header, Detail, or Footer.

 Pressing the Alt-A key displays a highlight bar. Move this bar to the
 beginning of the area you want to define and press ~enter~.

 Move the bar up/down to select up to 10 lines that represent the area you
 are defining and press ~enter~.  Note: you can press ~Alt-S~ to switch the
 anchor point.

 A dialog box will appear will the following sections:

   ~NAME:~

     Enter up to 25 characters to represent this area.

   ~TYPE:~

     Header - Headers are usually sections that contain information that
              precedes multiple detail, header, or footer lines.  In other
              words, each detail, (sub)header, or footer line that follows
              this header "belongs" to this header.  One to Many.

     Detail - Detail lines are the lines that usually contain the detail data
              and therefore are usually one to two lines high.  Each
              individual "detail" line on an invoice would be an example.
              If you are going to choose only one "TYPE" choose this one.
              One to One.

     Footer - Footers are opposite of headers.  Detail, header, or (sub)footer
              lines that precede this footer have this footer appended.
              Many to One.

 Press ~enter~ to accept your choice.  You then move on to defining the
 individual fields.

[Include][Fields]
[Conditions]
 ~Alt-C~ Allows you to edit conditions for an area.  Press Alt-C to display
 a dialog box of available areas.  Select the area by highlighting it and
 pressing ~enter~.  Note: The Fields list will be blank since fields don't
 apply.

 After selecting the area another dialog box is displayed showing the current
 conditions defined.

 ~To add a new condition~ simply type in the condition on the top line.  If
 you don't know the field name press ~Alt-L~ while the cursor is located
 in the first box to display a list of fields.

 The second box is the comparison type.  It can be =, >=, <=, =>, =<,
 >, <, or <>.  Notice that <> is the same as saying not equal.

 The third box holds the compare value.  It's max length is the same as the
 length of the defined field or the box itself.  Note that if a fields
 attribute is "Time/Date" then a blank and a 0 are different whereas with
 numeric they are the same.

 The forth and last box is the connector type.  It can be AND, OR, &, or
 |.  To see how they are used to connect comparisons, heres an example:

  FA                       =   1                                    AND
  FB                       =   1                                    AND

  evaluates to: FA=1 AND FB=1

  FA                       =   1                                    OR
  FB                       =   1                                    AND

  evaluates to: FA=1 OR FB=1

  FA                       =   1                                    AND
  FB                       =   1                                    OR
  FC                       =   1                                    AND

  evaluates to: (FA=1 AND FB=1) OR FC=1

  FA                       =   1                                    AND
  FB                       =   1                                    |
  FC                       =   1                                    AND

  evaluates to: FA=1 AND (FB=1 OR FC=1)

  FA                       =   1                                    AND
  FB                       =   1                                    AND
  FC                       =   1                                    OR
  FD                       =   1                                    AND
  FE                       =   1                                    AND

  evaluates to: ((FA=1 AND FB=1 AND FC=1) OR FD=1) AND FE=1

  FB                       =   1                                    AND
  FC                       =   1                                    OR
  FD                       =   1                                    &
  FE                       =   1                                    AND

  evaluates to: ((FB=1 AND FC=1) OR (FD=1 AND FE=1)

  FA                       =   1                                    AND
  FB                       =   1                                    AND
  FC                       =   1                                    |
  FD                       =   1                                    AND
  FE                       =   1                                    AND

  evaluates to: FA=1 AND FB=1 AND (FC=1 OR FD=1) AND FE=1

  FA                       =   1                                    OR
  FB                       =   1                                    OR
  FC                       =   1                                    &
  FD                       =   1                                    OR
  FE                       =   1                                    OR

  evaluates to: FA=1 OR FB=1 OR (FC=1 AND FD=1) OR FE=1

  FA                       =   1                                    OR
  FB                       =   1                                    OR
  FC                       =   1                                    AND
  FD                       =   1                                    OR
  FE                       =   1                                    OR

  evaluates to: ((FA=1 OR FB=1 OR FC=1) AND FD=1) OR FE=1

 ~To modify an existing condition~, Tab to the large box and select the
 condition to modify.  To modify it's contents press enter, make changes and
 press enter again to accept the changes.  To delete it simply press the
 ~Delete~ key.  To move the condition to another location in the box use the
 ~Ctrl~ key along with the up/down cursor keys to drag the condition to the
 new location.

[Edit]
 ~Alt-E~
 Allows you to edit conditions for an area.  Press Alt-E to display a dialog
 box.

[Include][EditSelect]
 To Choose an area or field, highlight it and press enter.

[Include][Fields]
[Fields]
 When you first enter the area to add new fields the block cursor will be
 located in the upper left corner of the area, when you are editing a field
 the cursor will be located on the field and in "paint" mode.  Move the
 cursor to the beginning of the field you want to define and press ~enter~.

 Now "paint" the field by moving the cursor left or right, then press ~enter~
 when done. ~Note:~ you may press ~Alt-S~ to switch the anchor point.  You
 may also move the screen up or down by turning on your scroll lock key.

 A dialog box will appear will the following sections:

   ~NAME:~

     Enter up to 25 characters to represent this field.

   ~TYPE:~

     Condition  - Check this box if you are going to use this field to select
                  conditions for the area.  Note: you will need at least one
                  condition per area as it is used to identify the area.

     Data       - Check this box if this field will be exported.

     Reverse    - This is only used by numeric fields on export.  If this
                  box is checked then the numeric field is multiplied by
                  -1.

     Non Repeat - Some fields may seem like a type of header but is actually 
                  a detail line with some fields that don't repeat on every
                  line.  If this applies to this field, be sure to enable 
                  this option.

     Ident      - Short for Identification.  This is a special type of
                  Condition field that can identify a area even if that
                  area doesn't match all of the conditions.  This enables
                  Extract It to suppress detail lines that belong to a
                  header that did not meet the selection criteria.  Note,
                  all Ident fields are connected with AND when the (special)
                  test is made.  Also note, Footers are kept active even
                  if it applies to the suppressed area; they won't be 
                  exported because the detail lines are suppressed.
                  This option is only used with Header areas.

   ~ATTRIBUTES:~

     Any         - The field is of type string.  Any characters.

     Numeric     - The field is numeric.  Any non-numeric characters are
                   ignored.

     Time/Date   - Use this type for Date and Time fields.
                     Date formats include:
                       MMDDYY, MM/DD/YY, MM.DD.YY, etc...
                       mmmmmm DD, YY, mmmmmm DD YYYY, etc...
                       DD mmmm YY, DD mmmmm YYYY, etc...
                       MMYY, MM/YY, etc...
                       if YY<10 then year 2000 assumed.

                     Time formats include:
                       HHMMSS, HH:MM:SS, etc...
                       HHMM, HH:MM, etc...
                       am is assumed unless p, pm, etc... is found.

     City/St/Zip - Use this type for Address Lines.  This causes the field to
                   be exported as multiple fields (3).  You can also use the
                   zip as a condition.  If you enter a condition as a number
                   the zip field will be used otherwise it will be treated
                   as a normal string field.  Note: Foreign zips are not
                   supported.

     Name        - Use this type for Names.  This will cause the field to be
                   exported as multiple fields (4), consisting of Sir Name,
                   First Name, Middle Name, Last Name.  If the last name 
                   contains spaces, part of that name will be included with 
                   the middle name.

 Press ~enter~ to accept your input.  It returns you the area ready to define
 another field.  Press ~ESC~ when you want to stop.

[AreaFieldSelection]
 This Dialog Box is used to select either an Area or Field.  If the Field box
 is empty then you can only select an area, likewise, if the Area box is
 empty then you can only select a field.

[Include][EditSelect]
[EditSelect]
 When you choose the option to edit an area or field the Area box will be
 filled with all the area names available and the field box will contain the
 field names of all fields in the currently selected area.

 Depending in which box you are in you can press either the ~INS~ or ~DEL~
 key to add or delete an area or field respectively.

[Menu]
 ~Alt-M~ Display a pop up menu.  The menu has the following options:

   ~Select Input File:~

      Use this option to select the ASCII text file/report you want to
      extract the data from.

   ~Select Specification File:~

      The Spec file is the file you saved which contains the Areas, Fields,
      and Conditions you previously defined.

   ~Save Specification File:~

      Save the defined Areas, Fields, and Conditions.

   ~Export Data Fields:~

      This saves the extracted data to a file in standard ASCII delimited
      text format.  To set the order of fields use ~ALT-O~.

   ~Options:~

      Allows you to choose your own colors and other options.

   ~Quit:~

       Removes the pop up menu.

[InsideOptions]
  ~Export Zip As String~
  Normally the zip is saved as a nine number numeric field, this options
  allows you to have the zip output as a string.

  ~Export Time/Date as Numeric~
  Normally Time and Date fields are output as a string.  This option allows
  you to have the Time and Date fields saved as numeric.  Dates are saved
  as YYYYMMDD and Time as XXXXXX.

  ~Suppress Repeating Headers~ and ~Suppress Repeating Footers~
  If you exporting the data to be imported into a spreadsheet then you
  probably don't want the header and footer information repeated on every
  line.  This options allows you do just that, but if you're exporting
  for a database then both of these options MUST be OFF (not checked).
  Note: Footers will only be suppressed until that footer is again used.

  ~Export Field Names~
  If enabled, this option will output the field names of the first data
  record that will be exported.  In other words the field names become
  the first record and will only contain the field names that compose the
  first ~data~ record.

  ~Export Headers w/o Detail~
  Usually if there are no detail records no records are exported.  If
  you would like to export a "short" record with header/footer information
  only, then enable this option.  Usually you would use this when exporting
  for a spreadsheet rather then a database.  Note if the first record output
  does not have any detail fields and ~Export Field Names~ is enabled then
  the field names will be missing for the detail fields.

  ~Colors~
  Choose which color you want to change and press ~TAB~.

[Order Fields]
 ~ALT-O~
 Order Fields.  This option allows you to choose the order the fields are
 exported within each of the Areas.  To change the order, first highlight
 the Area then press tab to move to the Field box.  Then highlight the
 field you want to move and "drag" it to where you want it by holding down
 the CTRL key while moving the up and down arrows.

 Although this option allows you to choose the order of the fields within
 each Area, Header fields will always precede Detail and Footer fields and
 Footer fields will always be last.

[]
