CSV Files

 

Next Steps
Overview CLF/ELF CSV JSON LDIF LS-RS-VS MF-ISAM MFVL Text VB Vision VSAM XML

Challenges


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.

You may also need to protect personally identifiable information (PII) in CSV files or produce CSV test data.

Solutions


IRI delivers CSV and other file handling functionality across its product line. Choose based on need, noting that the IRI Voracity platform includes everything below.

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.

NextForm file definitions also work in the SortCL program in IRI CoSort and Voracity. That means you can re-use your metadata in fast data transformation and reporting jobs when upgrading.

CSV Data Transformation & Conversion

The SortCL program in CoSort or Voracity can:

  • transform CSV files (i.e. sort, join, aggregate, cross-calculate, etc.)
  • convert CSV files to other file formats and create CSV files from those formats
  • report from CSV file sources

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 FieldShield or Voracity to protect fields in production CSV files with encryption, masking, etc.

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.

Request More Information

Live Chat

* indicates a required field.
IRI does NOT share your information.