ctrl-v | source pastebin with latex and markdown rendering support

If you mean the lines after the first occurence of m/PH then I would start a search from the first line to the first occurence and delete from this line on :1;/m\/PH/,$ d If you want to delete all characters in each line after m/PH then find this string, preserve it and "forget" anything else behind it :%s/\(m\/PH\).*$/\1.

Your plugin contains several errors and places where the code can be improved.

1. The os.path class is not automatically imported using import os. You need to use import os.path.

2. Your class name class copypathCommand must begin with a capital C to create the copypath command, i.e. class CopypathCommand, see How to set or find the command name of a Sublime Text plugin.

3. You have inherited from sublime_plugin.WindowCommand but then used the edit parameter in the run() method which can only be used in classes that inherit from sublime_plugin.TextCommand. It is best to use a TextCommand for this plugin since it will already have the active view set as self.view. So that gives class CopypathCommand(sublime_plugin.TextCommand).

4. There is no need to use extract_variables() to get the file path. The Sublime Text API provides the file_name() method in the view class which returns the full file path or None if the view / buffer is unsaved (i.e. no file path to return). So the full path can be retrieved with one call file_path = self.view.file_name().

5. You use os.path.basename() but your question title says you want the "current file full path without filename" which would require the use of os.path.dirname(). This is how those 2 methods differ in what is returned:

But I want it to read only one line per read() function call. I believe that I either set a wrong parameter making the conanical mode unused ...

Your program does not behave as expected because canonical mode is never actually set.
The statement

You have a string that contains double quotes, inside an array:

You are using the wrong DataFormat. You can always get a list of currently present data formats by calling Clipboard.GetDataObject().GetFormats().

You need to use:

I think you're trying to run Python code with an R kernel.

Go to Runtime -> Change runtime type -> Python 3

If you do the copy & paste from the Google Drive web UI to copy a spreadsheet, the whole file including the bounded scripts will be copied.

By the other hand, if you copy the spreadsheet content (some cells or all the cells in a sheet) and try to paste them to other spreadsheet, not all the source features will be included. Since the scripts aren't bounded to a specific cell either to a sheet, using copy & paste from the Google Sheets UI (web or mobile) will not include the scripts.

To include the data validations and other missing features with exception of the scripts due to what was explained above, instead of doing a copy & pase copy the sheet to the destination spreadsheet. To do this, you could click the dropdown menu on the sheet tab, then select Copy > New spreadsheet / Copy > Existent spreadsheet

Figured it out. Select visually and then delete, so:

Ctrl-v 3j 3l x

The problem you were having is that operations such as d when in visual mode no longer are associated with motions, but with the selection, so it will just delete what is currently selected without waiting for the w motion you wish to give it.

Instead, when in visual block mode, you can use D which will delete until the end of the line.

Alternatively, you could use $ to motion to the end of the line(s) and then d to delete the selection. This way of doing things also allows you to do things like append to the end of the line by doing $A.