Dealing with databases and SQL I run across a lot of lists that are usually broken by either excel or line breaks. Well when you need a quick way to convert that to a single line comma separated list the fastest way to do it is a find and replace on regular expressions. This can be easily done with Notepad++ or just about any text editor
For example if you had a list like:
1
2
3
4
A find of \r\n and replace with , will give you the output of
1,2,3,4
This can save a whole bunch of time!
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
« Paint.Net Free Photo Editing Software 7zip Theme Manager »
