This sample provides examples of how you can model various
forms of comma separated value (CSV) message.
The example message models grow in complexity.
CSV_1 models a CSV message with data records only and CSV_2 models a CSV message with a header record and data records.
CSV messages are a common style of message format, that is often used for data extracted from databases and spreadsheets. CSV messages consist of a number of newline terminated records, each containing a number of comma separated fields.
Here is an example of a CSV message:
For more information on CSV, see CSV messaging standard.
This sample includes DFDL schema files that model example messages. The example messages include the following items:
For more information on DFDL, see Data Format Description Language (DFDL).
The CSV sample is divided into two message flows: CSV2XML and CSV2CSV. CSV2XML changes the message domain from CSV to XMLNSC. The XML output demonstrates that the message model has successfully parsed the CSV message into the correct logical structure. The CSV2CSV flow demonstrates how to process the logical structure of the the CSV_2 and CSV_3 DFDL models by using ESQL and Graphical Data Mapping.
For more information about mapping, see Using graphical data maps.
For a detailed explanation of how to run each sample, see Running the CSV sample.
For a detailed explanation of each sample DFDL schema file, see Exploring the CSV sample.