Toad World® Forums

Copy data with removing double entries option

Hello,

The copy option “No headers, insert statement or in clause formatted text” is a very nice feature.
However, when copying data including double entries for one given column, it would be even better to remove them when copying “in clause formatted text”.

Would it be possible to add that?

Regards,

Alexandre DOLIQUE.

I can enter a CR for this but can you provide an example of what the copy text is and what you want it to be. I want to make sure I understand fully.

Debbie

Hello,

If you take the example herewith.

A copy of the RE_ID field, for instance gives
(954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 954, 955, 955, 955, 955, 955, 955, 955, 955, 955, 955, 955, 971, 971, 971, 974, 987, 989, 989, 989, 989, 1207, 1207, 1207, 1207, 1207, 1207)

What I would like it to be is
(954, 955, 971, 974, 987, 989, 1207)

Thank you.

Regards,

Alexandre DOLIQUE.