This one-minute SQL timesaver showcases a free online comma separator tool, designed to simplify the process of adding comma separators to your SQL code.
Delim.co is a Free Comma Separating Tool that separates one or more characters and text strings using delimiters such as commas (,), semicolon (;), quotes (\”, ‘), braces ({}), pipes (|), or slashes (/ \\ ) .
It’s an online tool that you can use to simplify delimiting tasks, including text, email, zip codes, clauses, keywords, and more.
The tool can handle SQL, program code, and plain text.
You can simply enter your non-delimited data on the left, select a delimiter & hit convert to get separated data on the right.
More configurations are available if the defaults aren’t what you need!
How do you add comma separators to SQL column lists quickly?
You can quickly add comma separators to a vertical list of SQL column names by copying the fields from your database console, pasting them into a free online text delimiter tool like Delim.co, and applying a comma chevron to convert them into a single-line, comma-separated string.
Why is a delimiter tool useful when writing Google BigQuery SQL?
Unlike SQL Server Management Studio (SSMS), where you can easily drag and drop column folders to generate comma lists, Google BigQuery lacks native column drag-and-drop support. Using an external text delimiter tool saves data analysts hours of manual typing when writing long SQL queries
In this example we use Big Query, copying the field names from the screen, then pasting them into the online tool
Our video breaks it down into three animated steps
Step 1 – Copy the text to the clipboard
Here we show a Google BigQuery public dataset being used. Unlike SQL Server where you can easily select ‘columns’ from a table and pick which ones you need
Drag and Drop Field Names in SQL (SSMS)
Google BigQuery does not have the same feature, so using a delimiter tool can save us lots of time
We simply select the column headers from the output and click ctrl+C to copy them to the clipboard
Step 2. Go to the website
Free Online Comma Separator Tool (delim.co)
and paste the copied data into the box on the left hand side of the screen
Step 3. Hit the Chevron to add the comma separators
This then processes the data and provides a formatted comma separated output, which we then copy and paste into our SQL editor
The column names are copied into the tool and the output is a nicely formatted list of those field names all neatly separated with a comma
station_id,name,status,address,alternate_name
You can now paste this straight into your query editor
The tool is not limited to commas either, it can be customised to provide other delimiters too, spaces, new lines and semi colons
This is a very useful tool to add comma separators to SQL, but its usefulness doesn’t stop there, it can be used in programming, or any other use you can think of
Here is the link, give it a try
Free Online Comma Separator Tool (delim.co)
It is a great way to convert a column of data into a comma seperated list
We have no affiliation to the site or the site owner, but we do use the tool sometimes and we find it useful. there are other such tools available on line, but this is our go to choice to help save time
If you use Google BigQuery it can be very useful
Here is a video of it in action
If you want to see more SQL time savers follow this link
Subscribe to our channel to see more Power BI Timesavers
Select Distinct YouTube Channel
Our Business Analytics Timesavers are selected from our day to day analytics consultancy work. They are the everyday things we see that really help analysts, SQL developers, BI Developers and many more people.
Our blog has something for everyone, from tips for improving your SQL skills to posts about BI tools and techniques. We hope that you find these helpful!
Frequently Asked Questions About SQL Delimiter Tools
What is the best free tool to add comma separators to text?
Tools like Delim.co provide a free, fast web interface where you can paste multi-line text, select a comma delimiter, and instantly convert it into a comma-separated list for programming or SQL queries.
How do you get a comma-separated list of columns in SQL Server?
In SQL Server Management Studio (SSMS), you can expand a table's object explorer tree and drag the "Columns" folder directly into your query window to automatically generate a comma-separated list of all field names.
Can delimiter tools handle code and plain text outside of SQL?
Yes. Text delimiter tools can process general code variables, comma-separated value (CSV) strings, lists of email addresses, and plain text blocks by swapping line breaks for custom characters like commas, pipes, or quotes.