I want to add ' in the start and end of line and , in every line like
'Tom',
'Rim',
'Good',
The idea is if i copy list of values in notepad++ and select all the values and add single quotes in the start and end and , in the end to place the values in sql in ()
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I want to add ' in the start and end of line and , in every line like
'Tom',
'Rim',
'Good',
The idea is if i copy list of values in notepad++ and select all the values and add single quotes in the start and end and , in the end to place the values in sql in ()
Did you perform a search in trying to find the answer yourself?
http://sourceforge.net/search/index.php?group_id=95717&words=%28%2Binsert+%2Bstart+%2Bline%29&type_of_search=forums&pmode=0&limit=75
Perhaps this will also retrieve some matches:
http://sourceforge.net/search/index.php?group_id=95717&words=%28%2Bappend+%2Bend+%2Bline%29&type_of_search=forums&pmode=0&limit=75
There was a post with a similar problem not so long ago (you will find in result set #1 from above).
Ctrl+R
Find:
,<Ctrl+Enter>
Replace:
',<Ctrl+Enter>
'