Exporting Data from the Profiler

In addition to formatted reports, the PLIST report-generation utility can produce a tab-delimited report of profiler output. The following sections describe the data format of the report, steps for analyzing statistics in the report, and a Microsoft Excel macro that uses this report format:

• Tab-Delimited Record Format
• Global Information Records
• Local Information Records
• Steps to Analyze Profiler Statistics
• Processing Profiler Output with Microsoft Excel
• Generating the Tab-Delimite Report
• Using the PROFILER.XLM Macro
• Changing the PROFILER.XLM Selection Criteria

The PLIST /T command-line option causes PLIST to dump the contents of a .PBT file into a tab-delimited format suitable for import into a spreadsheet or database. This format can also be used by user-written programs.

For example, to create a tab-delimited file called MYPROG.TXT from MYPROG.PBT, enter:

  PLIST /T MYPROG > MYPROG.TXT

The ASCII tab-delimited format was designed to be read by other programs; it was not intended for general reporting.