> ## Content Index
> Fetch the complete content index at: https://kudithipudi.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# HOW TO : Add commas (,) at the end of every line using Notepad++
- URL: https://kudithipudi.org/how-to-add-commas-at-the-end-of-every-line-using-notepad/
- Published: 2020-05-12T01:29:08.000Z
- Updated: 2020-05-12T01:29:08.000Z
- Description: Thanks for this great nugget from Sumama Waheed Many a time, you get some data as a CSV file and need to copy some of that...
- Author: admin
- Tags: HOWTO, Technology, Windows, #wp, #wp-post, #Import 2026-08-23 02:32

Thanks for this great nugget from [Sumama Waheed](https://www.linkedin.com/in/sumamawaheed/?ref=kudithipudi.org)

Many a time, you get some data as a CSV file and need to copy some of that data and include it in a SQL statement. For instance one of the rows in the CSV was first name in the format below

employee\_id  
1234  
8765  
9808  
1235  
8734  
6723

And you need to put it in a SQL statement as below

SELECT \* FROM employee\_table  
WHERE employee\_table.employee\_id IN (1234,  
8765,  
9808,  
1235,  
8734,  
6723)

That’s a lot of adding commas (,) at the end of every line. You can do it quickly in [Notepad++](https://notepad-plus-plus.org/?ref=kudithipudi.org) (you can do the same in any editor that supports regex) using the regex capability in search and replace using ($) as the search string and $, as the replace string.

![](https://kudithipudi.org/wp-content/uploads/2020/05/image.png)