Review: CSV Format
June 15th, 2007 by PankajCSV or Comma Separated Values file is the simplest way to store data and commonly used for transfer tabular data form from one format to another format. CSV files are text files with .csv extension and can be edited with Notepad or MS Excel. Each field in a CSV files are separated by commas and new records starts with a new line.
The main advantage of storing data as CSV file is that it can be exported to any other type of database such as Excel, MS Access, MS SQL, MySQL and other type and also can be imported from these database type to CSV. It also consumes less space for storing data then any other formats. This is the main reason that large databases backups are made in this format.
A typical example of CSV file is:
Name, Company Name, Address Line 1, Address Line 2, Zip, Tel, Fax
Stephen Tyler, ABC Inc., “24, PQ Streetâ€Â, Some Town, 101010, 24-632-252, 24-632-252
If fields contains comma then it can escaped by embedding the field inside a set of double quotes. Like “24, PQ Street†in above example. More useful info on csv file escaping rules can be found at csvReader.
This is a sponsored Post.
