Export Results

Export Results | Top Previous Next

For exporting results FileLocator Pro provides both the Reports functionality and the File -> Export Results menu option. The Export Results dialog allows the results to be saved either to the clipboard or to a specified file.

The results can be saved in a variety of formats:

Comma separated (CSV) | Comma separated table of results (best format for saving results for subsequent opening in Excel).
HTML | HTML formatted results, designed to look similar to the Hits tab view.
Tab separated | For content searches the information is grouped by file, similar to Hits tab. The Tab character (ASCII 09) is used to separate values.
Tab separated (spreadsheet) | Tab separated table of results, similar to CSV but using the Tab character (ASCII 09) to separate the columns (best format when saving to clipboard and then pasting into Excel).
Text | Text based format designed to look similar to Hits tab view.
XML | XML formatted results.

Custom formatting

For advanced formatting XSL transforms can be used to customize the output format. XSL transforms are a text based language for defining data transformations and can be used to convert FileLocator Pro's XML data into a desired format. Sample transforms are included in the Sample Transform subfolder and include:

Contents_NoLineNumbers.xsl | Exports just the found contents with no other information included, such as file data or line numbers.
FileName_Only.xsl | Exports just the file name without any path information, each file is exported on a separate line.
FullName_FileSizeBytes.xsl | Exports the full file name (ie with path) along with the size in bytes of the file.
Hash_Separated.xsl | Exports the file name information separated by the '#' character.
Hits_Only.xsl | Exports just the hits found in a search, i.e. without any file information or extra found text information. Useful for regular expression searches to output text that matches a given expression, e.g. extracting telephone numbers, or email addresses. This transform differs from Unique_Hits_Only.xsl in that it will output all hits of the found text, ie it will output duplicate hits.
HTMLTransform.xsl | Exports the data in a format very similar to the standard HTML export.
Unique_Hits_Only.xsl | Exports just the hits found in a search, i.e. without any file information or extra found text information. Useful for regular expression searches to output text that matches a given expression, e.g. extracting telephone numbers, or email addresses. This transform differs from Hits_Only.xsl by only outputing the unique hits, i.e. it only outputs the value of the hit once regardless of how many times it may actually be found.

xcopy.xsl

Generates XCOPY statements to copy from one drive to another preserving folder structure.

For each file an XCOPY command is generated with only the drive letter replaced in the source path. e.g.

C:\folder1\folder2\filename1.txt

generates:

xcopy "C:\folder1\folder2\filename1.txt" "E:\folder1\folder2\*"

NOTE: The XSL file needs to be edited to change target from E: to desired target drive. Does not work with UNC paths. e.g. \\server1\folder1\folder2

Copyright © 2013 Mythicsoft Ltd. All rights reserved.
Help file version: 7.0
PDF and CHM versions of this help file are available here:
http://mythicsoft.com/filelocatorpro/help