CSVLint icon indicating copy to clipboard operation
CSVLint copied to clipboard

Option to copy specific column data

Open tiniwings opened this issue 1 year ago • 2 comments

Hi, can you please provide option to copy specific column data into clipboard in "CSV Lint Window"? Similar feature is available here, but I mostly use CSV lint for my work. (https://github.com/daddel80/notepadpp-multireplace?tab=readme-ov-file#csv-processing-functions) Also, a shortcut to settings window in "CSV Lint Window" will be helpful. Thanks.

tiniwings avatar Oct 11 '24 15:10 tiniwings

Thanks for the suggestions. The Settings button on the CSV Lint window kind of makes sense, could be useful so I'll try to add it when I have time.

As for copying specific columns to the clipboard, technically it could be added but I don't quite understand what you would use that for exactly 🤔 Can you explain why you need this?

There is already a menu option Count unique values which does this functionality almost but not quite. It's kind of similar except it deduplicates the values of the column(s), the result is only the unique values.

If you want to copy separate column(s), the way I do it is Reformat it to TAB separated, then copy all ctrl+A ctrl+C and paste it into a new empty spreadsheet (Excel, LibreOffice Calc etc.), and from there you can copy any individual column. CSV Lint is mainly a quality control tool or dataset validator tool, so I don't quite see the use-case for a "Copy column(s)" function, can you clarify it?

BdR76 avatar Oct 12 '24 20:10 BdR76

Hi, thanks for the response.

As you explained, if user want to share/copy specific columns fom the master file. Its a direct and quick option instead of going via excel route, which is one more dependency.

If its too much work/will add additional overhead for the plug in, you can discard this request.

"If you want to copy separate column(s), the way I do it is Reformat it to TAB separated, then copy all ctrl+A ctrl+C and paste it into a new empty spreadsheet (Excel, LibreOffice Calc etc.), and from there you can copy any individual column."

tiniwings avatar Oct 12 '24 20:10 tiniwings

The Settings button is now added to the main window, see update 0.4.6.8

Adding the option to copy specific columns isn't in yet. Unfortunately I still don't have the time to work on adding any "bigger" features at the moment, but it's at the top op the list for any next update.

BdR76 avatar Feb 28 '25 11:02 BdR76

I've added a new menu item "Rearrange columns" which can copy column data to a new file tab. It doesn't copy the data directly to the clipboard but you can select the new tab and do Ctrl+A and Ctrl+C

It will be in the next update, or you grab a beta version 0.4.6.9β from here, let me know what you think.

BdR76 avatar Jul 28 '25 21:07 BdR76

Thank you for looking into this, I will wait for the release.

I am making this request closed now. Once again thank you.

tiniwings avatar Jul 29 '25 13:07 tiniwings

Fyi the new Select Column dialog is available in the latest release, see v0.4.7 on the releases page.

It won't be available throught the Plugins Admin menu item until the next Notepad++ release, probably next month.

BdR76 avatar Aug 10 '25 10:08 BdR76