XML is your friend

I’ve been working a lot recently with data import and exports between systems. ¬†Obviously different systems have a variety of ways they can export data, and some even have multiple ways of importing data, but none of them seem to have a standard type for the file data. ¬†In recent weeks I have worked with:

Files where fields are delimited with a #
Files where fields are delimited with a ^
Files where fields are delimited with a , (typical CSV files)
Files where everything is nicely structured XML

Continue reading “XML is your friend”