Text & CSV Delimiter Tool
-
If you are a programmer or ever work with Excel spreadsheets or SQL databases, you will indoubtedly have dealt with Comma Seperated Value (CSV) data
Formatting and preparing data from one format to another is a tedious exercise and eat up value time.
With the Comma Seperation & Delimiter Tool, you can speed up this process tremendously and save hours of your time.
- e.g. Commas (,), semi-colons (;), colons (:), forward (\) and back (/) slashes, vertical bar (|), caret (^), and space character
- Wrap individual items in one of the many available quote characters e.g. '1010','0101','4321'
- Single quotes ('), double quotes ("), and all types of brackets ()[]<>{}
- Wrap complete lines with end quotes or brackets e.g. {'abc','def','ghi',...}
- Remove Quotes from the input data - so all data are just plain text
- Reuse the output as the input
It is as simple as entering your data into input box A, with the delimited results shown in output box B!
SPLITTING Lines
If your input data is on one line, it will assume that you are trying to SPLIT the data based on the selected delimiter. The delimiter does not necessary need to be comma values, but can be any one of the most common delimiters.
JOINING Lines
If your input data is 2 or more lines, it will assume a JOIN operation is required and will join your lines together with the delimiter chosen. You can force it to SPLIT multiple lines with the Split All Inputs checkbox.
There are a few other functionalities you can use as part of this tool