Notepad++ Multi editing

How can I have multiple cursors in Notepad++?

I will have a couple of tab delimited values . I need to write a query for all of these values. For example, if I get an Excel file with values like this:

1234 xyz pqr
2345 sdf kkk
...

I want to copy this whole piece of data into Notepad++ and write the query, inserting all the values at once.

Like this:

Insert into tbl (1234, xyz) where clm = 'pqr'
Insert into tbl (2345, sdf) where clm = 'kkk'
...

I used to do it with my previous text editor Ultraedit. Can this be done using Notepad++?

Solution 1:

Yes: simply press and hold the Alt key, click and drag to select the lines whose columns you wish to edit, and begin typing.

You can also go to Settings > Preferences..., and in the Editing tab, turn on multi-editing, to enable selection of multiple separate regions or columns of text to edit at once.

It's much more intuitive, as you can see your edits live as you type.

Solution 2:

In the position where you want to add text, do:

Shift + Alt + down arrow

and select the lines you want. Then type. The text you type is inserted on all of the lines you selected.