?_FÿÿÿÿÖ-6-l4NÉ' Data Ranger=‹   B0R/&;)z4racters.Cannÿÿ  ÿÿÿÿ|CTXOMAPO|FONTÒ|KWBTREEx|KWDATAZ|KWMAPg|SYSTEM|TOMAP |TOPICu|TTLBTREE§%NgothicPSNcubicPSNlineprinter[Helvetica Navantegarde Nspartan Nmetro Npresentation NAPLNOCRANOCRBXboldPSXemperorPSXmadaleineXzapf humanistXclassicXroman fXroman gXroman hXtimesromanXcenturyXpalantinoXsouvenirXgaramondXcaledoniaXbodiniXuniversity Zscript!ZscriptPS"Zscript c#Zscript d$Zcommercial script%Zpark avenue&Zcoronet'Zscript h(Zgreek)Xkana*Xhebrew˜ÿÿÿÿ ÿÿÿÿ+ +!ÿÿÿÿÿÿÿÿMain Indexèq+èwÀ€€Š R€€‚‚‚‚€€‚‚‚ቂቂቂቂቂቂቂቂቂá‰ÿMAIN TOPIC INDEXThe index lists the help topics available for PROSPECTOR/DATARANGER.To learn how to use help press F1 or choose Using Help for the Help Menu.General InformationGetting Started With ProspectorFile CommandsInterpret CommandsView CommandsEdit CommandsFilter CommandsIntegrity CommandsExport CommandsOptions Commands!è!!!ÿÿÿÿÿÿÿÿ!!!!¨ÿÿÿÿÿÿÿÿ‡H!‡?P€€Š R€‚ቂቂá!‰‚á#‰‚ÿUSING HELPTRADEMARKSUSING THE MOUSEMORE INFO ON THE MOUSE!‡!!|ÿÿÿÿÿÿÿÿ[ä![wÀ€€Š R€‚á%‰‚á'‰‚á)‰‚á+‰‚á-‰‚á/‰‚á1‰‚á3‰‚á5‰‚á7‰‚á9‰‚á;‰‚ÿSESSION IDMAIN WINDOWINPUT RECORD DISPLAYOUTPUT RECORD DISPLAYFIELD CLASSIFICATIONINTERPRETATIONRECORD ISOLATIONVISUAL RECORD SELECTIONINTEGRITY CHECKINGFILTERING RECORDSEXPORTKEY FUNCTIONS![!!Äÿÿÿÿÿÿÿÿ£G!£\Š€€Š R€‚á<‰‚á@‰‚áB‰‚áD‰‚áF‰‚áH‰‚áJ‰‚áL‰‚‚ÿNEWOPEN SAVE SAVE AS IDENTIFYPRINTEXITABOUT!£!!…ÿÿÿÿÿÿÿÿd-!d7@€€Š €‚áN‰‚áP‰‚áR‰‚ÿAUTOMATICINTERPRET'S PHASESMANUAL!d!!Êÿÿÿÿÿÿÿÿ©d!©E\€€Š €‚áT‰‚áV‰‚áX‰‚áZ‰‚á\‰‚ÿLOCATING FIELDSFIELD INFORMATIONFIELD FORMATSRECORD ISOLATIONVISUAL FIELD LOCATING!©!!ÿÿÿÿÿÿÿÿâr!âp²€€Š €‚á^‰‚á`‰‚áb‰‚ád‰‚áf‰‚áh‰‚áj‰‚ál‰‚án‰‚áp‰‚ár‰‚‚ÿCUTJOINANALYZESELECTSELECT ALLNAMING FIELDSRENAMEMOVEDELETEDELETE ALLLITERALS!â!!¯ÿÿÿÿÿÿÿÿ‚C!Ž?P€€Š €‚át‰‚áv‰‚áx‰‚áz‰‚‚ÿDEFINEFILTERING SAMPLEPARTIALz›z INPUT PROCESSINGCLEAR!Ž!!,ÿÿÿÿÿÿÿÿØ~!ØZ†€€Š €‚á|‰‚á~‰‚ဉ‚ႉ‚ᄉ‚ᆉ‚ሉ‚኉‚ÿVALUE TOTALINGSEQUENCE CHECKINGDATE VALIDATIONGORESULTSVALUE TOTALINGSEQUENCE CHECKINGDATE CHECKING3 Ø3)$€€Š Rጀ‰‚ÿPRINT!3!!ÿÿÿÿÿÿÿÿ`/!`14€€Š R€‚ᎉ‚ቂÿGENERAL DESCRIPTIONUSER SPECIFIED FILE!`!!¹ÿÿÿÿÿÿÿÿO!O02€€Š €‚ᑉ‚ᓉ‚ÿTOGGLE HEXTOGGLE INPUTIàOIi¤€€Š Rá•€‰‚á—‰‚ᙉ‚ᛉ‚ቂ៉‚ᡉ‚ᣉ‚᥉‚ᬉ‚‚ÿTOGGLE OUTPUTTOGGLE MULTIPLE RECORDSGO TO RECORDDETERMINING HEADER LENGTHSET HEADER LENGTHADJUST HEADER LENGTHSET RECORD LENGTHADJUST RECORD LENGTHUPDATE PARAMETERSUPDATE INTERPRET PARAMETERS!I!!!ÿÿÿÿÿÿÿÿ!!!!{ÿÿÿÿÿÿÿÿÑ!?P€€Š R€€‚‚‚€€‚€€‚‚‚€€‚ÿUsing The Help SystemGeneralHelp topics are divided into several categories. The 'GENERAL' category explains some of the general features of Prospector. Information about main menu items appears in the order they occur on the menu bar (left to right), with associated drop down categories also in order of occurrence (top to bottom). Information not directly associated with any menu item appears towards the end of the help topicslisting.F1=HelpZ‹%€€Š R€‚‚‚ÿThe Prospector Help System can be called at any time except when you are in a dialog box. Move the mouse to the "F1 = Help" Prospector main menu item and click, or simply press the F1 key. A scroll list of Help topics will appear. Double click on the topic which interests you. (You may also click on the topic you are interested in and either press Enter or click on the Help button.)The help text screen will display a scroll description of the help topic you have chosen. Many descriptions contaÑ á ° in the procedure which will help you through the Prospector operation you have inquired about.¿›‹¿$€€Š R€‚‚ÿYou may consult the help topics which are immediately preceding or following your current topic by clicking on Previous or Next respectively. This allows you to avoid moving between the Topics listing and the help text screens. Alternatively, you may return to the topics list by clicking on the Topics button. Exit from the Help system is performed by clicking the Cancel button or pressing the Esc key.!¿!!!ÿÿÿÿÿÿÿÿ!!!!¥ÿÿÿÿÿÿÿÿ(ó!(5<€€Š R€€‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚ÿTRADEMARKSLotus 123, DIF, and Symphony are trademarks of the Lotus Development Corporation.dBaseIII+ dBaseIV, and Full Impact are trademarks of Ashton-Tate.Ms-DOS and Windows are a trademark of the Microsoft Corporation.IBM, OS/2, and PC-DOS are trademarks of International Business Machine, Inc.SuperCalc is a trademark of Computer Associates International, Inc.Quattro and Quattro Professional are trademarks of Borland International.Macintosh is a trademark of Apple Computers.\.(\..€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚ÿPlanPerfect is a trademark of the WordPerfect Corporation.20/20 is a trademark of Access Technology.Twin Level III is a trademark of Mosaic Software, Inc.Lucid 3-D is a trademark of DacEasy.ProQube is a trademark of FormalSoft.WingZ and Smartware are trademarks of Informix Software, Inc.!\!!!ÿÿÿÿÿÿÿÿ!!!!–ÿÿÿÿÿÿÿÿi0!u9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿUsing the MouseGeneral Instructions for using Prospector indicate actions to be taken which involve using a mouse. When you are instructed to "click" on something, use the left mouse button unless you are explicitly instructed to use the right mouse button.Left and Right Mouse ButtonsIt is possible to switch the function of the left and right mouse buttons. If you are operating w3ith a mouse that has the left and right mouse buttons switched, you will need to interpret the instructions for using the mouse in Prospector accordingly.!u!!!ÿÿÿÿÿÿÿÿ!!!!› ÿÿÿÿÿÿÿÿ`!!`?P€€Š R€€‚‚‚‚‚‚€€‚‚‚‚‚‚€€‚‚ÿMICROSOFT MOUSE This document contains information that supplements the"Microsoft Mouse User's Guide".MICROSOFT MOUSE SOFTWARE NOTESUse of MS-DOS APPEND during Mouse installation:MSETUP may not work properly if you've used the MS-DOS APPEND command. If APPEND is in effect then remove it by typing APPEND; at the DOS command line (include the semicolon).Microsoft Mouse Drivers -- Older Versions:MSETUP will delete any line containing "CPANEL" in the AUTOEXEC.BAT file (unless the line starts with "SET," "PATH," or "REM").M `M-,€€Š R€‚€€‚‚‚‚ÿSingle-drive PCs:If you have a single-drive PC without a hard disk, you will not be able to use the Mouse Setup program (MSETUP) to set up the mouse software.On a single-drive PC, you must install the mouse driver yourself. Copy MOUSE. COM onto the disk you use to start your computer. You can then load the mouse driver manually each time you start your system, by typing "mouse" at the DOS prompt, or you can insert the "mouse" command in your AUTOEXEC.BAT file to load the mouse driver automatically every time the system starts up.ðM+(€€Š R€‚€€‚‚ÿLoading the mouse driver automatically at system startup:MSETUP installs the mouse driver, MOUSE.COM. At your option, it will also modify your AUTOEXEC.BAT file so the mouse driver will load automatically every time you start your system. MSETUP will also insert comments (lines that begin with REM) in your AUTOEXEC.BAT file to illustrate how the mouse utility SETSPEED.EXE can be invoked automatically as well. See your "Microsoft Mouse User's Guide" for a discussion of SETSPEED.EXE.í$+(€€Š R€‚€€‚‚ÿUsing the new Mouse software wit—²Éh Microsoft Windows:To use your new Mouse driver software, including the acceleration characteristics, with Microsoft Windows, replace the MOUSE.DRV file on the backup copy of your Windows Setup disk with the MOUSE.DRV file located on the Utility or Setup disk in your Microsoft Mouse package, make a backup copy of your WIN.INI file and rerun Windows Setup. For more information on installing Microsoft Windows, see the "Microsoft Windows User's Guide."ŽX$Ž6>€€Š R€‚‚‚‚€€‚‚€€‚‚ÿAlthough harmless, CPANEL.COM does not operate correctly under Microsoft Windows.ADDITIONAL INFORMATIONAdditional readme files:Additional information regarding the software included in your Microsoft Mouse package have been included in a readme file. Please check the other diskettes for PBREADME.DOC and MENUREAD.ME respectively.!Ž!!!ÿÿÿÿÿÿÿÿ!!!!dÿÿÿÿÿÿÿÿÛ£!Û8B€€Š R€€‚‚€€‚‚‚€€‚‚ÿThe Prospector Session IDGeneralA complete session in Prospector consists minimally of creating an output record format with the aid of Interpret, View, and Edit menu commands, then transferring input data to an output file through use of the export command. Use of filters and integrity checking is optional during a session.Session ID NameEach session is represented by a unique ID. This is used to uniquely identify a single use of Prospector to transfer specific data from an input file to an output file. This identifier will be restricted to a maximum of 8 alpha-numeric characters which can be used freely to describe the input file and session purpose.0 Û0$€€Š R€‚‚ÿexample:P*0P&€€Š R‘€€ƒ‚ÿ'XYZSALES'Sales Ledger for company XYZbP+(€€Š XR!s€ƒƒ‚ƒ‚ÿ'ABCYEGL'Year-end general ledger for ABC company'LA011590'Lab records from January 15, 1990O$[+(€€Š R€‚€€‚‚ÿSession File Names The Prospector session ID will be used to 'Ž'…#prefix all temporary and permanent files created during a session and also as the default output file prefix. Recovery from an incomplete session will be possible by specifying this identifier on re-entry to Prospector.![!!!ÿÿÿÿÿÿÿÿ!!!!@ ÿÿÿÿÿÿÿÿ“[!“8B€€Š R€€‚‚€€‚‚‚€€‚‚ÿProspector Main WindowGeneral The Prospector main window appears after you have started Prospector. At the top of the screen you will notice a title bar which contains the name "Prospector". After you have chosen an ID for your Prospector session, the session ID will also appear in the title bar.Windows Control Menu BoxIn the far left corner of the title bar is the Windows Control menu box. Clicking on this box will give you the ability to close Prospector, minimize Prospector to an icon, maximize the Prospector window, and move and change the size of the Prospector window.Y%“Y4:€€Š R€‚€€‚‚‚€€‚‚ÿFile BoxThe main menu bar occurs directly underneath the title bar. When you have chosen an input file, the input file name and path will be shown in the upper left corner under the main menu bar.InterpretationAfter you have Interpreted the input file format, Input and Output Record Displays will appear in the main window. The record length of the input file will appear under the input file name in the upper left corner of the Window. The character type of the input file will be shown in the upper right corner of the main window.(ûY4-,€€Š R€‚€€‚‚‚‚ÿInput RecordAbove the Input Record Display on the left side is the record number of the input record currently displayed. On the right side, the total number of records in the file is indicated.The Input Record Display defaults to show the hex representation of each byte in the record above the translated display of the record. The hex display can be toggled off in the Options/Toggle Hex menu item to simplify the view of the input ¾+. )data. Fields are separated by vertical field separator bars.ÿÔ4ÿ+(€€Š R€‚€€‚‚ÿOutput RecordAt the bottom of the main window is the Output Record Display. Field data is displayed here as fields are selected from the input record for transfer. Vertical field separators are used here also. The Output Record Display gives a graphical representation of the output record built from the input data during the export process. The character type of the output file is displayed on the right side of the window above the Output Record Display.!ÿ!!!ÿÿÿÿÿÿÿÿ!!!!¨ÿÿÿÿÿÿÿÿð¾!ð26€€Š R€€‚‚‚€€‚‚‚‚ÿThe Input Record DisplayViewing your InputThe Input Record Display enables the user to recognize the fields required for further processing by graphically presenting the input file data in a format understandable to the user.Input data is translated and formatted where sufficient information is available, such as numeric signs and date separators, eg 11/31/88. The hex representations of each byte of the input record are shown in the Input Record Display. These can be turned off in the display by using the Options/Toggle Hex command. Individual fields are separated by thick vertical bars. Data that cannot be given a definitive format is displayed in the Input Record Display using "@" characters, where each @ represents a byte in the input file. Where these fields exist, the user is required to make a decision on the appropriate format, based upon a list of translated alternatives available by selection of the Edit/Analyze option.>ðJ+(€€Š R€‚€€‚‚ÿView Single/Multiple RecordsThe user has the ability to view more than one record within the input file by vertically scrolling the Input Record Display to the next or previous record via the scroll bar at the far right of the Input Record Display. The Options/Display Multiple Records toggle allows the user the option of seeing five consŒ2|6k2ecutive input records in the Input Record Display at once. Records that extend beyond the capacity of the display screen will be visible by scrolling horizontally in either direction.M"JM+(€€Š R€‚€€‚‚ÿTransferring Fields to the Output RecordFields selected for transfer to the output file will be shaded in the Input Record Display to prevent duplicate selection. The field currently selected for an operation such as View/Information and Edit/Select is highlighted in inverse video.!M!!!ÿÿÿÿÿÿÿÿ!!!!hÿÿÿÿÿÿÿÿ6!6/0€€Š R€€‚‚€€‚‚ÿThe Output Record DisplayViewing the Output RecordThe Output Record Display is a graphical representation of the fields that will be transferred to the output file. The data in the output record display corresponds to the data in the input record display. As input records are scrolled through vertically, the data in the Output Record Display will change accordingly. It is possible to independently scroll the output display horizontally to bring invisible portions of the current output record into view.Õ6,*€€Š R€‚€€‚‚‚ÿEditing the Output RecordFields will be separated by vertical markers similar to the Input Record Display and will appear in the order that they have been selected, new fields always being added to the right end of the output record. It is possible for the user to edit the Output Record Display, reorganizing the physical order of fields, deleting selected fields, or changing the descriptive field name that was provided when the field wasoriginally selected.Ù+(€€Š R€‚€€‚‚ÿIntegrity Checks on OutputThe Output Record Display is used by the Integrity processing to assist selection of fields for testing. When a particular type of integrity test is selected the Output Record Display will be changed to shade all fields except those classified as having a type appropriate to the type of test selec‹<Œ>4:ted. Selection of a shaded field for an integrity test will cause the system to question the classification assigned to that individual field.!!!!ÿÿÿÿÿÿÿÿ!!!!+ÿÿÿÿÿÿÿÿ©x!©14€€Š R€€‚‚‚€€‚‚‚ÿGENERALField ClassificationsProspector gives each field in the input file a class which is one of four types:®ƒ©®+(€€Š XR!ã~€€ƒ‚ÿVALUEA numerical field which is signed and/or has leading zeros. Balances, counts, and prices are typical value class fields.&®&#€€Š R€‚ÿS&,*€€Š XR!ã~€€ƒƒ‚ÿDATEAn unsigned numerical field which has a valid date format such as YYMMDD.&&#€€Š R€‚ÿ½‘&½,*€€Š XR!ã~€€ƒƒ‚ÿIDAn unsigned numerical field which is used as an identifier. Typical ID fields would be account numbers, check numbers, and part numbers.&½&#€€Š R€‚ÿsG&s,*€€Š XR!ã~€€ƒƒ‚ÿTEXTIndicated when the selected field contains alphanumeric data.’ns’$€€Š R€‚‚ÿ These classes are used in the Integrity checking process to specify the type of analysis done on a field.!’!!!ÿÿÿÿÿÿÿÿ!!!![ÿÿÿÿÿÿÿÿ™j!¥/0€€Š R€€‚‚€€‚‚ÿInterpretationAutomatic InterpretationInterpretation is a process within Prospector which can be performed with no user interaction to formulate an understanding of the format of an input file. Interpretation is initiated by selection of the Interpret/Automatic option from the main menu. It will take a sample of data from the input file and apply code breaking techniques to calculate the record length, assess the character type (EBCDIC or ASCII) and numeric representation, separate data into physical fields and classify these fields depending upon the type of data they contain (eg. dates). The Interpretation process provides the translation information that ena E*E Ebles the user to view an image of the input data which is in an understandable format. Knowledge gained by interpretation enables subsequent processes to understand and process the input data. •a¥•4:€€Š R€‚€€‚‚‚€€‚‚ÿFixed Length RecordsThe current version of Interpretation is restricted to files which have logical records which are of a single type and of a fixed length.Manual InterpretationInterpretation also can be done in manual mode. This mode allows the user to enter the input file record length and bypass the Interpretation of field formats. The Input Record Display after Interpret/Manual simply shows the characters in the record with no field boundaries. This leaves all input record field formatting up to the user. This feature is useful when the user wants to define their own field formats.!•!!!ÿÿÿÿÿÿÿÿ!!!!Xÿÿÿÿÿÿÿÿ7ÿ!78B€€Š R€€‚‚€€‚‚‚€€‚‚ÿRecord IsolationFind a Specific RecordRecord isolation allows the user to find a specific record in the input file. The record is found by matching input record data with data the user has about the file, perhaps from a report.Initializing a Record IsolationInitially, the user is requested to supply 2 items of data that together will isolate a unique record in the input file. It is advised that an "identifier" type field (eg. Account Number) and a "value" field that is known to exist as raw data in the input file be supplied. A successful search through the input file will result in the display of the desired record in the Input Record Display. The two fields used for isolation will automatically be selected and appear in the output record.!7!!!ÿÿÿÿÿÿÿÿ!!!!ßÿÿÿÿÿÿÿÿá!02€€Š R€€‚‚‚€€‚‚ÿVisual SelectionEdit using Cut and JoinUsing knowledge of the contents of the input data file, possibly from a printed report, the format of the input file data initialþNOþNly presented by Prospector after the Interpretation phase can be refined. You may wish to split one field into two in the Input Record display using the CUT command. Alternatively, you may wish to combine more than one field into a single field, as with a line of an address, using the JOIN command.ûÐû+(€€Š R€‚€€‚‚ÿAnalyze CommandIf the user is unable to find data that is known to exist in an isolated record, the facility to explore fields that may have more than one format using the ANALYZE option is available. In some instances, Prospector may not be able to initially identify and determine the format of a given field. When this situation occurs, the Input Record Display will show the unknown field as a series of "@@@". Each one of the @'s represents a byte of data stored in the field. This ANALYZE option provides a display of all possible translations of fields displayed in the Input Record Display as @'s. Once the required value is found, it will be displayed in translated form in the Input Record Display.¦{û¦+(€€Š R€‚€€‚‚ÿSelect CommandOnce the Input Record Display accurately reflects the user's understanding of the input data, the SELECT option can be used to choose those fields required for transfer to the output file. Selected fields will be displayed in the Output Record Display in the order selected, and subsequently shaded in the input record display to prevent duplicate selection.!¦!!!ÿÿÿÿÿÿÿÿ!!!!4ÿÿÿÿÿÿÿÿÏ!8B€€Š R€€‚‚€€‚‚‚€€‚‚ÿIntegrity CheckingGeneralIntegrity checks consist of analysis of sequenced ID, date, and value (balance) fields. The Integrity processing is optional, and may be used as many times as required to ensure the integrity of the input file data. Integrity ResultsThe results of Integrity checking are shown on the screen, and can also be printed. A record selection filter can be applied to the records before they þUVþUare processed in Integrity checking.!!!Gÿÿÿÿÿÿÿÿ&!&#€€Š R€‚ÿ!&!!çÿÿÿÿÿÿÿÿ1!114€€Š R€€‚‚€€‚‚‚‚ÿGENERAL - Filtering RecordsWhy Filter? Integrity checking and transfer of records during export to the output file can process all of the input file records or just selected records. Prospector filters can be defined to process records based upon particular field contents or the record's position in the input file. Filtering allows field contents to be compared to the contents of other fields or values. Prospector allows multiple comparisons in a filter to give maximum flexibility. Ö19D€€Š R€‚€€‚‚‚‚‚‚‚‚‚€€‚ÿFiltering ExampleFor example, the following filter: amt paid > 200 AND amt paid <> amt owed only allows records to pass if the value contained in the field "amt paid" was greater than 200 and the value in the field "amt paid" is not equal to the value contained in the field "amt owed". Prospector filtering includes the ability to "sample" records. This consists of allowing every 'nth' record to pass through the filter. Partial Downloads†c†#€€Š R€‚ÿFiltering also gives the user the ability to do partial downloads. This is necessary when processing large tape files. For example, records in positions 1 through 1000 from the input file could be processed during the first Prospector session, then offloaded from the hard drive to create space for processing the remaining records in the input file.!†!!!ÿÿÿÿÿÿÿÿ!!!!ÿÿÿÿÿÿÿÿW!jAT€€Š R€€‚‚€€‚‚‚‚‚€€‚‚‚‚‚‚‚‚‚ÿExport CommandsGeneral The "Export" feature of Prospector allows input filedata to be transferred directly to several differentoutput formats.Supported Formats: User Specified File ASCII CSV dBase DIF SuperCalc Lotus 1-2-3XXXXXXX¢^ ` `!j!!!ÿÿÿÿÿÿÿÿ!!!!ÿÿÿÿÿÿÿÿ$ç!$=L€€Š R€€‚‚€€‚‚‚€‚€‚‚ƒƒƒ‚ÿAccelerator KeysKey CombinationsThe following key combinations can be used as accelerator keys and alternatives to using the mouse for menu selections.Key Function F1HelpO!$O..€€Š XR‘€s€ƒƒƒ‚ƒƒƒ‚ÿF2View/FieldInformation ™O q´€€Š R€ƒƒƒ‚ƒƒƒ‚ƒƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒƒ‚ƒƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚ÿF3Edit/CutF4Edit/JoinF5Edit/AnalyzeF6Edit/SelectCTL S Edit/Select AllInput FieldsF7Edit/RenameF8Edit/MoveF9Edit/DeleteCTL U Edit/Delete AllOutput FieldsCTL F3View/RecordIsolationCTL F7Integrity/ValueTotallingCTL F8Integrity/SequenceCheckingCTL F9Integrity/DateValidationALT F4Control/CloseALT F5Control/RestoreALT F7Control/MoveÔ G`€€Š R€ƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ÿALT F8Control/SizeALT F9Control/MinimizeALT F10Control/MaximizeCTL H Options/ToggleHexCTL I Options/ToggleInput TypeCTL O Options/ToggleOutput TypeCTL G Options/GotoRecordq@q14€€Š XR±S~€ƒƒ‚ƒƒƒ‚ƒƒƒ‚ÿCTL D Options/ToggleSingle & MultipleRecord DisplayÜžqÜ>N€€Š R€ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ƒƒƒ‚ÿALT L Options/SetHeader LengthCTL L Options/AdjustHeader LengthALT R Options/SetRecord LengthCTL R Options/AdjustRecord Length!Ü!!¾ÿÿÿÿÿÿÿÿ a!¸?P€€Š R€€‚‚€‚€€‚‚‚€€‚‚ƒ‚‚ÿFILE/NEW SESSION Starting a SessionEach time you use Prospector/Data Ranger to interpret and transfer input data is referred to as a session. When you start a new session, you must provide a name which uniquely identifies the session and the files created by the session.To Start a New Session1.Choose the File/New Session menu item.XXXXXXXXXXXXTf h3f.¸.("€€Š XR‘€s€ƒ‚ÿ2.Type a unique ID for this session. This ID will be used to prefix all files created during the session. The files will be created in the current directory as shown at the foot of the dialog box. This directory cannot be changed without exiting Prospector.&.&#€€Š R€‚ÿsK&s("€€Š XR‘€s€ƒ‚ÿ3.Exit from the dialog box by pressing Enter or clicking the OK button.lFsl&€€Š R€‚‚‚‚ÿIf the session ID exists, an additional dialog box is displayed which asks you to confirm whether you wish to overwrite existing files.If you answer "Yes" then all existing files held under this session ID will be overwritten by the current use of Prospector. If you answer "No" you will be returned to the New Session dialog box where you should enter a session ID that has not been used previously. The session ID is displayed in the Prospector title bar after it has been accepted. The session ID can be changed at any time by selecting the File/Save Session As command.²}l²5<€€Š R€‚€€‚‚€€‚‚‚‚ÿNote: A session ID that exceeds 8 characters in length will be truncated to 8 in accordance with the DOS file naming rules.Choosing the Input FileAfter the index file is successfully located or is created for the first time, the "Select File" dialog box appears showing a list of all files on the tape or diskette. Select the required file and click the "Ok" button.!²!!!ÿÿÿÿÿÿÿÿ!!!!|ÿÿÿÿÿÿÿÿ'î!39D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿInput File using Tape or 8" DisketteLocating the Input File on Tape or 8" DisketteMagnetic tapes and 8" diskettes may contain more than one file. When Prospector first reads a tape or 8" diskette, it creates an index of all files on that medium and records the index in a file whose name is made up of the current session ID and an extension of ".FDX" (for example TESTRUN.FDX). Subsequent Pn3nnrospector SessionsWhen a subsequent Prospector session is to use the same tape or 8" diskette to process a different input file, the same index is used to select the individual file required. A dialog box appears asking if this is the first time you have used this tape or diskette. If you answer "No" to this question, another dialog box appears asking you to enter the name of the Prospector session where the tape or diskette was first read. If the index file cannot be located, you will be returned to the dialog box where you can alter the session name supplied or click the "Cancel" button.(ü3(,*€€Š R€‚‚€€‚‚ÿChoosing the Input FileAfter the index file is successfully located or is created for the first time, the "Select File" dialog box appears showing a list of all files on the tape or diskette. Select the required file and click the "Ok" button.!(!!!ÿÿÿÿÿÿÿÿ!!!!Rÿÿÿÿÿÿÿÿ].!]/0€€Š R€€‚‚‚€€‚ÿFILE/OPEN SESSIONRestart and RecoveryòÊ]ò("€€Š XR‘€s€ƒ‚ÿA previous Prospector session can be recovered providing that the session files have not been deleted. All files prefixed by the Prospector session ID with the following extensions must be present: uAòu4:€€Š XR!s€‚ƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚‚ÿ.PRO.DF1.DF2.DF3.FDX (tape and 8 inch files only)&ñu&5<€€Š R€‚‚‚€€‚‚‚€€‚ÿThe DF2 and DF3 files, although not mandatory, will recover the session to a more complete state if they were created during the previous session.Opening an Existing SessionTo rerun Prospector using a previous session's ID, select the File/Open Session menu option. The standard Windows file selection dialog box appears showing all sessions that can be recovered in the current directory. Drives and directories will be displayed in the normal way. Selecting a Prospector Session ID;&G)$€€Š R€ƒ‚‚ƒ‚‚‚ÿ1.Select the session ID fro”uºw¯sm the scroll list.2.Click the Open button or press Enter.Prospector will read the selected file and display the Input and Output Record Displays. At this point you are able to perform any Prospector operation upon the selected data file.!G!!!ÿÿÿÿÿÿÿÿ!!!!úÿÿÿÿÿÿÿÿ¤b!¤BV€€Š R€€‚‚‚€€‚‚‚€€‚‚‚€€‚‚ÿFILE/SAVE SESSIONSaving Prospector FilesThe File/Save Session command automatically saves your Prospector files with the filename corresponding to the session ID you provided when you started the session.How to Save a Prospector SessionTo save your work during the current session choose the File/Save Session menu item.Technical Support FilesA number of files are created during a Prospector session for use by Technical Support in the event of a problem. It is important to perform housekeeping routines on the disk, once satisfied with the output file(s) created by a Prospector session.5 ¤5+(€€Š R€‚€€‚‚ÿOpening an Existing SessionIn the event that you may subsequently wish to open an existing Prospector session, you are advised to keep the files referred to in the section "FILE/OPEN SESSION - Restart and Recovery" in a safe place such as a floppy diskette. !5!!!ÿÿÿÿÿÿÿÿ!!!!(ÿÿÿÿÿÿÿÿê²!ê8B€€Š R€€‚‚‚€€‚‚‚€€‚ÿFILE/SAVE SESSION ASChanging the Session IDThe FILE/Save Session As command allows you to change the session ID during a Prospector Session.How to Change Session IDrJêr("€€Š XR‘€s€ƒ‚ÿ1.To change the session ID, select the File/Save Session as menu item.&r&#€€Š R€‚ÿ…]&…("€€Š XR‘€s€ƒ‚ÿ2.Enter the new, unique session ID. Prospector will display the new ID in the title bar.!…!!!ÿÿÿÿÿÿÿÿ!!!!;ÿÿÿÿÿÿÿÿò±!þAT€€Š R€€‚‚‚€€‚‚‚€€‚‚€€‚‚ÿFILE/IDENTIFY INPUT DAT†§†AChoosing your Input FileYou are automatically presented with the Select Medium dialog box after selecting the File/New command and supplying a session identifier, or after selecting the File/Identify Input Data command. Prospector is requesting information about where to access the input file data.Select the MediumMedium Description  wþ )$€€Š XRA‚Ã}€ƒƒ‚ÿ8-inch DiskIf the file is resident on an IBM format 8-inch diskette loaded in the Flagstaff 8-inch diskette drive.& &#€€Š R€‚ÿ“j&“)$€€Š XRA‚Ã}€ƒƒ‚ÿMagnetic TapeIf the file is resident on a 9-track magnetic tape loaded with the tape dirve "on-line".&“&#€€Š R€‚ÿlB&l*&€€Š XRA‚Ã}€ƒƒƒ‚ÿPC DiskIf the file is resient on one of your PC disk drives. ßl ,*€€Š R€‚‚€€‚‚ÿClick the OK button to continueThe box that appears next will differ according to the medium of the input file. If the input file resides on one of the PC disk drives, a standard Windows file selection box appears listing all files in the current directory (or data directory specified in Options/Parameters). Select the required file and click the "Ok" button. If the medium is tape or 8" diskette, see the help topic "Locating the Input File on Tape or 8" Diskette".& &#€€Š R€‚ÿ!&!!!ÿÿÿÿÿÿÿÿ!!!!$ ÿÿÿÿÿÿÿÿK!œE\€€Š R€€‚‚‚€€‚‚‚€€‚‚‚‚‚‚€€‚‚ÿFILE/PRINTPrinting Prospector ReportsThe File Print command allows you to print the three different reports pertaining to the current Prospector session. These reports document the results of activities during your session. Prospector Report Types Summary Report Input File Definition Output File DefinitionSummary ReportThe Summary Report provides various information about your Prospector session in gâ…†â…eneral. This information includes a summary of the files created during the session, as well as the following details concerning the input file:~Mœ~14€€Š R€‚‚‚‚‚‚‚€€‚‚ÿ Input File Name Creation Date of Input File Size of File Number of Records in Input File Record Length Record FormatInput File DefinitionThe Input File definition report provides you with the record layout of the data file determined by Prospector and refined by the user. This report includes the field number, the starting and ending location of the field, the type of data contained in the field (packed signed, binary, etc..), the field classification and whether or not the field was selected for inclusion in the Output File. ×~ 4:€€Š R€‚€€‚‚‚€€‚‚ÿOutput File DefinitionThe Output File Definition provides information about the Output file created during your Prospector session. This report indicates the fields selected for extraction and provides their starting and ending locations in the Output File, the number of decimal places shown, the sign of the field if it is numeric (leading, trailing, etc..) and the field classification.Printing the ReportAfter determining which reports you wish to print click on the desired report. Your selection is indicated by an "X" appearing in the box next to the selected report. Click the "Ok" button and your reports will be generated and sent to the printer. You may select as many or as few reports as required. Þ· Þ' €€Š R€‚€‚ÿNOTE: Prospector turns control over to the Windows print spooler when reports are printed. Be sure you have your printer configured properly before attempting to print reports.!Þ!!!ÿÿÿÿÿÿÿÿ!!!!?ÿÿÿÿÿÿÿÿÙ!9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿFILE/EXITEnding a Prospector SessionThe File/Exit command allows you to exit Prospector and return to the DOS prompt or'H' Windows environment. Prospector asks you if you wish to update the session files or not. Click on your desired selection and you will be returned to the operating system. Exit without a SaveIf you choose to exit Prospector without updating the session files, all work done in a new session after Interpret has completed will be lost. !!!!ÿÿÿÿÿÿÿÿ!!!!ÀÿÿÿÿÿÿÿÿŸo!Ÿ02€€Š R€€‚‚‚€€‚‚ÿFILE/ABOUTProspector Version The File/About menu item indicates the version of Prospector being used.!Ÿ!!!ÿÿÿÿÿÿÿÿ!!!!ÿÿÿÿÿÿÿÿ­{!­26€€Š R€€‚‚‚€€‚‚‚‚ÿINTERPRET/AUTOMATICStarting the Interpretation ProcessBefore you can begin transferring the input data to an output file, you can instruct Prospector to translate and display the input file in a format that you can understand.The Automatic Interpretation process will analyze a sample of input data and, with whatever information you volunteer (if any), will calculate the record length and character type of the file. Interpret will then proceed to make a "best guess" as to the format and layout of the data within a record. This layout will be used to take the first record from the file and translate it into a readable Input Record Display. You must then refine this view of the input data based upon the knowledge you have about the data required for output purposes. For more information on refining the Input Record Display, refer to the description of the Edit command.ä±­ä38€€Š R€‚€€‚ƒ‚‚ƒ‚‚ƒ‚‚ÿTo Start Automatic Interpretation1.Choose the Interpret command on the Prospector menu bar2.Select Automatic3.Select a Record Length option or accept the default.¨}ä¨+(€€Š XR±ã~€€ƒ‚ÿKnownIf you are certain of the record length of the input file select Known and type the record length in the Length box&¨&#€€Š R€‚ÿV+&b+(€Â—è—h’€Š XR±ã~€€‚‚ÿBest Guess If you know an approximate record length for the file but require Prospector to calculate an accurate length between a given range select Best Guess. Type the approximate record length in the Length box. Type the value to be searched before and after the value entered in "Length"ª…bª%€€Š R‘€€‚ÿEg. A Length of 2000 and a Range Factor of 50 will instruct Prospector to search for record lengths in the range of 1950 - 2050&ª&#€€Š R€‚ÿܱ&Ü+(€€Š XR±ã~€€ƒ‚ÿUnknownIf you do not know the record length of the input file then take no action, Unknown is the default selection. If the record is long this process will take some time.&Ü&#€€Š R€‚ÿwO&w("€€Š XR‘€s€ƒ‚ÿ4.Set Header Length, if known. Choose Known, then enter the header length.^8w^&€€Š R€‚ƒ‚‚ÿ5.Select a File Type option or accept the default.Š_^Š+(€€Š XR±ã~€€ƒ‚ÿASCIIClick on ASCII if you are certain that the character type of the input file is ASCII.&Š&#€€Š R€‚ÿb&+(€€Š XR±ã~€€ƒ‚ÿEBCDICClick on EBCDIC if you are certain that the character type of the input file is EBCDIC.&&#€€Š R€‚ÿ©~&©+(€€Š XR±ã~€€ƒ‚ÿUnknownIf you are not sure of the character type of the input file then take no action, Unknown is the default selection.&©&#€€Š R€‚ÿsK&s("€€Š XR‘€s€ƒ‚ÿ6.Exit from the dialog box by pressing Enter or clicking the Ok button.Y4sY%€€Š R€‚‚‚ÿThe Data Interpretation dialog box will appear.ûÓY("€€Š XR‘€s€ƒ‚ÿ7.Start Interpretation of the Input File by pressing Enter or clicking the Start button. Status information will be displayed in the Status box while Interpretation is running, terminating with the message:XXXXXXXXXXXXXXXXXXXXXXïž  h’øÐø("€€Š R€‚ƒ‚‚‚‚ÿ"Data Interpretation has Completed"You can terminate Interpretation at any time by clicking the Cancel button or pressing the Esc key. You will be asked to confirm that you wish to cancel processing.sKøs("€€Š XR‘€s€ƒ‚ÿ8.Exit from the dialog box by pressing Enter or clicking the Ok button.!s!!!ÿÿÿÿÿÿÿÿ!!!!§ ÿÿÿÿÿÿÿÿÀ‡!À9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿTHE PHASES OF INTERPRETATIONDisplay InformationThe information displayed during the Interpret phase of Prospector is intended to be informational. The messages displayed reflect the logical processes that Interpret follows when analyzing the format of an input file.Interpret ParametersInterpret uses parameter information stored in the WIN.INI file to establish a start point and length for it's first sample of input data. The Options/Update Parameters menu item allows these parameters to be modified. (See the "Options/Update Parameters" help topic for more information). The sample data is used for the following processes:%áÀ%DZ€€Š R€‚€€‚‚€€ƒ€€‚‚‚‚€ƒ‚€ÿInterpret Processes1.Performing Frequency AnalysisThe data sample is analyzed to assess the relative frequency of data that is "pure" EBCDIC, "pure" ASCII or "pure" BINARY. These "pure" categories will only include character combinations that could not be confused with any other type, apart of course from Binary. This information is used to determine the character type of the file and the possible existence of binary data.2.Text Data is EBCDIC (or ASCII)û%+$€€Š R€‚‚ÿThis information is displayed as a result of the previous process. This algorithm is rarely wrong although if the resulting Input Record Display is clearly wrong or displaying many "@" this may be an indication of an incorrect analysis of File Type. It can be corrected by selecting the Options/Toggle Input Type my¤ž¦˜¡enu item, or reinterpreting and volunteering the File Type. If Text Data is determined to be "MIXED", it may be due to the absence of character data or a high incidence of binary data. ?+?8B€€Š R€‚€ƒ‚€‚‚‚€ƒ‚€‚‚ÿ3.Performing Record Length DeterminationIf Data Interpret has been given no hint of an approximate record length, this process could be the most time consuming. The time taken to calculate the record length correlates directly with the actual length of the record. 4.Record Length is xxxThis length reflects the record length calculated in the previous process or volunteered by the user as "known". If this length is clearly incorrect then reinterpret volunteering information to help the process.)Ü?)Ml€€Š R€‚€ƒ‚€‚‚‚€€ƒ€€‚‚‚‚€€ƒ€€‚ÿ5.Determining Column TypesInterpret analyzes each column of a record within the sample and assigns a data type.6.Determining Field TypesThe column types determined above undergo further analysis in order to group columns into fields. Fields are arbitrarily split at change of data type and between alpha and numeric. The user will have the ability to alter field boundaries using the Edit/Cut and Edit/Join commands.7.Data Interpretation has Completedè)&€€Š R€‚‚‚‚ÿWhen this message is displayed, you must click the OK button or press Enter to continue. The first record from the input file is read, translated according to the interpreted format, then displayed in the Input Record Display.!!!!ÿÿÿÿÿÿÿÿ!!!!ì ÿÿÿÿÿÿÿÿ–f!¢02€€Š R€€‚‚‚€€‚‚ÿINTERPRET/MANUALWhy use Interpret Manual?The Interpret/Manual menu option is used when you do not want Prospector to interpret the input record length and field formats for you. In order to run Prospector, the record length and file type must be known or determined. The Interpret manual mode allows you to enter the known r`®®`®ecord length or enter a guess and determine if it is correct. Once Prospector has the record length and file type, the Input Record Display will show the first record without field formatting. It is then up to the user to determine the field formats necessary for processing.¤s¢¤14€€Š R€‚€€‚‚ƒ‚‚ƒ‚‚ÿStarting an Manual Interpret1.Choose the Interpret command on the Prospector menu bar.2.Select Manual.ö¤("€€Š XR‘€s€ƒ‚ÿ3.If you know there is a header and it's length, choose Known, then enter the header length. Otherwise keep the default of Unknown. See the help topic "Determining Input File Header Lengths" for information on how to find the header length.''#€€Š R€‚ÿ >'>("€€Š XR‘€s€ƒ‚ÿ4.Enter the known record length. If you are not certain of the length, you will later need to visually verify that your guess is correct by scrolling through consecutive records in the Input Record Display and making sure the data is aligned on record and field boundaries.&>&#€€Š R€‚ÿÞ&("€€Š XR‘€s€ƒ‚ÿ5.Select a File Type option. If you are not sure of the character type of the input file, one option would be to run Interpret Automatically to find out, exit Prospector, then come back in and run Interpret Manually.&&#€€Š R€‚ÿŠ_&Š+(€€Š XR±ã~€€ƒ‚ÿASCIIClick on ASCII if you are certain that the character type of the input file is ASCII.&Š&#€€Š R€‚ÿb&+(€€Š XR±ã~€€ƒ‚ÿEBCDICClick on EBCDIC if you are certain that the character type of the input file is EBCDIC.&&#€€Š R€‚ÿsK&s("€€Š XR‘€s€ƒ‚ÿ6.Exit from the dialog box by pressing Enter or clicking the Ok button.ΨsÚ&€€Š R€‚‚‚‚ÿThe Prospector main window will appear, displaying record one in the Input Record Display. The characÿ¶r·`®ter data will be translated according the File Type you specified. Some of the numeric data will also appear translated.The occurrence of rectangular black boxes indicates that the respective characters do not translate to the limited ASCII character set which Windows can display. These will most likely be bytes from packed decimal, binary, or some other numeric field. Once you have identified the field boundaries and formats using the View/Information and Edit/Cut commands, these fields will be translated and displayed understandably in the Input Record Display.!Ú!!!ÿÿÿÿÿÿÿÿ!!!!~ÿÿÿÿÿÿÿÿu<!u9D€€Š R€‚‚€‚€€‚‚‚€€‚‚ÿField Information/LocationGetting Field Information on a Particular CharacterFor brief information on a particular character or number in a field, position the cursor on the HEX code in the Input Record Display and click and hold the right mouse button. If the display is not currently showing the hex codes, the Options/Toggle Hex menu item will activate the hex display.Byte PositionThe position the selected byte occupies in the record and the field format will be displayed over the Input Record Display as long as the right mouse button is depressed.èÂuè&€€Š R€‚‚‚‚ÿThe display of the field location within the input record is particularly convenient during reformatting functions such as Cut and Join.The field location function can be used at any time.!è!!!ÿÿÿÿÿÿÿÿ!!!!û ÿÿÿÿÿÿÿÿ&ê!2<J€€Š R€€‚‚‚€€‚‚‚€€‚ƒ‚‚‚ÿVIEW/FIELD INFORMATIONGetting Detailed Field InformationThe View/Field Information command is used to obtain detailed information about a field displayed in the Input Record Display or Output Record Display.To obtain detailed information about a specific field1.Choose the View/Field Information command.Once the command is selected, move the cursor over the desired field. Notice that the ¾-¾ ¾cursor has changed to "?" to indicate that you are in the Field Information mode.ß°2ß/0€€Š R€‚ƒ‚‚‚‚€€‚ÿ2.Click on the desired field.The "Detailed Field Information" dialog box appears, displaying various technical information about the selected field.Field InformationnCßn+(€€Š XR‘€s€€ƒ‚ÿStarting ByteFirst position in record that the field occupies.pDnp,*€€Š R€‚€€ƒ‚‚ÿEnding ByteLast position in record that the field occupies.pDpp,*€€Š XR±S~€€ƒƒ‚ÿLengthTotal number of bytes in record that the field occupies.&p&#€€Š R€‚ÿ·‹&·,*€€Š XR±S~€€ƒƒ‚ÿField ClassIndicates the functional classification of the selected field. There are four main functional classifications as follows:&·&#€€Š R€‚ÿoF&o)$€€Š XR±ã~€ƒƒ‚ÿTextIndicated when the selected field contains alphanumeric data.&o&#€€Š R€‚ÿ x& ("€€Š XR±ã~€ƒ‚ÿIdentifierUnsigned numeric data that does not contain leading zeros (e.g. Account Numbers, Order Numbers, etc..).& &#€€Š R€‚ÿ†^&†("€€Š XR±ã~€ƒ‚ÿValueNumeric data that usually contains leading zeros and is signed (eg. Amount, Balance).&†&#€€Š R€‚ÿƒZ&ƒ)$€€Š XR±ã~€ƒƒ‚ÿDateNumeric data in calendar format reflecting day/month/year or similar combination.&ƒ&#€€Š R€‚ÿ‰a&‰("€€Š XRÑ‚S~€ƒ‚ÿDate SubclassOnly active if the Field Class is date. This is the user specified date format.(‰(#€€Š R€‚ÿ àµ(à+(€€Š XR±S~€€ƒ‚ÿCurrent TypeIndicates the format of the selected field. If the field is numeric, this type will indicate the numeric format, further details of which can be found in appendix.&à<#€€Š R€‚ÿXXXXXXXXXXÐÇ È ¾’g<’+(€€Š XR±S~€€ƒ‚ÿTranslationShows the translation of the actual field data according to the specified Current Type.&’&#€€Š R€‚ÿæ&+(€€Š XR±S~€€ƒ‚ÿType OptionsLists all possible field data types. The user can change the data type by clicking on one of the types listed. Changing the data type will result in a different translation. See Appendix for type descriptions.2 2%€€Š R€‚‚‚ÿThe information mode will remain in operation until another mode, such as Edit/Cut, is enabled. Since field characteristics can be changed in the Field Information box, you will receive a warning if you have chosen to look at a selected Input Record Display field. Selected fields should be deleted from the Output Record Display before any characteristics are modified.Once you have completed viewing the Detailed Field Information click the "Ok" button to save any changes and return to the Field Information mode. !2!!!ÿÿÿÿÿÿÿÿ!!!!|1ÿÿÿÿÿÿÿÿ: !:14€€Š R€€‚‚‚€€‚‚‚ÿField Format InformationMaximum Field LengthsJoining two fields together where the resulting length exceeds the maximum length for that type of field is not allowed. The following list indicates the maximum length allowed (in bytes) for each field type.Ñ:=L€€²JBR‚a€€ƒ€€‚‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ÿField Format Character DataMaximum Field LengthNumeric (unsigned)50Numeric Leading sign51Numeric Trailing sign51Numeric overpunch (leading)50Numeric overpunch (trailing)50Packed, unsigned25m02€€Š R€ƒƒ‚ƒƒƒƒ‚ƒƒ‚ƒƒ‚ÿPacked, unsigned zero25Packed, signed25Binary unsigned, MSB first8Binary unsigned, LSB first8a8a)$€€¾JBR‚a€ƒ‚ƒ‚ÿBinary signed, MSB first8Binary signed, LSB first8*a*' €€¾JBR„a€‚ÿã*#4:€€Š R€‚‚€€‚‚€€‚‚ÿFIELD TYPE DEFIϹÏ(ÌNITIONSGeneral InformationData is stored in the computer in the form of bytes. Each byte is a group of eight bits, which are electric charges in the computer's memory or magnetized spots on the storage devices. Bits are represented by either 1's or 0's. Bits represented by 1 are referred to as being turned on. If the bit is a 0, it is referred to as being turned off. The information stored in the byte depends upon which of the bits are turned on.Ë¥#Ë&€€Š R€‚‚‚‚ÿHalf of a byte is referred to as a nibble (no joke). Each byte has a high order nibble and a low order nibble. A byte generally stores one character or one digit of a number.The contents of these bytes can be represented to humans in several ways. One way is with hex codes, which appear in the Prospector Input Record Display. The hex byte uses two characters/numbers to represent the byte. One character/number represents the bits turned on in the high order nibble and another does the same for the low order nibble. For example, 00 hex signifies that none of the bits in the byte are turned on. Valid hex codes contain the numbers 0 - 9 and the letters A - F.¢uË¢-,€€Š R€‚€€‚‚‚‚ÿCharacter dataThere are two types of character data, ASCII and EBCDIC. These two types of data are alphanumeric characters which are represented by a unique set of specific hex bytes. Alphanumerics include both letters and numerals.Many mainframes use EBCDIC codes to store their character data. PCs use ASCII codes to store their character data. If you believe that a field is character data but it does not appear to be so in the Input Record Display, try toggling the input file type with Options/Toggle Input Type. This will change the translation of the Input File data back and forth between ASCII and EBCDIC.Ô¢<J€€Š R€‚€€‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚ÿNumeric (unsigned)These are EBCDIC or ASCII numeric fields without any sign information. ASCII hex codes for numerics§ÔI×(Ì are:30 translates to 031 translates to 132 translates to 233 translates to 334 translates to 435 translates to 536 translates to 637 translates to 738 translates to 839 translates to 9Examples of an ASCII numeric: 39 31 36 translates to 916 37 38 30 30 32 translates to 78002EBCDIC hex codes for numerics are: Ê AT€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚ƒ‚ƒ‚‚€€‚‚‚‚ƒ‚ƒ‚ÿF0 translates to 0F1 translates to 1F2 translates to 2F3 translates to 3F4 translates to 4F5 translates to 5F6 translates to 6F7 translates to 7F8 translates to 8F9 translates to 9Example of an EBCDIC numeric:F9 F3 F2 translates to 932F7 F1 F0 F2 translates to 7102Numeric Leading SignThese can be EBCDIC or ASCII numerics with explicit leading signs.Examples of Hex codes for ASCII signs are:2B translates to +2D translates to -"â "@R€€Š R€‚‚ƒ‚ƒ‚‚‚ƒ‚ƒ‚‚‚ƒ‚ƒ‚‚‚€€‚‚‚‚ÿExamples of ASCII Numeric Leading Sign:2B 36 32 37 translates to +6272D 37 30 35 31 translates to -7051Examples of Hex codes for EBCDIC signs are:4E translates to +6D translates to -Examples of EBCDIC Numeric Leading Sign:4E F8 F9 F2 F0 translates to +89206D F2 F7 F1 translates to -271Numeric Trailing SignProspector will display trailing signed fields with the sign at the front of the field.Examples of an ASCII numeric with an explicit trailing sign:ÿÈ" 7@€€Š R€ƒ‚ƒ‚‚‚ƒ‚ƒ‚‚€€‚‚‚‚ÿ35 31 30 2D translates to -51038 30 31 2B translates to +801Examples of an EBCDIC numeric with an explicit trailing sign:F8 F2 F7 6D translates to -827F9 F2 F0 F0 4E translates to +9200Numeric overpunch (leading)This is a numeric with a leading overpunched sign. Overpunched means that there is no extra, explicit byte as there is in the examples above. Instead, a special byte is used which indicates both the sign and the digit.Most of the time overpunched fields will occur in an EBCDIC file. The overpunch simply consists of replacing the F fropÛ’Ý(Ìm the hex code with a C if it is positive or a D if it is negative. There are a few cases where a B is used to designate a negative overpunch.Ô ;H€€Š R€‚ƒ‚ƒ‚ƒ‚ƒ‚‚‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ÿExamples:C4 F3 F9 translates to +439D5 F6 F1 F9 translates to -5619C7 F1 F0 F0 translates to +7100D8 F4 F9 translates to -849ANSI standard COBOL can generate ASCII signed numeric fields with the overpunch on the leading or trailing byte. Hex codes for leading or trailing ASCII '+' and '-' sign overpunches:7B translates to +07D translates to -041 translates to +14A translates to -142 translates to +24B translates to -243 translates to +3 ¾ Nn€€Š R€ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚ƒ‚‚‚ƒ‚ƒ‚ƒ‚ƒ‚‚€€‚ÿ4C translates to -344 translates to +44D translates to -445 translates to +54E translates to -546 translates to +64F translates to -647 translates to +750 translates to -748 translates to +851 translates to -849 translates to +952 translates to -9Examples:49 32 34 38 translates to +92484E 38 31 30 translates to -581042 30 38 translates to +20852 36 33 31 translates to -9631Numeric overpunch (trailing)Ň Å>N€€Š R€‚‚ƒ‚ƒ‚ƒ‚ƒ‚‚ƒ‚ƒ‚ƒ‚ƒ‚‚€€‚‚ÿSame as above, only the overpunch byte follows the numerics instead of preceding them. Example EBCDIC:F5 F3 F8 F3 D9 translates to -53839F6 F7 F3 C4 translates to +6734F2 F5 F1 D0 translates to -2510F8 F5 F0 C0 translates to +8500Example ASCII:31 32 39 45 translates to +129538 37 35 4A translates to -875136 31 7D translates to -61032 38 7B translates to +280Packed DecimalPacked Decimal is a format which is used to store numbers with half of the usual storage requirements. Two digits of the number are packed into one byte of memory. This is also known as BCD (Binary Coded Decimal). In COBOL, it is comp-3 format.9ïÅEJf€€Š R€‚‚€€‚‚‚‚ƒ‚ƒ‚‚‚€€‚‚‚ƒ‚‚‚€€‚‚‚ÿPacked, unsignedPacked Decimal format without a sig¸ä}ç(Ìn. Assumed to be positive.Examples:03 82 74 translates to 3827438 27 40 translates to 382740Packed, unsigned zeroUnsigned Packed Decimal zeros.Example: 00 00 00 translates to 000000Packed, signedThis is a Packed Decimal format with a sign contained in the low order nibble of the last byte of the number. Signs are hex B, C, and D. The B and D areused for negative numbers. The C is used for positive numbers.BEB4:€€Š R€‚ƒ‚ƒ‚ƒ‚‚€€‚‚‚‚ÿExamples:45 72 4C translates to +4572455 83 39 00 0D translates to -55833900008 31 33 5B translates to -831335Binary FormatsBinary formats are a way to store numbers using the very least amount of storage.In binary representation, each bit of the byte(s) is associated with a specific value. Let's look at one binary byte. First, start with the eight bits all turned on. A 1 is used to signify that the bit is on, a 0 means it is off. It is easier to look at the byte if we put a space between the nibbles.÷B$€€Š R€‚‚ÿ 1 1 1 1 1 1 1 1The values for the bits in the high order nibble are 128, 64, 32, and 16 from left to right. In the low order nibble we have values of 8, 4, 2, and 1, again from left to right. These values are always powers of two. The total of all of the values of the turned on bits in the byte(s) is the number represented. In this case it is 128 + 64 + 32 + 16 + 8 + 4 + 2 + 1 which sums to 255. Another example is 0 0 1 0 0 1 0 1 which translates to 32 + 4 + 1 = 37. ç&€€Š R€‚‚‚‚ÿThere are several different binary formats which are differentiated by the way the values and signs are assigned to the bits. The assigned value depends upon two things; whether the binary format is signed or unsigned; whether the binary format is MSB (most significant byte) first or LSB (least significant byte) first.When you are dealing with numbers that are small enough to be stored in only one byte, MSB or LSB first formats doìî(Ì not come into play but signed formats do.J J*&€€Š R€‚‚‚‚‚‚‚‚ÿLet's first look at one unsigned byte. To find the number represented, add up the values of the bits which are turned on. As we said before, the values for the bits from left to right are:128 64 32 16 8 4 2 1Examples:1 0 0 1 0 0 1 1 is 128 + 16 + 2 + 1 which adds up to 1470 1 0 1 0 1 0 1 is 64 + 16 + 4 + 1 = 851 1 1 1 1 1 1 1 is 128 + 64 + 32 + 16 + 8 + 4 + 2 + 1=255As you can see, 255 is the highest number that can be stored in one byte in unsigned format. To store larger numbers, more bytes are required. *J*&€€Š R€‚‚‚‚ÿIn signed binary formats, the leftmost bit of the byte is designated as a sign bit. It no longer signifies a value, only a sign. If it is on, then the number represented by the byte is negative. If it is off, the number is positive. With one bit designated as a sign bit, the byte is only capable of representing a positive number up to 127 instead of 255 as before.When there is more than one byte, the difference between the LSB and MSB first formats becomes apparent. Let's say that we have numbers which are greater than 255 and we want to store them in unsigned MSB first format. It is simply a matter of figuring the powers of two for eight more bits, which gives us the following 16 bit value assignments, again spaced into nibbles for ease of viewing: Ò*/0€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚‚ÿbyte two32768 16384 8192 4096 2048 1024 512 256byte one128 64 32 16 8 4 2 1Byte two is the most significant byte because it's values are greater than those in byte one. Since byte two is most significant and it is to the left, or first the format is MSB first. Examples:0 0 1 0 1 0 0 0 1 0 0 1 0 0 0 1 translates to8192 + 2048 + 128 + 16 + 1 = 103851 0 0 0 0 0 1 1 0 0 1 0 1 1 1 0 translates to32768 + 512 + 256 + 32 + 8 + 4 + 2 = 33582 Ý..€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚ÿ0 0 0 0 0 0 1 0 1 1 1 1 1 1 1 1¬õ­÷(Ì translates to512 + 128 + 64 + 32 + 16 + 8 + 4 + 2 + 1 = 767If we wanted to store these same numbers in unsigned LSB first format, the bit assignments would be as follows: byte one128 64 32 16 8 4 2 1byte two32768 16384 8192 4096 2048 1024 512 256As you can see, the least significant byte is now first. Byte one and byte two have been swapped. The binary bytes for the numbers from the examples above would now look like:Ö,*€€Š R€‚‚‚‚‚‚‚‚‚‚ÿ 1 0 0 1 0 0 0 1 0 0 1 0 1 0 0 0 translates to128 + 16 + 1 + 8192 + 2048 = 103850 0 1 0 1 1 1 0 1 0 0 0 0 0 1 1 translates to 32 + 8 + 4 + 2 + 32768 + 512 + 256 = 335821 1 1 1 1 1 1 1 0 0 0 0 0 0 1 0 translates to128 + 64 + 32 + 16 + 8 + 4 + 2 + 1 + 512 = 767For binary signed, MSB first the far left bit of the leftmost byte is designated as a sign bit. Binary signed, LSB first designates the far right bit of byte one as the sign bit.ÞˆÞV~€€Š R€€‚‚‚€€‚‚‚€€‚‚‚€€‚‚‚‚‚‚‚‚€€‚‚‚‚‚‚‚‚ÿValues for bits in bytes:Byte 1128 64 32 16 8 4 2 1Byte 232,768 16,384 8192 4096 2048 1024 512 256Byte 3low order nibble524,288 262,144 131,072 65,536high order nibble8,388,608 4,194,304 2,097,152 1,048,576Byte 4low order nibble134,217,728 67,108,864 33,554,432 16,777,216high order nibble2,147,483,648 1,073,741,824 536,870,912 268,435,456!Þ!!!ÿÿÿÿÿÿÿÿ!!!!kÿÿÿÿÿÿÿÿ.ü!:26€€Š R€‚‚€‚€€‚‚‚‚ÿVIEW/RECORD ISOLATIONLocating Data If you have a report containing data from the input file, you may wish to locate an input record corresponding to a line in the report. This can be helpful when you are trying to refine the Input Record Display. You can locate the data visually (see next topic) or by automatically searching using the View/Record Isolation command.The help topic "GENERAL - Field Classifications" will explain field classes, which are referenced in the follÅýæýÅýowing procedure. M":M+(€€Š R€‚€€‚‚ÿTo Find a Particular Recordc;Mc("€€Š XR‘€s€ƒ‚ÿ1.Choose the View/Record Isolation command. The Record Isolation Search dialog box will appear and require you to enter 2 example fields which, together, will isolate a unique record in the input data file. Your objective is to locate a single record from the input file that will contain both example fields.&c&#€€Š R€‚ÿ¯‡&¯("€€Š XR‘€s€ƒ‚ÿ2.Fill in the first example and a name for the output field. The "Identifier Data:" should represent an actual field in the input data file. This data may be obtained from a printed report or by an inquiry of the source of the input file. The "Name:" represents the descriptive field name that you wish to give the field. This field name is referenced in other Prospector operations.Ô¯38€€Š R€‚€€‚‚‚€€‚ÿIdentifier FieldsAn Identifier field is one that has been assigned a class of Identifier (ID) by Prospector. Typical identifier fields would be account numbers, product codes, and check numbers. Note that leading zeroes and positive signs need not be entered for numeric data (eg. 12 will located a field stated as +00012 , -14 will located a field stated as -000014 unless it is a character field).Note: Use the [Tab] key to move between the edit boxes.&&#€€Š R€‚ÿèÀ&è("€€Š XR‘€s€ƒ‚ÿ3.Fill in the second example and a name for the output field. A Text field is one that has been assigned a class of Text or Character Data by Prospector. Typical text fields would be customer name, address, and product description. A Value field is one that has been assigned a class of Value by Prospector. Typical value fields are balances, amount and interest due. Leading zeroes and positive signs need not be entered for value data. yTè…%€€Š R€‚‚‚ÿIt is crucial that example dataÒºÅý be typed and spelled correctly. Capital letters are stored differently than lower case letters. When you supply a text value be sure that the format used for the constant is the same as the format used in the input data file. An error could result in a lengthy, unproductive search of the input file.wO…w("€€Š XR‘€s€ƒ‚ÿ4.After the required information is entered, click the "Search" button to begin the Record Isolation process. The Check Examples dialog box will appear which provides the opportunity to edit your search criteria or to commence with the search. If you wish to change one of your entries, click the Edit button. You will be back in the Record Isolation Search dialog box to make your changes. If you are satisfied with the data entered click the "Search" button to continue the search. The Search dialog box will appear and prompt you to click the "Start" button to begin the search.zJwz02€€Š R€‚€€‚‚‚€‚ÿThe SearchProspector will now search the input data file and stop at the first instance where the Record Isolation criteria are met. The fields specified in the Record Isolation dialog box will be displayed as shaded in the Input Record Display, and will automatically appear as selected fields in the Output Record Display.Note: Shaded fields cannot be selected for further operations in the Input Record Display. Use of the Edit/Delete command will delete selected fields from the Output Record Display and correspondingly remove the shading in the Input Record Display.!z!!!ÿÿÿÿÿÿÿÿ!!!!„ÿÿÿÿÿÿÿÿW'!c02€€Š R€€‚‚‚€€‚‚ÿVisually Locating DataManually SearchAs an alternative to isolating a line in the Input Record Display by automatically searching for key items of data, it may be preferable to scroll through the Input Record Display using the vertical scroll bars until the desired record is visible. This method would clearly not be feasible on a large filQrQe. The Options/Goto Record command gives you the ability to quickly access input records anywhere in the input file. You may also elect to toggle to the Options/Display Multiple Records mode in order to see five records from the input file at a time. Using the options/Toggle Hex command, you can eliminate the hex data representations in the Input Record Display. This would allow you to see twice as much of the input record on the screen as before.!c!!!ÿÿÿÿÿÿÿÿ!!!!¬ÿÿÿÿÿÿÿÿ´v!´>N€€Š R€€‚‚‚€€‚‚‚‚‚€€‚‚ƒ‚‚ÿEDIT/CUTMarking New Field BoundariesThe Edit/Cut command gives you the ability to break a single field into multiple fields. This technique may be useful when Prospector determines that a string of text is one field and your output objectives call for it to be two separate fields.To cut a Single Field into Multiple Fields1.Choose the Edit/Cut command.‡a´‡&€€Š R‘€€‚‚ÿNotice that your cursor will appear as a saw when you place it over the Input Record Display.™q‡™("€€Š XR‘€s€ƒ‚ÿ2.For each cut, place the saw at the location where the field is to be split and click the left mouse button.&™&#€€Š R€‚ÿ‘l&‘%€€Š R‘€€‚ÿThe field will be split into two separate fields. Most fields can be cut into separate fields according to your desires. With certain fields (eg. Packed Numerics) there may be certain positions where it is not logical to cut. Prospector will advise you if this situation is present and you should attempt a cut to the left or right of the original position. !‘!!!ÿÿÿÿÿÿÿÿ!!!!íÿÿÿÿÿÿÿÿ[*!g14€€Š R€‚‚€€‚‚‚‚‚‚‚ÿEDIT/JOINCombining Adjacent FieldsThe Edit/Join command gives you the ability to join multiple fields into a single field. For example, you could join two separate fields that contain the following information: Field 1 Ãäà First Name Field 2 Last NameThis combined field would be ideal for preparing confirmations, mailing lists, and correspondence lists. You may also wish to use a combination of Cut and Join commands to isolate a field containing both alpha and numeric characters (eg. an account number such as "AB1234")á­gá4:€€Š R€‚€€‚‚‚€€‚‚ÿJoin to the RightThe Edit/Join command joins the field in which the cursor resides with the field immediately to it's right. Care should be exercised in using the Edit/Join command in order that two fields that are in different formats are not needlessly joined. Once two or more fields have been joined together, all Prospector operations can be performed against the new combined field.To join two fields togetheršáÂ("€€Š XR‘€s€ƒ‚ÿ1.Choose the Edit/Join command. Notice that the cursor is a "J" when it is placed over the Input Record Display, indicating the Join mode is active. &Â&#€€Š R€‚ÿœt&œ("€€Š XR‘€s€ƒ‚ÿ2.For each join, place the cursor on the first of the fields to be joined (leftmost) and click the mouse button.!œ!!!ÿÿÿÿÿÿÿÿ!!!!¹ ÿÿÿÿÿÿÿÿQ!]9D€€Š R€‚‚€‚€€‚‚‚€€‚‚ÿEDIT/ANALYZEDetermining Field TranslationsThe Edit/Analyze command provides you with the ability to analyze and define a field which Prospector could not initially define during the Interpret phase.The '@@@' SignsDuring the Interpret phase Prospector attempts to define the proper format for all fields in the input record. In some instances, Prospector may not be able to initially identify and determine the format of a given field. When this situation occurs, the Input Record Display will show the unknown field as a series of "@@@". Each one of the @'s represents a byte of data stored in the field. Depending on your output objectives, you may need to select this field for transfer. To define the fÑòÑield to Prospector, you need to utilize the Edit/Analyze command.P%]P+(€€Š R€‚€€‚‚ÿTo select a field for analysis§P§("€€Š XR‘€s€ƒ‚ÿ1.Choose the Edit/Analyze command. Notice that the cursor will indicate that you are in analyze mode by changing to "@@@".&§&#€€Š R€‚ÿ‡_&‡("€€Š XR‘€s€ƒ‚ÿ2.For each field to be analyzed, place the cursor on the desired field and click the mouse.U*‡U+(€€Š R€‚€€‚‚ÿResults of the AnalyzeDepending upon the length of the selected field, one of two dialog boxes will appear. If the selected field is less than or equal to four bytes then a dialog box appears which presents you with the possible formats of the selected field. There are several ways to determine the proper format of the selected field. You may be able to determine the format from a sample report, a record layout, or inquiry of the input file source. To select the desired format click on the desired choice and then click the "Ok" button. êÆUê$€€Š R€‚‚ÿIf the selected field is greater than four bytes, an Analyze Binary dialog box will be displayed. Prospector provides you with two options to better determine the format of the field displayed: ‡bê‡%€€Š R‘€€‚ÿThe Cut mode allows you to cut the field into smaller pieces for further analysis or selection.&‡&#€€Š R€‚ÿñÌ&ñ%€€Š R‘€€‚ÿThe Search for Value option allows you to enter a value which will be searched for throughout the field in question. This value may be obtained from review of a printed report or from the data source.º–ñº$€€Š R€‚‚ÿThe Input Record Display will automatically be updated for the format you select regardless of the number of bytes contained in the unknown field.!º!!!ÿÿÿÿÿÿÿÿ!!!!æ ÿÿÿÿÿÿÿÿ!å!-<J€€Š R€‚€‚‚€€‚‚‚€€«'Ì'«'‚‚ƒ‚‚ÿEDIT/SELECTSelecting FieldsThe Edit/Select command allows you to select fields from the Input Record Display for transfer from the input file to the output file.To select a field1.Choose the Edit/Select command.‚]-‚%€€Š R‘€€‚ÿNotice that the cursor has changed to an "S" to indicate that you are in Edit/Select mode.&‚&#€€Š R€‚ÿ£{&£("€€Š XR‘€s€ƒ‚ÿ2.For each field selected, move the cursor to the desired field in the Input Record Display and click the mouse button.e9£e,*€€Š R€‚€€‚‚‚ÿNaming the Output FieldsYou are now presented with the Select Field dialog box. Prospector requires that you enter a descriptive field name for the selected field. This name will be used to reference the field in Integrity processing and export formats. It is therefore important to use meaningful names.¼“e¼)$€€Š XR‘€s€ƒƒ‚ÿ3.Enter the required name and click the "Ok" button. The selected field will become shaded in the Input Record Display and appear in the Output RecordDisplay. Once a field has been selected, Prospector functions such as Cut, Join, and Analyze cannot be performed on that field. Selection of fields can continue until all desired fields have been selected and appear in the Output Record Display.`+¼l5<€€Š R€‚€€‚‚‚‚€€‚‚ÿUsing the Accelerator Keys in Edit ModeYou may wish to move between the Cut, Join, Analyze and Select commands several times, in which case the accelerator keys (F3,F4, F5, and F6 respectively) will save time. You also have the option of selecting all fields from the Input Record Display for the Output Record Display.Selecting More Than One Field at a TimeTo select all fields from the input record for export, type Ctrl + S. All fields in the Input Record Display which have not been previously selected and are not redefine fields (i.e. require further analysis prior to selection) will be selec©+e-«'ted and appended to the end of any fields already present in the Output Record Display. Fields are selected to the output record in the same order as they occur in the input data record. Descriptive field names will consist of "field_1", "field_2", "field_3",..., where the field number corresponds to the location of the field in the Input Record Display. You may wish to change these to more appropriate field names using the Edit/Rename command.ÀœlÀ$€€Š R€‚‚ÿWhen the Select All command is used, any redefine fields encountered in the input record are not selected and a message appears displaying the number of redefine fields left in the input record. If these fields are required in the output record, use the View/Field Information command or the Edit/Analyze command to determine the proper translation. These fields can then be selected for the output record.!À!!!ÿÿÿÿÿÿÿÿ!!!!çÿÿÿÿÿÿÿÿÆ!Æ9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿEDIT/SELECT ALLSelecting All FieldsThe Edit/Select All command allows you to select all fields from the Input Record Display for transfer from the input file to the output file.To Move all Input Fields to the Output RecordTo select all fields from the input record for export, choose the Edit/Select All command (or use the Ctrl+S accelerator key). All fields in the Input Record Display which have not been previously selected will be selected and appended to the end of any fields already present in the Output Record Display. Fields are selected to the output record in the same order as they occur in the input data record. Descriptive field names will consist of "field_1", "field_2", "field_3",..., where the field number corresponds to the location of the field in the Output Record Display. You may wish to change these to more appropriate field names using the Edit/Rename command. !Æ!!!ÿÿÿÿÿÿÿÿ!!!!ÿÿÿÿÿÿÿÿÓš!ß9D€€Š R€€‚º7Û7º7‚‚€€‚‚‚€€‚‚ÿOUTPUT RECORD FIELD NAMESNaming Output FieldsProspector requires that each field in the Output Record Display have a descriptive field name. You will be asked to enter this field name when a field is selected through the Edit/Select command. This name will be used to reference the field in Integrity processing, Filtering, and export formats.IT IS THEREFORE IMPORTANT TO USE MEANINGFUL NAMES.!ß!!!ÿÿÿÿÿÿÿÿ!!!!sÿÿÿÿÿÿÿÿe,!e9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿEDIT/RENAMEChanging Output Field NamesThe Edit/Rename command allows you to edit the descriptive field name assigned to each of the fields displayed in the Output Record Display. The descriptive names were established during the Edit/Select phase of the program.To change a field namežvež("€€Š XR‘€s€ƒ‚ÿ1.Choose the Edit/Rename command. Notice that the cursor changes to "ID" to indicate that you are in rename mode.&ž&#€€Š R€‚ÿ€X&€("€€Š XR‘€s€ƒ‚ÿ2.Move to the desired field in the Output Record Display and click the mouse button.–q€–%€€Š R€‚‚‚ÿThe Change Field Name dialog box will appear, displaying the name previously assigned to the selected field.yQ–y("€€Š XR‘€s€ƒ‚ÿ3.Enter the new field name that you wish to assign and click the "Ok" button.švyš$€€Š R€‚‚ÿThe new field name will be used in Prospector output reports, as well as in the Integrity functions and Filtering.!š!!!ÿÿÿÿÿÿÿÿ!!!!YÿÿÿÿÿÿÿÿO!O9D€€Š R€€‚‚‚‚€€‚‚‚€€‚ÿEDIT/MOVEChanging Output Field OrderThe Edit/Move command allows you to adjust the order of the output fields in the Output Record Display. This is important if you are creating the output file with a predefined format expected by a later program.To move a field›sO§("€€Š XR‘€s>ß?o>€ƒ‚ÿ1.Choose the Edit/Move command. Your cursor will appear as a two-headed arrow with the letter M in the center.&§&#€€Š R€‚ÿûÓ&û("€€Š XR‘€s€ƒ‚ÿ2.Move the cursor over the center of the field in the Output Record Display that you wish to move and click the left mouse button to pick up the field. The display of the field will change to inverse video.&û&#€€Š R€‚ÿýÕ&ý("€€Š XR‘€s€ƒ‚ÿ3.Move the cursor to either the field preceding or the field following the desired location. Click the left mouse button to move your field before the current field or the right mouse button to move it after.þÚýþ$€€Š R€‚‚ÿThe field selected will be moved to the chosen location and the remaining fields adjusted accordingly. The Output Record Display is adjusted automatically for all moves. The Input Record Display is not affected.!þ!!!ÿÿÿÿÿÿÿÿ!!!!Ëÿÿÿÿÿÿÿÿd-!d7@€€Š R€‚€‚€€‚‚‚€€‚ÿEDIT/DELETEDeleting Output Record FieldsThe Edit/Delete command allows you to delete a field from the Output Record Display. Only fields which appear in the Output Record Display will be transferred from the input file to the output file. To Delete a Field from the Output Record Display€Xd€("€€Š XR‘€s€ƒ‚ÿ1.Choose the Edit/Delete command. Notice that your cursor now appears as an eraser.&€&#€€Š R€‚ÿ‚Z&‚("€€Š XR‘€s€ƒ‚ÿ2.Center the cursor over the field you wish to delete and click the left mouse button.£~‚£%€€Š R€‚‚‚ÿThe Delete Field message box will appear and ask you to confirm the deletion of the field from the Output Record Display.oG£{("€€Š XR‘€s€ƒ‚ÿ3.If you are sure you want to delete the field, click the "Yes" button and the field will be deleted from the Output Record Display. Otherwise click the "No–F9GéC" button. The deleted field will no longer be grayed in the Input Record Display. It is now possible to perform Cut, Join, and Select operations on the field again.!{!!!ÿÿÿÿÿÿÿÿ!!!! ÿÿÿÿÿÿÿÿýÅ!ý8B€€Š R€€‚‚‚€€‚‚‚€€‚ÿEDIT/DELETE ALLDeleting All Output FieldsThe Edit/Delete All command allows you to delete all fields from the Output Record Display.To delete all fields from the Output Record DisplayŒdýŒ("€€Š XR‘€s€ƒ‚ÿ1.Choose the Edit/Delete All command (or use the Ctl+U accelerator key to un-select all fields).©„Œ©%€€Š R€‚‚‚ÿThe Delete All Fields message box will appear and ask you to confirm the deletion of all fields from the Output Record Display.¶©¶' €€Š XR‘€s€ƒÿ2.If you are sure you want to delete all the fields, click the "Yes" button and all fields will be deleted from the Output Record Display (otherwise click the "No" button). If you selected yes and deleted all fields from the output record all fields in the Input Record Display will no longer be greyed. It is now possible to perform Cut, Join, and Select operations on all input fields again. !¶!!Kÿÿÿÿÿÿÿÿ*!*' €€Š XR‘€s€‚ÿ!*!!F ÿÿÿÿÿÿÿÿ.ó!.;H€€Š R€€‚‚‚€€‚‚‚‚‚€€‚‚ÿEDIT/LITERALSLiteral Output Record FieldsThe Edit/Literal command is used to insert literal fields between the fields of your output record. Literals are often punctuation marks such as commas and quotes. Some databases and data processing application programs require these separators to recognize field boundaries.To Insert Literal Fields into your Output RecordSelect the Edit menu item, then click on Literal. A display will show the existing literals available in Prospector.L!.L+(€€Š R€‚€€‚‚ÿTo Use an Existing LiteralŒdL˜("€€Š XR!s€ƒ‚ÿ1.Click on the desxOÄO)Mired selection. The literal chosen will be displayed in the Literal Edit Box.&˜&#€€Š R€‚ÿC&C&€€Š R‘€€ƒ‚ÿ2. Click on Add Literals.&C&#€€Š R€‚ÿýÕ&ý("€€Š XR!s€ƒ‚ÿ3.In the output record, move the cursor onto the field which is to precede or follow the literal field you are adding. Notice that the cursor has changed to "ADD" to indicate you are in the Add Literals mode.&ý&#€€Š R€‚ÿÞ¶&Þ("€€Š XR!s€ƒ‚ÿ4.Click the left mouse button to place the literal field to the left of the cursor field. Click the right mouse button to add the literal field to the right of the cursor field.DÞD*&€€Š R€‚€€‚ÿAdding a New LiteralÊ¥DÊ%€€Š R‘€€‚ÿIf you wish to use a literal which is not shown, enter the desired literal into the edit box. Select Add Literals to place literal fields into the output record.&Ê&#€€Š R€‚ÿžy&ž%€€Š R‘€€‚ÿThe Edit Literals button may be used to replace a previously added literal with a different literal. This is done by:&ž&#€€Š R€‚ÿwO&w("€€Š XR!s€ƒ‚ÿ1.Selecting a literal from the list box or by entering one in the edit box.&w&#€€Š R€‚ÿK%&K&€€Š R‘€€ƒ‚ÿ2.Click the Edit Literals button.&K&#€€Š R€‚ÿîÆ&î("€€Š XR!s€ƒ‚ÿ3.In the Output Record Display, move the cursor onto the literal field which is to be changed. Notice that the cursor has changed to "EDIT" to inform you that you are in the Edit Literals mode.&î&#€€Š R€‚ÿiA&i("€€Š XR!s€ƒ‚ÿ4.Click the left mouse button to change the selected literal.!i!!!ÿÿÿÿÿÿÿÿ!!!!`ÿÿÿÿÿÿÿÿ>!J9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿFILTER/DEFINEDefW±WWining a FilterIntegrity checking and transfer of records during export to the output file can both process either all of the input file records or just selected records. Prospector filters can be defined to process records based upon particular field contents or the record's position in the input file. Why Filter?Filtering allows field contents to be compared to the contents of other fields or values. Prospector allows multiple conditions in a filter to give maximum flexibility.ÝJ5<€€Š R€‚€€‚‚‚‚‚€€‚ÿFilter SamplingProspector filtering also includes the ability to "sample" records. This consists of allowing every nth record to pass through the filter. The Filter condition is built up first by specifying which of the records from the input file is to be processed, then by specifying field comparisons. The filter condition being built is displayed at the top of the Filter Define dialog box. Filters are not saved when Prospector is exited.To Build a Filter&&#€€Š R€‚ÿ¯‡&¯("€€Š XR‘€s€ƒ‚ÿ1.Choose the Filter/Define command from the menu. After selecting this command you are presented with the Define Filter dialog box.&¯&#€€Š R€‚ÿ?&?("€€Š XR‘€s€ƒ‚ÿ2.Fill in the Starting Record, Last Record, and Sample Rate values in the leftmost boxes. The first record is the default Starting Record. The number of records in the file is the default Last Record. Default Sample Rate is one. Keeping the default values will result in processing all records from the input file. For information on sampling, see the help topic "Sampling Records from the Input File". The help topic "Partial Input File Processing" will provide information about setting the Starting and Last Record values.&?&#€€Š R€‚ÿÀ˜&Ì("€€Š XR‘€s€ƒ‚ÿ3.Select the field for comparison from the list of Output Record Display fieldnames by double clicking. TG_m_Whe fieldname will appear in the Filter box.&Ì&#€€Š R€‚ÿ_7&_("€€Š XR‘€s€ƒ‚ÿ4.Select an operator. The available operators are:þÆ_þ8B€€Š R€ƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚‚‚ƒ‚ÿEqualGreater or EqualGreater ThanLess or EqualLess ThanNot EqualThe selected operator will appear after the fieldname in the Filter box.5.Select either a field or a value to be compared with the first field. To select a field, double click on the fieldname in the listbox. To select a value, move your cursor into the Value edit box, click, then enter the value you wish the first field to be compared against. Capital letters are stored differently than lower case letters. When you supply a text value be sure that the format used for the constant is the same as the format used in the input data file. This will ensure that only the desired records are passed through the filter. Numeric entries for comparison do not need to have the exact same format as the input field. Unless you indicate the value is negative it will be assumed to be positive. The selected fieldname or value will appear after the operator in the Filter box.ïþ' €€Š R€‚‚‚ƒ‚ÿYou have just built a simple filter which consists of one field comparison. You can specify an unlimited number of field comparisons in a filter, depending upon the amount of available memory. This is called a compound filter and is done by using "Join Conditions". Joining several comparisons allows greater flexibility in the screening of records from the input data file.6.The join conditions allowed by Prospector are "And", "Or", and "And Not". These conditions are accessed by clicking on the respective button in the Join Conditions box. The chosen join condition will appear in the Filter box after your first filter. Repeat steps 3, 4, and 5 to build another comparison which will appear in the Filter box after the join condition.ì&€€Š R€‚‚‚‚ÿ7. Aft¼dÒgWer you have specified the Filter to be applied to the input file records, click the "Ok" button and you are returned to the main Prospector window.Choosing the Filter/Define menu item allows you to view an existing filter. !!!!ÿÿÿÿÿÿÿÿ!!!!åÿÿÿÿÿÿÿÿ Û! 02€€Š R€€‚‚‚€€‚‚ÿSAMPLE RECORDSSampling Records from the Input FileAs well as filtering records processed from the input file by field comparisons, Prospector allows you to filter based upon record number. A specific aspect of filtering by record number is "sampling". This consists of allowing every nth record to pass through the filter. Sampling can be useful when you wish to run Integrity checks just to get a feel for the input file, but don't want to process every record.¦u ¦14€€Š R€‚€€€‚‚ƒ‚‚ÿTo Sample Records from the Input File for Integrity Checks or Export:1.Choose the Filter/Define menu item.‘i¦‘("€€Š XR‘€s€ƒ‚ÿ2.You will notice the Starting Record, Last Record, and Sample Rate value boxes in the leftmost portion of the Filter Define dialog box. Record one of the input file is the default Starting Record. The number of records in the input file is the default Last Record. Default Sample Rate is one. Keeping all of the default values will result in processing all records from the input file. Set the Starting and Last Record values where you wish input records to begin and end processing. The help topic "Partial Input File Processing" will provide information about setting the Starting and Last Record values.&‘&#€€Š R€‚ÿ,&,("€€Š XR‘€s€ƒ‚ÿ3.Fill in the Sample Rate value with a number X. Every Nth record will be allowed through the sampling filter. For example, if you have chosen 10 for the Sample Rate, every 10th record will be allowed to pass through the filter (i.e. 1, 11, 21, 31, ...).$,0$€€Š R€‚‚ÿAfter you have specišnÆoified which record numbers from the input file will be allowed through the filter, you can also specify further filtering by field comparisons. See the help topic FILTER/DEFINE for more information on filtering by field comparisons.!0!!!ÿÿÿÿÿÿÿÿ!!!!‰ ÿÿÿÿÿÿÿÿg7!g02€€Š R€€‚‚‚€€‚‚ÿSAMPLE PARTIAL INPUT FILEPartial Input File ProcessingIntegrity checking and transfer of records during Export to the output file can process all of the input file records or just selected records. The input records processed during Export or Integrity Checking are determined by the Filter setting. Prospector filters screen input records by field contents or record number. Since filtering by record number can be done in conjunction with filtering by field comparisons, the amount of data processed from the input file can be controlled quite easily. Vg7@€€Š R€‚€€‚‚‚€€‚‚ƒ‚‚ÿLarge File Integrity TestsIt is advised that you do a partial Integrity test when using large input files before you do an actual Integrity test on the entire file. This gives you a chance to check that your filtering and fields selected for checking are correct.To Filter by Record Number1.Choose the Filter/Define menu item.FF("€€Š XR‘€s€ƒ‚ÿ2.The Filter Define dialog box will be shown on the screen. You will notice the Starting Record, Last Record, and Sample Rate value boxes in the left side of the Filter Define dialog box. Keeping all of the default values will result in processing all records from the input file.&F&#€€Š R€‚ÿ8&8("€€Š XR‘€s€ƒ‚ÿ3.Set the Starting Record value. This value is the first record Prospector will retrieve from the input file for processing. Record one of the input file is the default Starting Record. You may set the Starting Record value to any existing input file record number.&8<#€€Š R€‚ÿXXXXXXXXXXÐw xqèÀ<è("€€Š XR‘€s€ƒ‚ÿ4.Set the Last Record value. This value is the last record Prospector will retrieve from the input file for processing. The number of the last record in the input file is the default Last Record. You may set the Last Record to any existing input file record number greater than or equal to the Starting Record value. Of course, setting it equal to the Starting Record value means that only one record from the input file would be processed.&è&#€€Š R€‚ÿÉ¡&É("€€Š XR‘€s€ƒ‚ÿ5.Set the Sample Rate. The default Sample Rate is one. For more information concerning Sample Rates, see help topic "Sampling Records from the Input File".›uÉ›&€€Š R€‚‚‚‚ÿAfter you have specified which record numbers from the input file will be allowed through the filter, you can also specify further filtering by field comparisons. See the help topic "FILTER/DEFINE" for more information on filtering by field comparisons.Filtering by record number gives the user the ability to do partial downloads. This can be necessary when processing large tape files. For example, records in positions 1 through 1000 from the input file could be processed during the first Prospector session, then offloaded from the hard drive to create space for processing the remaining records in the input file. "þ›"$€€Š R€‚‚ÿHealthy portions of corrupt data files can be recovered by filtering by record number. Set the Starting and Last Record fields in the Filter Define dialog box to recover the uncorrupted input file data in chunks, through several Prospector sessions.!"!!!ÿÿÿÿÿÿÿÿ!!!!‹ÿÿÿÿÿÿÿÿ"å!.=L€€Š R€‚‚€‚€€‚‚‚‚‚€€‚‚ƒ‚ÿFILTER/CLEARClearing the Filter ConditionThe Filter/Clear command allows you to clear a previously defined filter. This command can be utilized to clear a previously defined filter before performing integrity checks Á~â~Á~or exporting the output file.You have the option of clearing all or part of a compound filter. See help topic "FILTER/DEFINE" for more information on simple and compound filters.To Clear Part of a Compound Filter1.Choose the Filter/Clear menu item.&.&#€€Š R€‚ÿÕ­&Õ("€€Š XR‘€s€ƒ‚ÿ2.The Filter Clear dialog box will appear with the filter conditions displayed in the Filter listbox. Select the part of the filter you wish to clear by clicking on it.&Õ&#€€Š R€‚ÿÛ³&Û("€€Š XR‘€s€ƒ‚ÿ3.Click on the Clear Filter button. You will be asked to verify the clearing operation. Click on "Yes" to clear. The portion of the filter you have selected will be cleared.wHÛw/0€€Š R€‚‚€€‚‚ƒ‚‚ÿTo Clear an Entire Filter1.Choose the Filter/Clear menu item.ŒdwŒ("€€Š XR‘€s€ƒ‚ÿ2.The filter conditions will be displayed in the Filter listbox. Click on the Clear All button.&Œ&#€€Š R€‚ÿµ&µ("€€Š XR‘€s€ƒ‚ÿ3.You will be given the opportunity to change your mind. Click on "Yes" to clear, or "No" if you do not wish to clear all of the filter.b=µb%€€Š R€‚ƒ‚ÿ4.To return to the Prospector main window click on "Ok".!b!!!ÿÿÿÿÿÿÿÿ!!!!™ ÿÿÿÿÿÿÿÿ Õ! 8B€€Š R€€‚‚‚€€‚‚‚€€‚ÿINTEGRITYValue TotallingThe Integrity/Value Totalling command allows you to total a numeric field throughout the input file. The Average Value, Total Positive Values, Total Negative Values, Zero Values, Positive Count, and Negative Count are also reported. See help topic "Value Totalling Results" for specifics. This command only works on fields which have been selected and therefore appear in the Output Record Display.To Select fields for Totalling[5 q&€€Š R€‚ƒ‚‚ÿ1.Choose the Integrity/Value Totalling command.XXXXXXXXXX›‡ ˆm…ðq%€€Š R‘€€‚ÿNotice that your cursor will contain the letters "VAL" to indicate that you are in the Value Totalling mode. The All Fields dialog box will appear and prompt you as to whether you wish to total all numeric fields or just selected fields.M'M&€€Š R€‚ƒ‚‚ÿ2.Click the "Yes" or "No" button.§M§("€€Š XR‘€s€ƒ‚ÿ3.If "No", notice that all fields not classified as value fields by Prospector will be grayed in the Output Record Display.&§&#€€Š R€‚ÿéÁ&é("€€Š XR‘€s€ƒ‚ÿ4.Move the cursor to the desired fields in the Output Record Display and click the mouse button. The Integrity Field Selection dialog box will appear and indicate the selected field's name.&é&#€€Š R€‚ÿ”l&”("€€Š XR‘€s€ƒ‚ÿ5.If the indicated field is the correct one, click the "Ok" button, otherwise click the "Cancel" button.Û«”Û02€€Š R€‚€€‚‚‚€‚ÿSelected FieldsAll selected fields for Integrity checking will be displayed in reverse video in the Output Record Display. If a field has been selected for Integrity checking by mistake, it is possible to turn off the checking by clicking the cursor on the field.Note: It is possible to select fields for value totalling which are not presently classified as value fields. This will effectively change the class of the field to value. (See the View/Information help topic for more on classes). Prospector will ask you to confirm that you wish to change the assigned class. You can also change the field's class back to the original class by selecting it for IntegrityM'ÛM&€€Š R€€‚ÿchecking under it's original class.!M!!!ÿÿÿÿÿÿÿÿ!!!!Å ÿÿÿÿÿÿÿÿ1!=02€€Š R€€‚‚‚€€‚‚ÿINTEGRITYSequence CheckingThe Integrity/Sequence Checking command gives you the ability to analyze a field classified as an ID f'H'ield. Sequence checking analyzes ID fields to determine if the input file is sorted in ascending or descending order by the field specified and whether there are gaps or duplicate entries in the sequence. See help topic "Sequence Checking Results" for specifics. This command only works on fields which have been selected and therefore appear in the Output Record Display.a=..€€Š R€‚€€‚‚ƒ‚‚ÿTo Select Fields for Sequence Checking1.Choose the Integrity/Sequence Checking command.ò%€€Š R‘€€‚ÿNotice that your cursor will contain the letters "ID" to indicate that you are in the Sequence Checking mode. The All Fields dialog box will appear and prompt you as to whether you wish to validate all date fields or just selected fields.M'M&€€Š R€‚ƒ‚‚ÿ2.Click the "Yes" or "No" button.¤|M¤("€€Š XR‘€s€ƒ‚ÿ3.If "No", notice that all fields not classified as ID fields by Prospector will be grayed in the Output Record Display.&¤&#€€Š R€‚ÿêÂ&ê("€€Š XR‘€s€ƒ‚ÿ4.Move the cursor to the desired fields in the Output Record Display and click the mouse button. The Integrity Field Selection dialog box will appear and indicate the selected field's name.&ê&#€€Š R€‚ÿ”l&”("€€Š XR‘€s€ƒ‚ÿ5.If the indicated field is the correct one, click the "Ok" button, otherwise click the "Cancel" button.úÊ”02€€Š R€‚€€‚‚‚€‚ÿSelected FieldsAll selected fields for Integrity checking will be displayed in reverse video in the Output Record Display. If a field has been selected for Integrity checking by mistake, it is possible to turn off the checking by clicking the cursor on the field.Note: It is possible to select fields for Sequence Checking which are not presently classified as ID fields. This will effectively change the class of the field to ID. (See the View/Information help topic for more onR•æ•' classes). Prospector will ask you to confirm that you wish to change the assigned class. You can also change the field's class back to the original class by selecting it for Integrity checking under it's original class.!!!!ÿÿÿÿÿÿÿÿ!!!!Ó ÿÿÿÿÿÿÿÿì!02€€Š R€€‚‚‚€€‚‚ÿINTEGRITYDate ValidationThe Integrity/Date Validation command gives you the ability to analyze a field classified as a date field and determine if all records contain a valid date. Date Validation tests report on earliest and latest dates in the field, as well as number of invalid dates, and number of zero dates. See help topic "Data Validation Results" for specifics. This command only works on fields which have been selected and therefore appear in the Output Record Display.‹]‹..€€Š R€‚€€‚‚ƒ‚‚ÿTo Select Fields for Date Validation1.Choose the Integrity/Date Validation command.ò‹%€€Š R‘€€‚ÿNotice that your cursor will contain the letters "DATE" to indicate that you are in the Date Validation mode. The All Fields dialog box will appear and prompt you as to whether you wish to validate all date fields or just selected fields.M'M&€€Š R€‚ƒ‚‚ÿ2.Click the "Yes" or "No" button.¦~M¦("€€Š XR‘€s€ƒ‚ÿ3.If "No", notice that all fields not classified as date fields by Prospector will be grayed in the Output Record Display.&¦&#€€Š R€‚ÿêÂ&ê("€€Š XR‘€s€ƒ‚ÿ4.Move the cursor to the desired fields in the Output Record Display and click the mouse button. The Integrity Field Selection dialog box will appear and indicate the selected field's name.&ê&#€€Š R€‚ÿ˜p&˜("€€Š XR‘€s€ƒ‚ÿ5.If the indicated field is the correct one, click the "Ok" button, otherwise click the "Cancel" button.Ù©˜å02€€Š R€‚€€‚‚‚€‚ÿSelected FieldsAll selected fiŸ­Ÿ ™elds for Integrity checking will be displayed in reverse video in the Output Record Display. If a field has been selected for Integrity checking by mistake, it is possible to turn off the checking by clicking the cursor on the field.Note: It is possible to select fields for date validation which are not presently classified as date fields. This will effectively change the class of the field to date. (See the View/Information help topic for more on classes). Prospector will ask you to confirm that you wish to change the assigned class. You can also change the field's class back to the original class by selecting it for IntegrityN(åN&€€Š R€€‚ÿchecking under it's original class.!N!!!ÿÿÿÿÿÿÿÿ!!!! ÿÿÿÿÿÿÿÿJ!J<J€€Š R€€‚‚‚€€‚‚‚€€‚‚ƒ‚‚ÿINTEGRITYGoThe Integrity/Go command begins the Integrity tests. You begin Integrity tests after you have selected the desired fields for Integrity Checking and specified any necessary filters.To Begin Integrity Testing1.Choose the Integrity/Go command.uJ("€€Š XR‘€s€ƒ‚ÿ2.The Perform Integrity Test dialog box will appear. Click on the Defaults button to review the error threshold.&&#€€Š R€‚ÿP(&P("€€Š XR‘€s€ƒ‚ÿ3.The Integrity Error Threshold dialog box will appear, displaying the current error threshold setting. Integrity processing halts when the error threshold has been exceeded. Make sure the error threshold is set correctly, then click "OK" to return to the Perform Integrity Test dialog box.d?Pd%€€Š R€‚ƒ‚ÿ 4.To begin the Integrity tests, click the "Start" button.8dD%€€Š R‘€€‚ÿNotice the Record #, Percentage Complete, and Error Count status boxes changing as the specified fields from the input data file are tested. The Record # indicates the number of the record from the input file being processed. The Percentage Comp¦ã¦£lete indicates how much of the input file has already been processed. The Error Count is incremented each time an invalid field is encountered. If the error threshold is exceeded you will be given an opportunity to increase the threshold and continue or cancel the integrity run.&D&#€€Š R€‚ÿ÷Ï&÷("€€Š XR‘€s€ƒ‚ÿ5.When the integrity test is complete, click the "Continue" button to see the Integrity test results, or click "Cancel" to return to the Prospector main window without viewing the Integrity results. —l÷—+(€€Š R€‚€€‚‚ÿIntegrity ResultsDepending on the Integrity tests you choose to perform, Prospector will present you with the appropriate Integrity Results reports. See help topic "Integrity Results" for information about the Integrity results displayed to the screen. These results are not saved. Exiting Prospector will destroy the results. Rerunning Integrity Checking will overwrite former results. Once an integrity run is complete it is possible to return, change the fields to be tested, change the filter if desired, and make another integrity pass through the file. This can be repeated as many times as necessary.A—A*&€€Š R€‚ᄉ‚ÿIntegrity Results!A!!!ÿÿÿÿÿÿÿÿ!!!!ÈÿÿÿÿÿÿÿÿÛ«!ç02€€Š R€€‚‚‚€€‚‚ÿINTEGRITYIntegrity ResultsThere are three types of Integrity results reports; Value Totalling, Sequence Checking, and Date Validation. A report of the appropriate type will be displayed for each field checked in Integrity testing. You can access Value Totalling, Sequence Checking, and Data validation result reports from within the reports displayed on your screen by clicking on the desired button at the bottom left of the report being displayed. You access individual field reports from within a displayed report by first getting to the appropriate report type (Value, Sequence, Date), then clicking on the prev=­^­=­ious or next buttons at the bottom right of the report.ÀçÀ#€€Š R€‚ÿSee help topics "Value Totalling Results", "Date Validation Results", and "Sequence Checking Results" for specific information pertaining to the reports. !À!!!ÿÿÿÿÿÿÿÿ!!!!Pÿÿÿÿÿÿÿÿ À! Ml€€Š R€€‚‚‚€€‚‚‚€ƒƒƒ‚€‚ƒƒƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚ƒƒ‚ÿVALUE TOTALLINGTotalling ResultsThe results of a Value Totalling Integrity test for a field are displayed on screen after Integrity testing has completed. The following information is shown:ITEMDESCRIPTIONNameName of field testedNumber CheckedNumber of records checkedNumber InvalidNumber of invalid records found Total ValueTotal value of all records checkedTotal PositiveTotal positive value of records checked"ó "/0€€Š R€ƒƒ‚ƒƒ‚ƒƒ‚ƒ‚ƒ‚ÿTotal NegativeTotal negative value of records checkedAverage ValueAverage Value of all records checkedNumber ZeroNumber of records with zero valueNumber PositiveNumber of positive recordsNumber NegativeNumber of negative records!"!!!ÿÿÿÿÿÿÿÿ!!!!lÿÿÿÿÿÿÿÿ Û! 02€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚‚‚ÿ Sequence Checking Results ************************* The results of a Sequence Checking Integrity test for a field are displayed on screen after Integritytesting has completed. The following informationis shown:ITEM DESCRIPTION ---- -----------Name Name of field testedNumber Checked Number of records checkedNumber Invalid Number of invalid records found Sequence Type of sequence in fieldÚ ..€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚ÿGap Number of gaps in sequenceDuplicates Number of consecutive duplicate valuesThe type of sequence can be ascending, descending, orunordered (no sequence detected).A gap is only relevant if the field is sequenced.The gap count increments each time¸´ö—´ the expectedfield value is not found. For example, if the field being analyzed is check numbers which should be in ascending order, the followingfield entries will result in a gap count of three:,ù,38€€Š R€‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚ÿ 323 324 326 327 328 329 332 333 335The Duplicate analysis is also only relevant if thefield is sequenced. The duplicate count is incrementedeach time a duplicate field value is encountered.!,!!!ÿÿÿÿÿÿÿÿ!!!!kÿÿÿÿÿÿÿÿ¸!Id€€Š R€€‚‚‚€€‚‚‚€‚‚€ƒƒƒ‚ƒ‚ƒƒ‚ƒƒƒ‚ƒƒ‚ÿINTEGRITYDate Validation ResultsThe results of a Date Validation Integrity test for a field are displayed on screen after Integrity testing has completed. The following information is shown:ITEM DESCRIPTION NameName of field testedNumber CheckedNumber of records checkedInvalid DateNumber of invalid datesZero DatesNumber of dates equal to zeroEarliest DateEarliest date in fieldI$I%€€Š R€ƒƒ‚ÿLatest DateLatest date in field!I!!!ÿÿÿÿÿÿÿÿ!!!!…ÿÿÿÿÿÿÿÿwF!w14€€Š R€€‚‚€€‚‚‚‚ÿINTEGRITY/PRINTPrinting Integrity ResultsThe Integrity/Print command provides you with the ability to obtain a printed copy of your Integrity test results. To print a copy of your results, select Print from the Integrity drop-down menu. Your results are output to the printer specified during your Windows setup. It is important that you choose to print Integrity results before running another Integrity test, as the results are overwritten by subsequent tests. Integrity test results are not saved, so the cannot be accessed again during another Prospector session.á¸wí)$€€Š R€‚€€ÿNOTE: Prospector turns control over to the Windows print spooler when reports are printed. Be sure you have your printer configured properѼH¿°¼ly before attempting to print reports. !í!!!ÿÿÿÿÿÿÿÿ!!!!® ÿÿÿÿÿÿÿÿç¯!ç8B€€Š R€€‚‚‚€€‚‚‚€€‚ÿEXPORTCreating the Output FileThe "Export" feature of Prospector allows input file data to be transferred to several different output formats.USER SPECIFIED FILEëç%€€Š R‘€€‚ÿThis output method will save data to the output file with all of the individual output field formats preserved. The output file extension is ".RAW". See help topic "EXPORT/USER DEFINED FILE" for more information about this method.5 5*&€€Š R€‚€€‚ÿASCII¼—5¼%€€Š R‘€€‚ÿFor use by any application which handles ASCII data. Records are terminated with carriage returns and line feeds. Output file extension is ".ASC".6 ¼6*&€€Š R€‚€€‚ÿCSV õÐ6õ%€€Š R‘€€‚ÿComma Separated Value. This is also an ASCII format, with a comma following every field, text enclosed in quotes, carriage return and line feed at the end of each record. Output file extension is ".CSV".9õ9*&€€Š R€‚€€‚ÿSuperCalcmH9m%€€Š R‘€€‚ÿFor use by SuperCalc4 or SuperCalc5. Output file extension is ".CAL".6 m6*&€€Š R€‚€€‚ÿdBase 464%€€Š R‘€€‚ÿWrites a dBaseIII+ file which dBaseIV can read. Output file extension is ".DBF". Programs which can use .DBF files include Excel for OS/2, Windows, and Macintosh, Lotus 1-2-3, Lucid 3-D 2.2, PlanPerfect 5.0, ProQube 1.03, Quattro Pro 1.0, SuperCalc, Full Impact 1.1, I4I+(€€Š R€‚‚€€‚ÿ Lotus 1-2-3_:Ik%€€Š R‘€€‚ÿFor use by Lotus 1-2-3 version 1 and above. Output file extension is ".WKS". Programs which can use .WKS files include Excel, Lucid 3-D 2.2, PlanPerfect 5.0, ProQube 1.03 ,Quattro Pro 1.0, SmartWare Spreadsheet 1.0, SuperCalc, Symphony, 20/20 vešÆãÆVÀrsion 2.33.11, Twin Level III 3.03, Full Impact 1.1, WingZ 1.1, M#kM*&€€Š R€‚€€‚ÿDIF - Data Interchange FormatiCMi&€€Š R‘€€‚‚ÿA standard method for exchanging data between non-compatible programs. Output file extension is ".DIF". Programs which use DIF include Excel for OS/2 and Windows, Macintosh Excel 2.20, PlanPerfect 5.0, ProQube 1.03, SmartWare Spreadsheet 1.0, SuperCalc, Symphony, 20/20 version 2.33.11, Twin Level III 3.03, WingZ 1.1!i!!4ÿÿÿÿÿÿÿÿÞ!9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿEXPORTUser Specified FileProspector allows you to create your own record format for export. The output record will be created with all of the individual output field formats preserved. ASCII or EBCDICThe Options/Toggle Output Type menu item enables you to specify whether the character data in your output record will be EBCDIC or ASCII. The current output File Type is displayed on the right side of the Prospector main window above the Output Record Display. Ü ..€€Š R€‚‚‚‚€€‚‚ÿNumerical data will be transferred to the output record as specified for each field. The View/Information menu item allows you to see and change the numerical field types.To Create a User Specified Output File¶Ž ¶("€€Š XR‘€s€ƒ‚ÿ1.Ensure that the necessary fields are selected from the Input Record Display for the Output Record Display, and are in the correct order.&¶&#€€Š R€‚ÿ–n&–("€€Š XR‘€s€ƒ‚ÿ2.Use View/Field Information to check that the field types are as desired for all of the numeric fields. &–&#€€Š R€‚ÿß·&ß("€€Š XR‘€s€ƒ‚ÿ3.Check the output type for the character data fields. Use the Options/Toggle Output Type menu item to change between EBCDIC and ASCII character data fields in the output record.&ß&#€€Š R€‚ÿ^6&j("€€Š X½ÏãÏÊR‘€s€ƒ‚ÿ4.Build any filters needed for the Export process.&j&#€€Š R€‚ÿÅ&Å("€€Š XR‘€s€ƒ‚ÿ5.Select the Export/User Specified File menu item. Make sure the file name for the output file is correct. The default extension for User Defined Files is ".RAW". You may change the filename for the output file by re-entering the new name in the edit box. Click on the "Export" button to begin the transfer of data from the input file to the output file. Click "Cancel" if you do not wish to Export data.!Å!!!ÿÿÿÿÿÿÿÿ!!!!ÿÿÿÿÿÿÿÿ+ø!+38€€Š R€‚‚€‚€€‚‚‚‚‚ÿOPTIONS/TOGGLE HEXDisplaying Hex DataWhen the input record is initially displayed (following a File/New or File/Open), the Input Record Display contains two rows of data. The upper row contains the actual hexidecimal data from the input file. The lower row shows the translation of the data using the present field type. The example below illustrates the translation for an ASCII character data field.Hex data -> 44 6F 65 2C 20 4A 6F 68 6ETranslation -> D o e , J o h nɦ+É#€€Š R€‚ÿSelecting the Options/Toggle Hex menu item when the Input Record Display contains the hexidecimal data modifies the display to contain only the translated data, eliminating the hex representations and the extra space they require. This results in the display of more input record data on the screen. To return to the display which includes hex, select the Options/Toggle Hex menu item again and the hex will reappear.!É!!!ÿÿÿÿÿÿÿÿ!!!!WÿÿÿÿÿÿÿÿM!Y02€€Š R€‚‚€‚€€‚‚ÿOPTIONS/TOGGLE INPUT TYPEInput ASCII/EBCDICData Interpretation performs an analysis of the input data to determine the File Type (the character data is ASCII or EBCDIC). You are able to change the translation of the data by selecting the Options/Toggle Input Type menu item. ThiÖ°ÖÖs option allows you to specify whether the input file type is ASCII or EBCDIC. As the input file type is toggled, the display of the input record will change. When the text and possibly some of the numerics are readable, the file type is correct. ݹYÝ$€€Š R€‚‚ÿTo toggle the input type, click on the Options menu item, then click on Toggle Input Type. The input File Type is displayed in the upper right corner of the Prospector main window.!Ý!!!ÿÿÿÿÿÿÿÿ!!!!"ÿÿÿÿÿÿÿÿÏ!26€€Š R€‚€‚‚€€‚‚‚‚ÿOPTIONS/TOGGLE OUTPUT TYPEOutput Type ASCII/EBCDICThe Options/Toggle Output Type menu item allows the character data type to be specified for User Defined File Exports. The current output type is indicated in the right side of the Prospector main window, just above the Output Record Display.To change the output type between ASCII and EBCDIC, select the Options/Toggle Output Type menu item. The current output type display will change accordingly.!!!!ÿÿÿÿÿÿÿÿ!!!!Sÿÿÿÿÿÿÿÿ­t!­9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿOPTIONSDisplay Single Or Multiple RecordsWhen Prospector displays the complete main window, (following a File/New or File/Open), the Input Record Display is in the default display mode (i.e. a single record displayed as its hexidecimal and translated forms). For most operations, this display should be sufficient.To View Additional Rows of Input DataIf the display of more than one record is desired, you may select Options/Multiple Record Display to display the translations of the following four records below the already visible record. These four additional records will not have their hex data displayed.yN­…+(€€Š R€‚€€‚‚ÿMemory RequirementDue to the amount of additional memory which is required to display the four additional records, returning to the Single Record Display may be necessary when performikÜßJÜng memory intensive functions such as integrity checking and exporting files. This is accomplished by selecting Options/Single Record Display.!…!!!ÿÿÿÿÿÿÿÿ!!!! ÿÿÿÿÿÿÿÿ Ú! 26€€Š R€‚€‚‚€€‚‚‚‚ÿOPTIONSGoTo RecordThe Prospector Input Record Display contains vertical scroll bars on the right side to allow scrolling through the records in a file. The Output Record Display is automatically updated to reflect the new record which is displayed in the Input Record Display.To facilitate moving to records which would require too much time to scroll, the Options/Goto Record command permits moving to and displaying a specific input file record very quickly. vG v/0€€Š R€‚‚€€‚‚ƒ‚‚ÿTo go to a certain record number1.Select Options/Goto Record}Xv}%€€Š R‘€€‚ÿA dialog box will appear requesting the number of the record you wish to see displayed in the Input Record Display (and the Output Record Display if any fields have been selected). Enter the record number and press enter or click the "OK" button. The dialog box will be removed and the display will be updated to show the requested record.!}!!!ÿÿÿÿÿÿÿÿ!!!!%ÿÿÿÿÿÿÿÿø¾!:F€€Š R€€‚‚‚€€‚‚‚‚€€‚‚ÿOPTIONSDetermining Input File Header LengthsProspector assumes that there is not a header on the input file until you tell it otherwise. If you have successfully interpreted the input file only to discover that the Input Record Display appears messed up, chances are there is a header on the input file. In order for the Input Record Display to show record one, Prospector must know the header length and skip over it.Header Length ModeYou can determine the header length by typing CTRL-L, which places you into a mode where the up and down arrow keys can be used to slide the beginning of record one past the header. You will know you have passed the header wheÿä åÿän your Input Record Display fields appear as understandable data. Note the header length displayed in the upper right corner of the main window under the Input File Type. Now use the Options/Set Header Length menu item to inform Prospector of the header's existence and length.!!!!ÿÿÿÿÿÿÿÿ!!!!"ÿÿÿÿÿÿÿÿZ*!Z02€€Š R€€‚‚‚€€‚‚ÿOPTIONSSet Header LengthThis menu item allows the length of the input file header to be specified. It is important that the header length be known by Prospector in order for the Input Record Display to present the first and subsequent records correctly. Other Prospector functions also need to know the header length in order to process correctly. Prospector assumes there is no input file header until you tell it otherwise. To determine what the input file header length might be, see help topic "Determining Input File Header Lengths". `5Z`+(€€Š R€‚€€‚‚ÿTo specify the header length of the input file]5`]("€€Š XR‘€s€ƒ‚ÿ1.Select the Options/Set Header Length menu item.&]&#€€Š R€‚ÿ“k&“("€€Š XR‘€s€ƒ‚ÿ2.Key in the length of the header as requested, then click the "OK" button to accept the header length.&“&#€€Š R€‚ÿŠb&Š("€€Š XR‘€s€ƒ‚ÿ3.The header length will be specified in the Prospector main window under the Input File Type.]Š$€€Š R€‚‚ÿYou can specify 0 as the header length to indicate that no input file header is present. !!!!ÿÿÿÿÿÿÿÿ!!!!0ÿÿÿÿÿÿÿÿ1ù!=8B€€Š R€€‚‚‚€€‚‚‚€€‚ÿOPTIONSAdjust Header LengthThis menu item allows the length of the input file header to be visually adjusted. It is important that the exact header length be known by Prospector in order for the Input Record Display to present the first and subsequent records correctly. Other ˆî©îˆîProspector functions also need to know the header length in order to process correctly. Prospector assumes there is no input file header until you tell it otherwise.To adjust the header length of the input file&=&#€€Š R€‚ÿ„\&„("€€Š XR‘€s€ƒ‚ÿ1.Select the Options/Adjust Header Length menu item (or use the Ctrl+L accelerator key).&„&#€€Š R€‚ÿQ)&Q("€€Š XR‘€s€ƒ‚ÿ2.Use the 'Up' and 'Down' cursor keys to respectively increase or decrease the header length in one byte increments. By viewing the data with the Multiple Record Display, it is possible to visually identify when the header length is correct because the data fields will not appear corrupted.&Q&#€€Š R€‚ÿ‹c&‹("€€Š XR‘€s€ƒ‚ÿ3.The header length will be specified in the Prospector main window under the Input File Type.!‹!!!ÿÿÿÿÿÿÿÿ!!!!ýÿÿÿÿÿÿÿÿãª!ã9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿOPTIONSSet Record LengthThis menu item allows the record length of the input file to be specified. It is important that the record length be correctly specified to Prospector in order for the Input Record Display to properly align the data fields in all records. Other Prospector functions also need to know the record length in order to process the data correctly.To Reset the Record Length of the Input File€Xã€("€€Š XR‘€s€ƒ‚ÿ1.Select the Options/Set Record Length menu item (or use the Alt+R accelerator key).&€&#€€Š R€‚ÿ“k&“("€€Š XR‘€s€ƒ‚ÿ2.Key in the length of the record as requested, then click the "OK" button to accept the record length.&“&#€€Š R€‚ÿtL&t("€€Š XR‘€s€ƒ‚ÿ3.The new record length will be specified in the Prospector main window.&t&#€€Š R€‚ÿ!&6!*ÿÿÿÿÿÿÿÿXXXXXXXXXÖ÷ ø ø!6!!“ÿÿÿÿÿÿÿÿØŸ!Ø9D€€Š R€€‚‚‚€€‚‚‚€€‚‚ÿOPTIONSAdjust Record LengthThis menu item allows the record length of the input file to be visually adjusted. It is important that the exact record length be known by Prospector in order for the Input Record Display to align the data fields correctly. Other Prospector functions also need to know the record length in order to process the data properly.To Adjust the Record Length of the Input File„\Ø„("€€Š XR‘€s€ƒ‚ÿ1.Select the Options/Adjust Record Length menu item (or use the Ctrl+R accelerator key).&„&#€€Š R€‚ÿP(&P("€€Š XR‘€s€ƒ‚ÿ2.Use the 'Up' and 'Down' cursor keys to respectively increase or decrease the record length in one byte increments. By viewing the data with the Multiple Record Display, it is possible to visually identify when the record length is correct because the data fields will not appear corrupted.&P&#€€Š R€‚ÿzR&z("€€Š XR‘€s€ƒ‚ÿ3.The adjusted record length will be specified in the Prospector main window.!z!!!ÿÿÿÿÿÿÿÿ!!!!Õÿÿÿÿÿÿÿÿ´r!´BV€€Š R€€‚‚‚‚‚‚‚ᧉ‚ᨉ‚ᩉ‚‚ÿOPTIONSThe Options/Update Parameters menu item allows the user to change the configuration of Data Ranger.To change the following parameters, click on the Options/Update Parameters menu item. A dialog box will be displayed which shows the current settings of the following parmeters:Generate Tech FilesDefault Data DirectoryInterpretation Parameters!´!!!ÿÿÿÿÿÿÿÿ!!!!8ÿÿÿÿÿÿÿÿåº!ñ+(€€Š R€‚€€‚‚ÿGenerate Tech FilesThere is an option to generate tech files while Prospector is running. These files are used for technical support. There is no need to generate these files unless a problem during a Prospector session is encountered. If a probl¶þ×þ¶þem is encountered during a Prospector session, Click on the Options/Update Parameters menu item, then Click on Yes to generate the technical files. Rerun the session up until the point the problem occurs in order to generate the tech files, then call Flagstaff Engineering technical support. Their engineers will use the additional information contained in these files to determine what is happening during the session and solve the problem.&ñ&#€€Š R€‚ÿ!&!!*ÿÿÿÿÿÿÿÿ Þ! +(€€Š R€‚€€‚‚ÿDefault Data DirectoryThe Default Data Directory is where input data files are located when Prospector is run against PC Disk files. The Default Data Directory can be changed from the Options/Update Parameters immediately after bringing up Prospector in cases where the input data file resides in another directory. If the Default Data Directory does not exist, Prospector will not initially list any files in the Dos Filenames list for File/New or File/Open sessions.! !!€ÿÿÿÿÿÿÿÿ_3!_,*€€Š R€‚€€‚‚‚ÿInterpretation ParametersClick on "Interpretation Parameters" to view (and modify) the parameters used for Automatic Data Interpretation.Click on "OK" to accept changes in the Update Parameters dialog box and continue with the Prospector session. Click on "Cancel" to retain the present parameters.!_!!Hÿÿÿÿÿÿÿÿï½!ï26€€Š R€‚‚€‚€€‚‚‚‚ÿOPTIONS/UPDATE PARAMETERSTape ParametersThe Options/Update Parameters menu item allows the user to change the configuration of Prospector. To change the 9-track tape parameters, click on the Options/Update Parameters menu item. A dialog box will be displayed from which you should click on "Tape Parameters". These parameters are ignored if a tape drive is not present. You may then alter the settings of the following parameters:(ï(%€€Š R‘€€‚ÿ9 (E02€€Š R€€‚‚‚€€‚‚ÿ¨Ð˜Tape Unit #The Unit # should indicate the address of the tape drive being used. Valid tape unit numbers are 0 - 7. Maximum BufferThe Maximum Buffer (K) shows the maximum size, in kilobytes, of the buffer allocated to store data read from the tape. The default value is 128k. The size of the tape buffer is important in terms of performance, so this value should be set as high as possible. If the memory is not available for the buffer size you specify, Prospector will automatically decrease the size of the tape buffer. If you notice Prospector doing a lot of disk accesses when you are running the View commands, you should exit the session, save your files, start a new session and decrease the Maximum Buffer size BEFORE you choose the FILE/OPEN menu item.ËŽEË=L€€Š R€‚€€‚‚‚€€‚‚‚€€‚‚ÿRetriesWhen an error occurs during a read or write operation, the drive will repeat the operation until it is successful or the indicated number of retries is exceeded. Setting this value higher may allow successful use of a marginal tape.Tape SpeedSome tape drives allow the user to indicate the speed at which the drive operates. On such drives, setting the speed to high will allow quicker processing.Tape DensityTape drives which have only two density settings allow the user to specify which setting is appropriate for the loaded tape. Other drives automatically determine the tape's density and should use the "Default" setting.!Ë!!!ÿÿÿÿÿÿÿÿ!!!!Lÿÿÿÿÿÿÿÿó¸!ÿ;H€€Š R€‚€‚‚€€‚‚‚‚‚€€‚‚ÿOPTIONS/UPDATE PARAMETERSInterpretationThe Options/Update Parameters menu item allows the user to change the configuration of Prospector. To change the Automatic Data Interpretation parameters, click on the Options/Update Parameters menu item. A dialog box will be displayed from which you should click on "Interpretation Parameters". You may then alter the settings of the following parameters:Data Inte"rpretation LevelThe level of intensity for Data Interpretation may be adjusted. Reducing the level will result in less processing and lower accuracy with a reduction in time required. Increasing the level will increase the time required, with greater accuracy resulting.,ïÿ,=L€€Š R€‚€€‚‚‚€€‚‚‚€€‚‚ÿRecord Length Search RangeThe shortest and longest record lengths indicated determine the range searched by Automatic Data Interpretation when the default "Unknown" is chosen (in the File Information dialog box which appears prior to actually running Data Interpretation).Header LengthIf data files are being used which consistently have the same length header, this may be set.Data Sample Starting LocationData Interpretation determines file characteristics by using a sample buffer for analysis. The sample's starting location can be adjusted. Often the sample's starting location is adjusted to begin at a point in the input data file which will bypass header information. By adjusting the sample's starting location, then rerunning the interpretation, files which failed to be analyzed properly at the first attempt (with the default settings) can be successfully interpreted. To change the sample's starting location, simply type the desired entries into the appropriate edit box.!,!!!ÿÿÿÿÿÿÿÿ!!!!ÿÿÿÿÿÿÿÿż @èd(­wz)U Ö ° +Lñ¨Éd#…#é( )J2k2:4:œ@½@èD EdK…KÝNþNÝUþU2XyX`^^ `-`3fñmnŽs¯sy"y}=}e†Á…â…'f‘‡‘G’h’w¡˜¡?®`®Lºmºë½ ¾Ì(̤ýÅý0QÕö¢Ã°ÑŠ'«'‘3²3™7º7º9Û9N>o>ÈCéC´HÕHÞL)MoWWðhiöpq ~Á~L…m…'ì˜ ™à¢£­=­±&±v´—´º$º¼°¼5ÀVÀÊ8ÒYÒnÖÖæÙÚ)ÜJÜà¾àÞäÿä$éEégîˆî¸óÙóÖ÷ øŸüÀü•þ¶þî˜à Mn}tHELV    /&;)i24s is not a vÿÿìÿÿÿÿINDEX~ ÿN‹^‹v &ÆŽÌ8&ƒ>”.tÿv ÿv ¸2/Pÿvÿvš¹ƒÄ ëV¸ÿ+FP¸PP¸6/PFúPšÿÿƒÄÇFøë ‹vøÆBú0ÿFø‹vø€zú tíÿv ÿv FúP¸uBÛãQ¹âþY3À£XÙ>XQ¹âþY&X?>X?uÝ>XQ¹âþY@÷X¿¸t3À¢ë hjjšÿÿ€>t ƒ>u è*%s¸þÿùÃjhè»h"šÿÿƒ>uèˆë€>ujhÈÅhš’ºèD¸2è]3À££¸Èǃ>t¸È£§ ˜Ãƒ>u舀>tÛãèå$Ãÿ6VšÿÿÀ>tÛã¡£3À:t›Û⣠£ã‰ù ¸45¿Í!@‰ŒEƒÇâóºìžuÅ¿XÅ€>t ºcÁ¾.Á¿[Á¸4%¹Í!@âû‹ÖÍ!@‹×Í!ù ¸4%¿ÅÍ!@ƒÇâôÃ3Ò€>t(ƒì‹Ü›6Ù7›6Ù/6‹GƒÄ¹‹ØÑèÑèƒãƒûtBâï¡+³ öóÂà˜Ã£¤Ã€€>t€ÌÀÃÏCëPUƒì‹ì›Ùv¸ä»‡F ‰FSÅ^‹(sކĉFëPUƒì‹ìÙv›ÛâûS.Ž0¹3ÀŠF2ÿƒ>¤u€ÏöÇu ¨t€Ï鄨téþöÇu ¨t€ÏèëÙöÇu ¨t€Ïéߊ€ËÀ€ãýöÓ"ètP‹F€ä=úuX €ë‹F%8=Xu4›Ûâ›Ùn [ƒÄ]©ÿ¿uXÃPS‹Ü6‹G6‰G[XƒÄéúVSQRW‹^‹N÷ÓŠÍ€á8ÐéÐéÓËöÇÀtR‹VòàöÂÀu ÷ u@öÂuöÂuë4€út€út ë'÷Âu €ç?‹6;6uè¨þƒÆ ‰6›Ùö›Û<éöÃtëJ‹VòàöÂÀt ÷Âuë5 ÛtèÀë+‹6;6u龀˛Ù÷›Û,‹6;6uè^þƒî ‰6öà uP‹óƒæð öt›Û>JÑëÑëèy›Û.JÑãÑã€Ëë-‹6;6t#€Ë ›Ù÷›Ù÷›Û,›Ùö‹6;6uè þƒî ‰6‹VòàöÂÀu ÷ uöÂuëFŠÊ€áºÄPÓâyñöà uìƒâÐâ‹Ê‹ÓÓÊöÂu$ëÑËÑË›Ù÷÷ÃtóÀÌÆF›Ùf_ZY[^égþ$þè_ZY[^éìý€Q‹N€áÀ€ùÀtm‹Ná8ƒùt ƒùt€á0ƒù0uTöÇÀt€ç?‹6;6uèGýƒÆ ‰6›Ùö›Û<‹NQáÁ‰NèÁè^Yƒá8€ùt€ùt.€ñÉÁ‰Nè›ë;‹Ná8ù(t á8ùtèè$ë€Ì@›Ûâ›ÙÉ›ØÑ›ÙÉ›ÝØ›Ý>› Y$ýé-ý›Û~›‹N÷Áÿt!öF€u›ßn›Û~›ƒ~t é>@N›ÛnÃ3ɉN‰N‰N‰N‰NëèP‹F%À€ô=ÀXsèéÕüöÄ@u\€Ì@WVQS›ÛâŒ×ƒ>t‹>V‹N‹Ù€å€ÍØ€ãÀ€óÀt €á8€ÉÅv †é‰~~‰~ÆF›‰NÆFËÿ^[Y^_›Ý>› ÃS³‹öÄu8³ŠöÄu1³ˆ¨€u+³‰öÄu$³¨u³ƒ¨u³„¨u³…¨u ³†¨ u³‡¨@u.Ž0¹¡ u“´LÍ!“[ÿXÏ£%<ÿ€>t£›Ù.£ áÃ3À:t ›Ý>› $? %ÿ£Ã% €>t ›Ù> ›‹ €åó Á£›Ù.›Ùü›Ù. Ë/&;)Lzstring identiÿÿéÿÿÿÿ Main Indexines file characteristics by using a sample buffer for analysis. The sample's starting location can be adjusted. Often the sample's starting location is adjusted to begin at a point in the input data file which will bypass header information. By adjusting the sample's starting location, then rerunning the interpretation, files which failed to be analyzed properly at the first attempt (with the default settings) can be successfully interpreted. To change the sample's starting location, simply type the desired entries into the appropriate edit box.‹ :?tC&Š< tø< tô‹ËKþÃt &€? uö&Æ‹Ù6‹ º&ƒ>\u&‹^ŒÀƒí‹å]MË3Àã‹ñPPQèã‹ÎèäܾðYËU‹ìVWŽF 3Û&‹w$&9w&uéËé»&‹<ƒÆ&ƒ<tî&‹L&ÇD¿c&ÇDûƒÆQ&‹D €&÷ €u5€&‰D¨@t‹N NãQƒÿrLÿvšÙ ûRš½û&‹3Ò‹ÏÑãÑÒâú+^VPPQRSšûIVRQš“`ûYPQšËûÿvšç ûÿZé%3À‹ÏÑâÑÐâú‹È¸B‹^ Í!VSSš“`ûŽF &‰DYƒÆ ItéZÿé>ÿ_^‹å] ‹Ü6‹G6‹W‹‡G‡WÊEU‹ìVW‹N ãŽÙŒØHŽÀ@&‹ Ût š8 ûŽÚ€O‹^ Ûušx û Òt¸ÿÿ‹ØK‡^+^÷Ûøšìû‹Ú_ Røšìû‹ÚZRS3À‹N;ÙrZZé¬+ÏšðûWó«_]$ÆE ÆE‰UÇEyhÇEûÇEeÇEÇE"LHøšìû‹ò‹^ƒë €ãü‰]‰>_Z‡ÚG‰‰‰_‰wÇG ‡Ú‡ÓG‡Ó‰‰u‰<‰\‰T‰\‹Ã+ƉD‰_D‰‰w‰_ÇG ‹‹G +G‰G šÙ û°‹È_^fþ]MÊWV‹>u"3À}"LHu‹u‹}‹};þt E- ‹}ëñ^_Ë‹‹G+GËËM/Øwbz¦aœXEU‹ìŽØÄ^&Š˜™ƒÒRPSÄ^ &Š˜ÃŒÂRPšƒ AIƒÄ Ä^&ŠÄ^ &‹F ‹V ƒí‹å]MÊXEU‹ìŽØƒìÄ^ &ŠÄ^&*ˆFúÆFøÄ^ &ŠÄ^&:~&ŠˆFüëþFü‹F ‹V ÿF ÿF€~ütÄ^ &ŠÄ^&*ˆFø ÀtØ€~øt s¸ÿÿë ¸ë€~úuõ+Àƒí‹å]MÊXEU‹ìŽØƒìVÄ^&ŠˆFü*ä+ÉQP‹ÃŒÂ@RPRSšƒ AIƒÄ Š^ü*ÿÄv&ˆ8‹F‹V^ƒí‹å]MÊXEU‹ìŽØƒìÿvÿvšé AIƒÄˆFü*ä+ÉQPÿvÿv‹F‹V@RPšƒ AIƒÄ Ä^ŠFü&ˆ‹F‹Vƒí‹å]MÊXEU‹ìŽØƒìWV‹vÇFü¿ßOÆ ö}ÇFüë öuOÆ0ë‹Æ™¹ ÷ù€Â0Oˆ‹Æ™÷ù‹ð öçƒ~ütOÆ-‹Ç^_ƒí‹å]MÊXEU‹ìŽØƒìÄ^ &ŠˆFü*äÄ^&Š*í+Áu8nüu+ÀëSÿF ÿFëØ€~ütîÿF ÿFÄ^ &ŠˆFüŠØ*ÿŠ‡*äÄ^&Š*ÿŠ*í;ÁtÏÄ^ &Š*ÿŠ‡Ä^&Š*ÿŠ+Áƒí‹å]MÊXEU‹ìŽØƒìÄ^ &ŠˆFü*äÄ^&Š*í+Áu8nüu+ÀëSÿF ÿFëØ€~ütîÿF ÿFÄ^ &ŠˆFüŠØ*ÿŠ‡*äÄ^&Š*ÿŠ*í;ÁtÏÄ^ &Š*ÿŠ‡Ä^&Š*ÿ