Text & CSV Splitting 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.
It is as simple as entering your data into input box A, with the delimited results shown in output box B!



SPLITTING CSV 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.


• e.g. Commas (,), semi-colons (;), colons (:), forward (\) and back (/) slashes, vertical bar (|), caret (^), and space character







JOINING CSV 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


• 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



Split CSV Lines button vs Split All Inputs

The Split CSV Lines button is a general split function which will split along any one of the following delimiters [comma(,) colon(:) semi-colon(;) tab(\t)].
The Split All Inputs is more precise and will split only on the delimiter currently selected but for all lines.