Example of comma delimited address data
This example illustrates 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.infor.com/2017/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>