Delimiter Separatormdi-hammer-wrenchToolboxColumn Data ComparisonData TrimmerDelimiter SeparatorExtra New Line RemoverJSON Formatter and ConverterOnline HTML EditorPrefix and Suffix ModifierURL Decoder and EncoderXML File Data ExtractorXSD File Data Extractormdi-menu-downmdi-informationAboutmdi-phone-classicContactToolboxColumn Data ComparisonData TrimmerDelimiter SeparatorExtra New Line RemoverJSON Formatter and ConverterOnline HTML EditorPrefix and Suffix ModifierURL Decoder and EncoderXML File Data ExtractorXSD File Data Extractor
A delimiter is used to separate data. Examples of delimiter are space, comma, semicolon or pipe.
The tool converts data from a spreadsheet into a (comma, semicolon, space or pipe) delimited list of values or vice-versa.
Usage
Selection of delimiters which apply to separate the column data.
Selection of qoutes which enclose the column data.
Button to apply all the delimiter from the left panel with or without qoutation and generate the result to the right panel.
Button to select all the content of the left panel.
Button to clear the content of the left panel.
Button to remove all the delimiter from the right panel and generate the result to the left panel.
Button to select all the content of the right panel.
Button to clear the content of the right panel.
Left panel area.
Right panel area.
How to add a delimiter
Copy and paste data on left panel(9) as shown on the screenshot.
Use the Delimiter dropdown(1) and select one of the options.
The next dropdown(2) allows you to add single or double quotes.
Click the Apply button(3).
Check the right panel(10) for generated result.
How to remove a delimiter
Copy and paste delimited list of values on the right panel(10) as shown on the screenshot.
Use the Delimiter dropdown(1) and select one of the options to use for removal.
Click the Remove button(6).
Check the right panel(9) for generated result.
See how it works
Friendly Reminder: Before any database changes especially in production, please make a backup copy.
If you have a feedback or would like to request a new feature, please visit our Contact page.