About Comma-Separated Values File Format
The comma-separated values (CSV) file format is a tabular data format that has fields separated by the comma character and quoted by the double quote character. If a field’s value contains a double quote character it is escaped with a pair of double quote characters.
The CSV file format does not require a specific character encoding, byte order or line terminator format.
It is often not required by software to have fields quoted unless they contain a comma character.
Example:
“Chicane”, “Love on the Run”, “Knight Rider”, “This field contains a comma, but it doesn’t matter as the field is quoted” “Charles Barber”, “Adagio for Strings”, “Classical”, "This field contains a double quote character, "“, but it doesn’t matter as it is escaped”
Link: Microsoft Office Online
Word Counts, Character Counts and Line Counts for CSV Files
AnyCount automatically produces correct word counts, character counts, and line counts for single or multiple files in .CSV file format.
Word count results window for .CSV file format:
AnyCount can automatically recognize text delimiters.
But you can also set custom delimiters and qualifiers in cases of non-standard files.
Available text delimiters:
, — comma, ; — semicolon
Available text qualifiers:
’ — apostrophe, " — quotation marks
Word count settings window for .CSV file format:
After CSV count is completed, you can:
- view count results on the screen;
- print count results;
- export count results to .TXT format;
- export count results to Comma-Separated Text/Tab-Separated Text (.CSV Format);
- export count results to .HTML format;
- export count results to MS Word format;
- export count results to MS Excel format;
- export count results to .RTF format;
- copy results to clipboard.