Using Multi Edit Mode

Using Multi Edit Mode

This is a neat trick I have learnt recently. When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually.

Say, for instance, you have a list of numbers, and you have constructed the query to resemble the query below:

SELECT StudentID FROM Students WHERE StudentID IN (1 2 3 4 5 6 7 8 9 )

Now you need to add the commas manually. What happens when you have a larger list? There will be lots of freudian slips and finger-faults.

Solution: Multi Edit Mode

Click and hold the left mouse button to the left of the last item in the list. (Click left the number 9, in the above example).

  • Keep holding down the button
  • Press and hold the Alt button on the keyboard
  • Drag upwards (to the number 2 in the example above)
  • Release both the Alt button and the left mouse button
  • Notice that there is a fine blue line where you have dragged Press

Notice that the whole list gets populated with commas next to them, as shown next:

SELECT StudentID FROM Students WHERE StudentID IN (1,  2,  3,  4,  5,  6,  7,  8,  9 )

You can continue typing more, but when done, press Escape to exit Multi Edit mode.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist