Toad World® Forums

Copy from a large text field in the grid


If you do a Ctrl-c (or a right click copy) on a large text field (e.g. 255) in the grid, then you paste into your sql editor, it blank pads out to the entire column instead of just pasting in the characters that are in the field.



I have a field that is a varchar2(2000) with a total of 280 chars in the field, I right click copy and then paste in both a different application and an editor in navigator and both only paste the characters in the field (I don’t get any spaces). I guess I don’t quite understand what it is you are doing to get the spaces…


Not sure what the difference is, but if I do a right click or a ctrl-c I get tons of blanks when I past into the editor. It doesn’t happen when I go to word or wordpad.

If I open the pop up it doesn’t do it.

I’m using



Have you tried turn off the option “Trim column width while pasting” in Preference>Code Editor>SQL Scripts?


Ah, that’s it! I’ve never seen that option before.