Friday, December 14, 2012

Scott's Flat File Modifier Utility Released


Hey Everyone,
I am proud to announce that the initial release of my Flat File Modifier utility is now available for download.  This utility is a non-destructive search and replace utility on steroids.



The Flat File Modifier will analyze any existing text file line by line and give you the following modification options:

  • Replace (Single Pass)
    • This option will read the text file line by line and do a single pass on that line looking for a value and replacing it.  The single pass option will only replace the first instance of the search value that it encounters on that line then continue to the next.
  • Replace (Multi Pass)
    • This option has the same functionality as the first but does a multiple pass on each line.  This option will ensure that all occurrences of the search value will be replaced.
  • Remove Row
    • The Remove Row option will search through the file and when it finds the search value, it will remove that row from the destination file.
  • Keep Only Row
    • This option will perform similarly to the Remove Row option but it will only keep rows in the destination file where it finds the search text.
Since this application is non-destructive, it will only read from the original input file and create a copy of this file with the modifications specified.



Full list of features of the Flat File Modifier:

  • Finds and replaces text in any size file without loading it into RAM
  • Line by line, non-destructive text replacement
  • Analyzes file for Row Count, File Size, and Modified Date
  • Allows preview of any size text file
  • Optional advanced sequencing of text replacement capabilities
  • Exporting and importing of proprietary sequence files
  • High Performance Mode

Where to get the latest version:


I hope this utility helps you out!  I know it has saved me many times.

No comments:

Post a Comment