Tool to separate values. Separating values allows delimiting the start and the end of each item with a character (commas, semi colons, etc.) for a clean separation.
Separation with Commas - dCode
Tag(s) : Data Processing
dCode is free and its tools are a valuable help in games, maths, geocaching, puzzles and problems to solve every day!
A suggestion ? a feedback ? a bug ? an idea ? Write to dCode!
Separation with Commas
Values Separator
Answers to Questions (FAQ)
What is a value separation? (Definition)
Value separation is a computer data processing operation that takes care to ensure that the (usually textual) values in a file are read and recognized correctly.
CSV format generally represents values separated by commas or tabs (or any other separator).
How to separate values?
dCode tries to catch all values and their separator automatically and proposes to reorganize them, either under the list form with the chosen delimiter, either under the table form (sortable), that can be exported to a spreadsheet like Excel.
Example: abc def ghi, jklm can be split at spaces/punctuation into abc|def|ghi|jklm with the separator/delimiter | (pipe)
What does CSV stands for?
CSV is the abbreviation of Comma-separated values, where values are delimited with a comma ,.
What does TSV stands for?
TSV is the abbreviation of Tabulation-separated values, where values are delimited with a tabulation character ↹.
How to choose a separator/delimiter?
Be careful to choose a character that will not be used in the fields of the table.
The separator is not standardized, but it is generally a character like a comma ,, a semicolon ;, a slash / etc.
Each line/row of a file is a representation of tabular data.
By default, commas correspond to boundaries between each column.
Source code
dCode retains ownership of the "Separation with Commas" source code. Any algorithm for the "Separation with Commas" algorithm, applet or snippet or script (converter, solver, encryption / decryption, encoding / decoding, ciphering / deciphering, breaker, translator), or any "Separation with Commas" functions (calculate, convert, solve, decrypt / encrypt, decipher / cipher, decode / encode, translate) written in any informatic language (Python, Java, PHP, C#, Javascript, Matlab, etc.) or any database download or API access for "Separation with Commas" or any other element are not public (except explicit open source licence like Creative Commons). Same with the download for offline use on PC, mobile, tablet, iPhone or Android app.
Reminder: dCode is an educational and teaching resource, accessible online for free and for everyone.
Cite dCode
The content of the page "Separation with Commas" and its results may be freely copied and reused, including for commercial purposes, provided that dCode.fr is cited as the source.
Exporting the results is free and can be done simply by clicking on the export icons ⤓ (.csv or .txt format) or ⧉ (copy and paste).
To cite dCode.fr on another website, use the link:
In a scientific article or book, the recommended bibliographic citation is: Separation with Commas on dCode.fr [online website], retrieved on 2025-04-15,
