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.

Peloton Makes Documentation Utility Available to the Oracle User Community

---

I am very excited to announce that the Peloton Object Parser Utility that I created has now been released to the Oracle community!  This utility will automatically document objects from your Oracle EPM system.  Simply extract the objects from the system, place them in a folder on your local machine, and run the Parser against that folder.  It really is that easy.

The types of files that it will document are listed below (v1.8.0):

• Classic Business Rule Exports (*.XML)
• Calc Manager Business Rule Exports (*.XML)
• Planning Form Definition Exports (.XML)
• Composite Planning Form Definition Exports (*.XML)
• Financial Reports Exports (*.DES)
• Financial Report Books (*.KBK)
• Financial Report Batch (*.BCH)
• Security Export Files (*.SEC)

Other Benefits of the Parser:

• It is Free!
• I have been working on this utility for many years and truly believe that it is something that can help the Oracle community.  This lead us to the decision to give this utility away at no charge and really give back to the community.
• No Installation Needed
• It's a completely self sufficient utility
• Will run from a flash drive as well
• Non-Destructive Application
• This application is non-destructive to your original files.  It will simply open them up, read through them, and create separate files of its own.
• As a best practice, please do not run this utility on your production servers.  Simply copy the object files to a client machine and run it from there.

External Links:

Press Release:

http://www.prweb.com/releases/prweb2012/11/prweb10172583.htm

Direct Link to Download Page:

http://pelotongroup.com/how-we-deliver/solution-accelerators/