Using XML with Legacy Business Applications

Sample Input and Output

We use a simple address book listing for the example for this utility. Each row is an entry for a person. The columns are listed below.

1. Last name

2. First name

3. Street address, first line

4. Street address, second line

5. City

6. State or province

7. Zip or postal code

8. Country

9. Phone number

10. E-mail address

Here's an address book in this format, with entries.

Sample Input Document (SimpleCSV.xml)

<?xml version="1.0" encoding="UTF-8"?> <SimpleCSV> <Row> <Column01>Jones</Column01> <Column02>Mary</Column02> <Column03>312 Renner Road</Column03> <Column04>Apartment C</Column04> <Column05>Richardson</Column05> <Column06>TX</Column06> <Column07>75080</Column07> <Column08>USA</Column08> <Column09>972-996-1051</Column09> </Row> <Row> <Column01>Smith</Column01> ...