search

BdR76 / CSVLint

CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.
GNU General Public License v3.0
168 stars 11 forks source link

Option to Swap columns, rearrange and/or drop columns #96

Open pchris7489 opened 4 days ago

pchris7489 commented 4 days ago

Hello,

This is an excellent plugin for Notepad++. I love the color highlighting,the data conversion feature. I came to see that the sort feaure is great, but when sorting it is impossible to swap the columns in order to better read the data and control its quality.

For example, an option to put a column to first column (only this would be very good for validating data), or one to swap two columns (even better).

This would be very good, because I have some complex CSV and it is hard to see if a column in the middle have the required data.

Thank you for this very good plugin

BdR76 commented 4 days ago

Thanks for posting the issue, and glad to hear you like the plugin. This has some overlap with issue #95 and I can see how a dialog to "Rearrange columns" would be useful.

I'll try to add it when I have the time, probably won't be until next year though