An example of comma delimited address data in FSD
The following example describes simple comma delimited address data:
Example input
name,address1,address2,address3,home_number
Phil Brown,23 The High Street,Appleby,Cornwall,01485 936520
Paul Alan,12 The Hill,Little Moreton,Dorset,01283 756322
Example output
<addresses>
<address>
<name> Phil Brown</name>
<street> 23, The High Street</street>
<town>Appleby</town>
<number>01485 936520</number>
</address>
<address>
<name>Paul Alan</name>
<street>12 The Hill</street>
<town>Little Moreton</town>
<number>01283 756322</number>
</address>
</addresses>
Schema
<?xml version='1.0'?>
<schema xmlns='http://www.systemsunion.com/2001/TD/SSTransform/fsd/' version='1.0'>
<sequence name="addresses">
<sequence name="address-coll" output="no" max-occur="0">
<!-- Define the header line -->
<record
name="headerline" max-occur="1" min-occur="1"
record-sep="\r\n" output="no">
<field output="no" />
</record>
<!-- Define the address records -->
<sequence name="empty-seq" output="no"
max-occur="0" min-occur="1">
<record name="address" record-sep="\r\n"
max-occur="0" min-occur="1">
<field name="name" field-sep=","/>
<field name="street" field-sep=","/>
<field name="town" field-sep=","/>
<field name="county" field-sep=","/>
<field name="number"/>
</record>
</sequence>
<!-- Define the optional blank line at the end -->
<record name="blank-line" output="no"
max-occur="1" min-occur="0" record-sep="\r\n">
<field output="no"/>
</record>
</sequence>
</sequence>
</schema>