Copy as CSV

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

Copy as CSV

Post by NotNull » Sun Jul 01, 2018 9:38 pm

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
Site Admin
Posts: 4844
Joined: Fri Oct 16, 2009 11:31 pm

Re: Copy as CSV

Post by void » Mon Jul 02, 2018 9:52 am

Added to my TODO list.

Stamimail
Posts: 696
Joined: Sat Aug 31, 2013 9:05 pm

Re: Copy as CSV

Post by Stamimail » Mon Jul 02, 2018 3:29 pm

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
Site Admin
Posts: 4844
Joined: Fri Oct 16, 2009 11:31 pm

Re: Copy as CSV

Post by void » Thu Jul 05, 2018 7:34 am

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: 1393
Joined: Wed May 24, 2017 9:22 pm

Re: Copy as CSV

Post by NotNull » Fri Jul 06, 2018 1:30 pm

I think Excel remembers the import delimiter settings (Libre Office does)
So it's a onetime Excel setting to make.

Stamimail
Posts: 696
Joined: Sat Aug 31, 2013 9:05 pm

Re: Copy as CSV

Post by Stamimail » Sun Jul 08, 2018 10:23 am

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: 530
Joined: Thu Jan 26, 2017 11:56 am

Re: Copy as CSV

Post by Debugger » Mon Jul 23, 2018 11:20 am

Never choose copy because it will take too much RAM and the application will stop responding... or Out Of Memory, Overflow etc.

Stamimail
Posts: 696
Joined: Sat Aug 31, 2013 9:05 pm

Re: Copy as CSV

Post by Stamimail » Tue Jul 24, 2018 9:56 am

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
Site Admin
Posts: 4844
Joined: Fri Oct 16, 2009 11:31 pm

Re: Copy as CSV

Post by void » Thu Jul 26, 2018 8:43 am

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