[CSV-109] Support external CSV schema definition

• Type: Wish
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.0
• Fix Version/s: Patch Needed, 1.x
• Component/s: Parser
• Assignee: Unassigned
• Reporter: Jay Zylstra
• Created: 18/Mar/14 21:06
• Updated: 10/Mar/20 07:38

Description

As XML has XSD, so CSV needs an external schema definition file which defines the schema of the flat file format and the values it contains. Programmatically adding constraints, as supported by org.supercsv.cellprocessor.constraint.StrRegEx, are useful but not portable. Fortunately, Microsoft has already created such a CSV schema definition file format called Schema.ini.

It is my suggestion to add file and data parsing validation to Apache Commons CSV by adopting support for Schema.ini, bringing this long overdue functionality to the Java world.