PowerTool Help


The List eXaminer PowerTool is often used in conjunction with the Count Reports tool. While the Reports are useful for viewing the database as a whole, ListX is for looking at a snapshot, or sample, of your data, for detailed examination.

Create and execute a new job
1) Select a Work Folder and Input File from the Input File menus
2) Enter a file format
For fixed-length input, enter the numeric record length.  For delimited, enter the delimiting character, or TAB for tab-delimited.
Binary formats such as Excel are not supported with this PowerTool.
3) Enter a file name for your output report file, and choose a report type.
Standard output shows the record layout, while ASCII HEX shows the ASCII values, making problem characaters "visible".
4) Report Span:
  Enter a starting record number.  Default is 1, the first record.
  Enter a number of records to skip, for each record reported (optional).
  Enter a Record Limit, how many records to display.  Default is 50 records, or about two pages.
5) Display Range:
  You may enter up to three field ranges to display (fixed-length records only), as location, comma, length.
Example: report starting at pos. 101, for a length of 10:
6) To save your job to run later, click the [FILE] menu, and select the [Save Parameter] option.
To save and run your job, click [FILE], then [Save and Run Job], or click the [Save and Run Job] button at the bottom.
*) Your job information will be saved and run as required.
The page will return with your results, and your report file will be available in your FileBox folder for download.

Print a report
1) To print the currently displayed report, click [FILE], and select [Print Report].
2) Follow the onscreen instructions for your specific printer.
*) Your report will print, and you will return to the PowerTool page.

View or edit an existing job
1) Click [FILE], and select [Load Parameters].
2) Select the previous job by name and date from the menu, and click [Open Parameter].
*) The job parameters will load on the page.
tip: The parameter is saved based on the input file name, so it can sometimes be faster to retrieve a previous job and edit it, rather than starting from scratch every time.
<%=htmPageBtm %>