Universal File Format

For many years, CSV was considered the universal file format. Just about any application could produce data in comma-separated values and just about any spreadsheet could read in CSV data. XML promises to become the universal file format of the future and it is far more powerful.

You may deal with CSV data every day. As developers, we need to talk to the other developer who is generating the CSV data, and we have to understand that the fifth column contains a zip code and the sixth column contains a product SKU. If the source system ever leaves out a field, we are likely to end up with wrong results. Open a CSV file and you may have this confusing view of the data (see Figure 15.1).

Figure 15.1

For years, CSV has been the universal format to get data from another system into a spreadsheet.With CSV,both developers must understand that the fifth column contains a zip code and the sixth column contains a product SKU.

E3 Microsoft Excel - OldData.csv

Bla Edt yaw insert Ffirmat Lads |

data

ïôndow tlab

0 0

Post a comment