Copy as CSV

Have a suggestion for "Everything"? Please post it here.
Post Reply
NotNull
Posts: 5461
Joined: Wed May 24, 2017 9:22 pm

Copy as CSV

Post by NotNull »

There is a quite useful (IMO) option to copy selected results as a CSV file to the clipboard by using a keyboard shortcut.
This can be found under Menu:Tools > Options > General > Keyboard: Result List | Copy as CSV

Suggestion is to add this Copy as CSV to the Context Menu, so that it can be shown with a right-click on the selection (configurable; just like the other context menu entries).
void
Developer
Posts: 16762
Joined: Fri Oct 16, 2009 11:31 pm

Re: Copy as CSV

Post by void »

Added to my TODO list.
Stamimail
Posts: 1122
Joined: Sat Aug 31, 2013 9:05 pm

Re: Copy as CSV

Post by Stamimail »

When I pasted it into Excel, I got the whole text in one column, instead of a table structure.
To fix it I used:
1. "Paste Options" pop-up button, is available when you paste. Click on it, and choose "Use Import Text Wizard"
Another option:
2. Select the text you pasted. and then Menu: Data > Text to Columns...

If someone still need help --> youtube.
void
Developer
Posts: 16762
Joined: Fri Oct 16, 2009 11:31 pm

Re: Copy as CSV

Post by void »

Excel expects TABs when pasting CSV from the clipboard.

I'll add an option to use TABs instead of commas.
However, this option will likely default to commas.

Or, I'll add a Copy as CSV (Tab Delimited) action..
NotNull
Posts: 5461
Joined: Wed May 24, 2017 9:22 pm

Re: Copy as CSV

Post by NotNull »

I think Excel remembers the import delimiter settings (Libre Office does)
So it's a onetime Excel setting to make.
Stamimail
Posts: 1122
Joined: Sat Aug 31, 2013 9:05 pm

Re: Copy as CSV

Post by Stamimail »

NotNull wrote:I think Excel remembers the import delimiter settings (Libre Office does)
So it's a onetime Excel setting to make.
I am afraid it's not true. At least in Excel 2003.
Or, I'll add a Copy as CSV (Tab Delimited) action..
+1
Debugger
Posts: 630
Joined: Thu Jan 26, 2017 11:56 am

Re: Copy as CSV

Post by Debugger »

Never choose copy because it will take too much RAM and the application will stop responding... or Out Of Memory, Overflow etc.
Stamimail
Posts: 1122
Joined: Sat Aug 31, 2013 9:05 pm

Re: Copy as CSV

Post by Stamimail »

Debugger wrote:Never choose copy because it will take too much RAM and the application will stop responding... or Out Of Memory, Overflow etc.
The (selected) results don't have to be "all items".
void
Developer
Posts: 16762
Joined: Fri Oct 16, 2009 11:31 pm

Re: Copy as CSV

Post by void »

Everything is currently setting the ANSI and UNICODE clipboard formats.

I've modified the next version of Everything to only set the UNICODE clipboard format.
This will save about 1/3 of the memory needed to copy to the clipboard as CSV.
Post Reply