Page 1 of 1

Column select end of file

Posted: 08.04.2022 08:34
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

Posted: 08.04.2022 09:43
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.

Posted: 08.04.2022 19:49
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.

Posted: 08.04.2022 20:25
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

Posted: 08.04.2022 20:42
by main Alexey
Mentioned command is in the Command Palette too. look at "carets extend" name. so you can assign a hotkey.