Convert and Process Delimited Data Faster
Index, fixed-position, LDIF, XML, web log, and many other file formats are not compatible with spreadsheets, database loaders, and other applications that require delimited data files in comma-separated values (CSV) format. Conversely, files exported in CSV format may need to be processed and re-cast into other file formats for mainframe, tape, data interchange, and reporting applications.
CSV File Conversion Only
Use IRI NextForm or IRI Voracity to convert files in CSV to other formats (e.g., LDIF, ODBC, XML, text, etc.), or from other formats to CSV. NextForm also supports data type conversion at the field level, and record layout remapping.
CSV Data Transformation & Conversion
using a simple 4GL for layout and manipulation definitions, or a powerful free GUI built on Eclipse.
Map one or more input files in CSV to and from other formats. Create detail, summary, or delta (change data capture and slowly changing dimension) reports from CSV sources. Hand off pre-sorted, filtered, and converted subsets to BI tools, database load utilities, or other applications.
CSV Data Masking & Test Data
Use IRI RowGen or Voracity if you need test data in CSV file formats. RowGen uses the same layout metadata as CoSort (SortCL) and NextForm, so you can easily move between test data generation and real data transformation.
All of the above (and many other!) use cases are performed through the same simple 4GL job-script metadata for file layout and field manipulation. Automatically create, graphically modify, and team-share these metadata assets in a free, familiar IDE built on Eclipse™ called IRI Workbench.