The comma separated value (CSV) format is a typical format for describing data in tables or spreadsheets.
The CSV format is used to exchange data between database applications or spreadsheet applications. Although the CSV format is widely used, a definitive specification has not been formally documented. However, these are some of the rules that characterize the CSV format:
12345,Smith,John,"3, North Street"<CR><LF>
41352,Jones,Ivor,"5, South Road"<CR><LF>
53421,Edwards,David,"10, East Lane"
For example, xx"xx must be written as "xx""xx", and "xxxx" must be written as """xxxx""".
The quotation mark characters must occur at the start and end of the data, are stripped from the data when the field is parsed, and are not added to the output tree. For example, the data A,"B",C results in an output tree that contains the values A, B, and C.
CSV messages can be modeled by using Data Format Description Language (DFDL) schema files; see Data Format Description Language (DFDL).
You can also create a CSV message model by using the New Message Model wizard and selecting the CSV option.