Column select end of file

Post Reply
ertank
Posts: 61
Joined: 06.06.2021 21:56

Column select end of file

Post by ertank »

Hello,

For certain reasons I need to modify big SQL files. I need to remove autoincrement column name and values from them in order to insert data in another database.

I can easily remove column name by replace, but removing autoincrement column values, I need to select as a column down to the end of the file. That, I need to wait my hands on keyboard Shift + Alt + PgDn for a long time.

I tried to find a shortcut to select down to the end of the file, but I couldn't find any. "to line begin", "to line end" exists.

I wonder if there is a faster way that can be used to select all columns down in a file.

Thanks & Regards,
Ertan
main Alexey
Posts: 2708
Joined: 25.08.2021 18:15

Post by main Alexey »

Top menu: Selection / More carets / More carets, down, until end.
Does it help?
if not - pls give sample screenshot to see how you select.
ertank
Posts: 61
Joined: 06.06.2021 21:56

Post by ertank »

I have found another way.
1- Position caret to top left column position
2- using mouse scroll down to last line
3- hold and keep holding Shift + Alt
4- using mouse click on the bottom right column position

That selects a rectangle that I would like to delete. I am used to use shortcuts and looked for single press key combination. Above also solved my problem. I am not doing such edits daily anyway.

Thanks.
ertank
Posts: 61
Joined: 06.06.2021 21:56

Post by ertank »

main Alexey wrote:Top menu: Selection / More carets / More carets, down, until end.
Does it help?
if not - pls give sample screenshot to see how you select.
That also works and easier than my way of doing it with mouse.

Thanks
main Alexey
Posts: 2708
Joined: 25.08.2021 18:15

Post by main Alexey »

Mentioned command is in the Command Palette too. look at "carets extend" name. so you can assign a hotkey.
Post Reply