Data Delimiter

Convert a pasted list into a quoted, delimited string for use in a query. Split, remove duplicates, wrap values, and copy the result. SQL IN applies single quotes and wraps the list as IN (...).


                        
                    

                

                

                    
                    
Copied

                    
                    
                

            


            

                

                    
Settings


                    

                        
                        
Single quotes, comma join, wrap as IN (...).

                        
                    

                    
                    
                    

                        
                        
Remove new lines from output?

                        

                            
                            
                        

                    


                    
                    

                        
                        
Remove duplicate records from the result?

                        

                            
                            
                        

                    


                    
                    

                        
                        
Explode your records using this delimiter.

                        

                            
                            
                            
                            
                        

                    


                    
                    

                        
                        
Add quotes to each record.

                        

                            
                            
                            
                        

                        
                    

                    
                    
                    

                        
                        
Character used between records.

                        
                    


                    
                    

                        
                        
Add text to the start and end of the final output.

                        

                            
                            
                        

                    


                    
                    

                        
                        
Add a new line after this many records. Use 0 to keep a single line.

                        
                    


                    
                    

                        
                        
Wrap each interval with tags.