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
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.
Answers to Questions
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/punctutation into abc|def|ghi|jklm with the separator/delimiteur | (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 caracter like a comma ,, a semicolon ;, a slash / etc.
Each line 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 online 'Separation with Commas' tool source code. Except explicit open source licence (indicated CC / Creative Commons / free), any algorithm, applet or snippet (converter, solver, encryption / decryption, encoding / decoding, ciphering / deciphering, translator), or any function (convert, solve, decrypt / encrypt, decipher / cipher, decode / encode, translate) written in any informatic language (PHP, Java, C#, Python, Javascript, Matlab, etc.) no data, script or API access will be for free, same for Separation with Commas download for offline use on PC, tablet, iPhone or Android !
Need Help ?
Please, check our community Discord for help requests!
Questions / Comments
