Skip to main content

Home/ SoftwareEngineering/ Group items tagged CommaSeparatedValue

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
kuni katsuya

CSV Comma Separated Value File Format - How To - Creativyst - Explored,Designed,Deliver... - 0 views

www.creativyst.com/...CSV01.htm

CSV CommaSeparatedValue

shared by kuni katsuya on 20 Feb 13 - Cached
  • The Comma Separated Value (CSV) File Format
  • The CSV File Format
  • CSV & Unicode
  • ...8 more annotations...
  • CSV in New Designs
  • Excel vs. Leading Zero & Space
  • Considerations When Exporting CSV
  • The biggest differences are in how these three characters are handled. Embedded double quotes in fields. An escape character is sometimes used to introduce a double quote, or in place of it. Embedded line-feeds in fields. This one is also escaped sometimes. Often like in C ("\n") Embedded commas in fields. Again, an escape character is sometimes used in place of the comma
  • Excel vs. Leading Zero & Space
  • A particular aspect of how Excel uses CSV has become a considerable source of confusion and uncertanty.
  • always remove leading spaces
  • always remove leading zeros from fields before displaying them
kuni katsuya

Comma-separated values - Wikipedia, the free encyclopedia - 0 views

en.wikipedia.org/...Comma-separated_values

CSV CommaSeparatedValue

shared by kuni katsuya on 20 Feb 13 - Cached
  • Comma-separated values
  • line breaks
  • records
  • ...7 more annotations...
  • Basic rules and examples
  • fields
  • separated by some other character
  • Application support
  • but depending on the system's regional settings, it may expect a semicolon as a separator instead of a comma, since in some languages the comma is used as the decimal separator
  • Microsoft Excel will open .csv files,
  • Also, many regional versions of Excel will not be able to deal with Unicode in CSV
1 - 2 of 2
Showing 20▼ items per page