Example 3: Header with several missing column headings

If several column headings are missing in the CSV files, they are automatically added in the XML output file. If the missing column headings are located at the end of the header, the separators do not need to be present between the missing column headings.

Entry in CSV file

ORDER NUMBER;POSITION;;;

4711;10;"Harry, ""A"" Williams";Mobile 6600;3

or

ORDER NUMBER;POSITION

4711;10;"Harry, ""A"" Williams";Mobile 6600;3

Entry in XML output file

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE eventlist SYSTEM "event.dtd">

<eventlist>

<event>

<attribute type="ORDER NUMBER">4711</attribute>

<attribute type="POSITION">10</attribute>

<attribute type="FIELD_3">Harry, "A" Williams</attribute>

<attribute type="FIELD_4">Mobile 6600</attribute>

<attribute type="FIELD_5">3</attribute>

</event>

...

</eventlist>

The column headings FIELD_3, FIELD_4 and FIELD_5 are automatically created in place of the missing column headings in the CSV files. The same entry is generated in the XML output file regardless whether the separator appears between the missing column headings.