|
SunSystems Transformation Language |
|
|
|
|
Sun Documentation -
System Administration
|
|
Page 10 of 11 Examples Example 1 This example describes simple comma delimited address data. Example Input name,address1,address2,address3,home_number Phil Brown,8 The High Street,Little Moreton,Cornwall,01845 998120 Paul Alan,12 The Hill,Appleby,Dorset,01823 120932Example Output <addresses> <address> <name>Phil Brown</name> <street>8, The High Street</street> <town>Little Moreton</town> <number>01845 998120</number> </address> <address> <name>Paul Alan</name> <street>12 The Hill</street> <town>Appleby</town> <number>01823 120932</number> </address> </addresses>
Schema <?xml version='1.0'?> <fsd:schema xmlns:fsd='http://www.systemsunion.com/2001/SSTM/SSTransform/fsd/' version='1.0'> <fsd:sequence name="addresses"> <fsd:sequence name="address-coll" output="no" max-occur="0"> <!-- Define the header line --> <fsd:record name="headerline" max-occur="1" min-occur="1" record-sep="\r\n" output="no"> <fsd:field output=”no” /> </fsd:record> <!-- Define the address records --> <fsd:sequence name="empty-seq" output="no" max-occur="0" min-occur="1"> <fsd:record name="address" record-sep="\r\n" max-occur="0" min-occur="1"> <fsd:field name="name" field-sep=","/> <fsd:field name="street" field-sep=","/> <fsd:field name="town" field-sep=","/> <fsd:field name="county" field-sep=","/> <fsd:field name="number"/> </fsd:record> </fsd:sequence> <!-- Define the optional blank line at the end --> <fsd:record name="blank-line" output="no" max-occur="1" min-occur="0" record-sep="\r\n"> <fsd:field output="no"/> </fsd:record> </fsd:sequence> </fsd:sequence> </fsd:schema> |