Possibility to have PASTE without formatting

[Kari]

Hi,

I work with financial data and have configured PL/SQL dev to show numbers with thousands comma-separated. That all works fine.
But in the data, there are e.g. primary keys that I need from time to time to copy from the query results and paste back to another, e.g. SELECT statement. Currently, I have to manually strip out the commas from these numbers.

It would be useful to have the option to "Paste as plain text".

Can I do it somehow currently, and if not, I would like to present this as an enhancement request.

Thanks,
Kari

 

[Marco Kalter]

There are currently 3 ways to accomplish this:

1. Select the cells you want to copy, right-click on them, and select "Copy as expression list". This may be exactly what you are looking for if you want to use these values in a subsequent query.
2. Go to Preferences > SQL Window and change the "Number layout" to an option without thousand separators. This now applies to all number fields.
3. Execute the query and apply a to_char(fieldname) function to the relevant fields, so that the numbers are formatted without thousand separators.

 

[Kari]

Hi,
I ended up creating a plugin to do the "stripping of the thousands separators" from a number.

If anyone is interested in looking at the code, I have attached it here. The new menu option is available from the right-click pop-up menu in the different windows in PL/SQL Dev, e.g., the SQL Window. It is also visible in the Plugins section in the Ribbon menu.
It would be nice to have it next to the other "Paste"-options, but I don't think it is possible.

N.B. I'm not a seasoned Pascal programmer; this was created together with Claude.ai.