Flat File Modifier Header Modification Option (v3.0.2)

---

Hey Everyone,
The Flat File Modifier Utility has been updated!  I have fixed a few minor bugs and added a very exciting new feature.  The utility now allows for Header modification on extremely large data files!

This new feature will allow you to Add, Remove, or Replace header rows in files that could not normally be opened in a text editor due to their size.

The screenshot below shows the sample data file that I used.

There are 2 main sections in the header options tab; "Rows to Remove" and "Add Header".  These sections work independently of each other to give maximum flexibility in modifying the header of these files.

The Rows to Remove section will delete the specified number of rows from the top of the loaded file and the Add Header section will add the specified text to the top of the file.

The screenshots below show the preview capabilities of the header modification section.

You can get the latest version from the Utilities Section Link below.
Flat File Modifier in the Utilities Section

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:

Flat File Modifier in the Utilities Section

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