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
Column select end of file
-
main Alexey
- Posts: 2708
- Joined: 25.08.2021 18:15
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.
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.
-
main Alexey
- Posts: 2708
- Joined: 25.08.2021 18:15