CSV ToolsLesson 348Free preview

Change CSV Separator

This lesson is part of Web Developer Tools · All levels

Summary

CSV uses separator or delimiter characters to limit columns, and commas are the most common option. In some regions, semicolons or tabs are more commonly used because the comma also appears as a decimal separator. The Change CSV Separator tool changes the delimiter by keeping the contents of the field, including the fields that the quotation marks are attached to.

Key points

The default delimiter of CSV is a comma, but semicolon and tab are also common
Fields containing delimiter must be crossed with quotation marks
Conversion should parse the field, not just replace the character.
Header should be kept on the first line
Use UTF-8 encoding to keep non-ASCII characters secure

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.