The CSV ("Comma Separated Values") file format is often used to exchange data between differently similar applications. The CSV file format is useable by KSpread, OpenOffice Calc and Microsoft Excel spread-sheet applications. Many other applications support CSV in some fashion, to import or export data. CSV files have become obsolete due to XML data exchange possibilities (ie ODF, SOAP).
Sometimes leading zero values are required in a data set and while the leading zeros are present in the data they are not displayed. In some software it's possible to force strict interpretation of the CSV field value with a leading = (equal) symbol.
This may chop the leading zero on some softwares, even if quoted.
This incantation may convince that software to keep the leading zero.
Sadly there is no definitive standard for this, here is a collection of types we've seen in use.
Here are some examples that demonstrate the rules above. Each sample describes the data and how the reading application should interpret it.
This shows three fields, each with simple data.
Edoceo, Seattle, WA
The first field should be interpreted by reading applications as [space]Edoceo[comma][space]Inc.[space]. Whitespace also could include line breaks.
" Edoceo, Inc. ",Seattle,WA
The first field should be interpreted by reading applications as Edoceo[comma][space]Inc.