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>