Sort and Convert CSV Files. CSV to LDIF, XML to CSV, etc.

Home » Solutions » File Interchange » CSV

CSV (Comma-Separated Values) Files

Process and Convert to/from CSV Files Quickly

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 input records in 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.

Solutions:

CSV File Conversion Only
Now available from IRI is a low-cost, data migration product called NextForm. NextForm allows you to convert CSV files to other formats (like LDIF, COBOL, XML, etc.) or from those other formats into CSV files. NextForm also supports data type conversion at the field level, and the remapping of record layouts.

Note that NextForm file definitions will also work in SortCL so that you can re-use this metadata if you someday want to upgrade to CoSort's fast transformation, custom reporting, and/or data-centric protection functionality.

CSV File Processing & Conversion
The CoSort package's SortCL tool can manipulate, report, protect, convert, and create large and small files in CSV format, and frame CSV fields with internal commas.

This wide functional support for CSV data allows you to quickly migrate legacy sequential, index, LDIF and XML files to CSV files for PC applications. In addition, SortCL supports the simultaneous processing and reformatting of huge file volumes into CSV so that you can quickly prepare subsets for importation into databases, spreadsheets, BI dashboards, etc. that require CSV input files.

The reverse is also true; you can convert from CSV to other file formats, such as fixed length and tab-delimited, LDIF, MF-ISAM, and XML. Browse the list of supported file formats under File Interchange (on your left), and see their job samples for CSV file interchanges as well.

CSV Test Data
If you need to generate test data in CSV file formats, see IRI's RowGen product. RowGen uses the same layout metadata as CoSort (SortCL) and NextForm so you can easily move between test data generation and real data transformation..

IRI, The CoSort Company