Thanks, nice to hear you found it useful 😃 I'm curious, which feature was the "lifesaver" part, the csv-to-sql or just the highlighting colors, or something else?
I didn't realize there was a dark mode. I kinda got used to the default colors. They are super easy to see. I'm actually having a hard time adjusting to dark mode now. I'm not sure if I really like it better
Yes Notepad++ has darkmode support for a while now. The CSV Lint plugin has color schemes for dark-mode syntax highlighting, but the dialogs will always display in default light-mode. I don't quite know how to fix this, but maybe in a future release.
Can you tell if there's a limit to the coloring when having a file of 494.909.156 bytes with 335.465 lines and 188 columns being semicolon separated? Asking as it seems to not do the trick for this file while it perfectly does for others.
Currently in v0.4.4 there is still a known issue with opening really large files (around 50 MB or larger). The syntax highlighting takes too long to render, which causes Notepad++ to freeze. Rendering the colors on a separate thread in the backgound could fix this, that option will be available in the next update.
I can't seem to make the highlighting work with any separator other than ; using current latest version of notepad++, want to use , the column auto detection tool works, but the highlight only picks up on ; symbol
Hello, this is really an amazing pluggin! I am trying to make a localization files for my progect in csv format and I use 4 symbols as a separator, comma with space in quotes (", ") so for now I use Delimited(") and have some spare comma columns, so it would be cool if you could use not char, but string as a separator, something like Delimited(", "). Also, im not sure if this is possible with notepad++ but some sort of arrangement of values in more spreadsheet like form would be also quite handy, but colors are already good enough. So, huge thanks for the plugin and keep up the great work!
Thanks for the suggestion, to arrange the data like a spreadsheet you can go to Reformat -> check Align vertically -> press OK. Using more than one character as separator isn't possible, that would require a complete overhaul of the plug-in. However in the latest update v0.4.5 there is an update to recognise white space before quotes. Meaning you just can set it to Format=CSVDelimited and the plugin will interpret line "abc", "test", "123", "etc" correctly
Thanks, that's nice to hear you found it useful 😃 The column headers do get the same colors, but maybe it's obscured by the selection line (blue row)? You could try selecting a different colorset from the menu "CSVLint > Settings".
Seems like a nice plugin, but I was hoping it had some display features to align the columns. I want to edit CSV-files, in a sheet, but without text formatting. If I use Excel, and copy text from a web-page, it's more hassle to paste without formatting.
If I use tab as delimiter, it is a workaround to use increase the tab-setting, but I would love if the view automatically aligned the columns with the width in the metadata.
Thanks for the comment, the CSV Lint plugin was mainly created for error checking and data cleaning. It has column syntax highlighting but it doesn't have a visual column align mode. Although there is an option "Reformat > Align vertically" but this does add extra spaces to the text data. There's also plugin Columns++ I haven't tried it extensively but maybe that plugin better suits your needs?
Thanks for the comment, yes I was aware of this. There is a new version 0.4.5.1 which fixes this issue. It will be automatically available in the next Notepad++ update, but in the meantime you can install it manually. Go to github and then "releases" and download the CSVLint_x64.zip and see "How to install" on the main page.
The CSV Lint plugin was updated recently, and in the newest version at "add new column" you can right click to deselect all options and remove a column with the "Remove original column" checkbox, see more info here github.com/BdR76/CSVLint/tree/master/docs#remove-original-column
Go to the menu item "Plugins > CSV Lint > CSV Lint window" (or click the small toolbar icon), then press "Reformat" button, click only the checkbox "Align vertically" and press OK. Btw make sure the textbox below the Reformat button contains the correct columns metadata before clicking the "Reformat" button, you can click "Detect columns" to automatically detect the metadata.
love it, show many use of csv lint
This was a lifesaver, thanks for such a great tutorial!
Thanks, nice to hear you found it useful 😃 I'm curious, which feature was the "lifesaver" part, the csv-to-sql or just the highlighting colors, or something else?
I didn't realize there was a dark mode. I kinda got used to the default colors. They are super easy to see. I'm actually having a hard time adjusting to dark mode now. I'm not sure if I really like it better
Yes Notepad++ has darkmode support for a while now. The CSV Lint plugin has color schemes for dark-mode syntax highlighting, but the dialogs will always display in default light-mode. I don't quite know how to fix this, but maybe in a future release.
Can you tell if there's a limit to the coloring when having a file of 494.909.156 bytes with 335.465 lines and 188 columns being semicolon separated?
Asking as it seems to not do the trick for this file while it perfectly does for others.
Currently in v0.4.4 there is still a known issue with opening really large files (around 50 MB or larger). The syntax highlighting takes too long to render, which causes Notepad++ to freeze. Rendering the colors on a separate thread in the backgound could fix this, that option will be available in the next update.
Amazing plugin! Thank you!
I can't seem to make the highlighting work with any separator other than ;
using current latest version of notepad++, want to use ,
the column auto detection tool works, but the highlight only picks up on ; symbol
nvm the problem magically fixed itself, potentially due to line endings or something
Hello, this is really an amazing pluggin! I am trying to make a localization files for my progect in csv format and I use 4 symbols as a separator, comma with space in quotes (", ") so for now I use Delimited(") and have some spare comma columns, so it would be cool if you could use not char, but string as a separator, something like Delimited(", "). Also, im not sure if this is possible with notepad++ but some sort of arrangement of values in more spreadsheet like form would be also quite handy, but colors are already good enough. So, huge thanks for the plugin and keep up the great work!
Thanks for the suggestion, to arrange the data like a spreadsheet you can go to Reformat -> check Align vertically -> press OK. Using more than one character as separator isn't possible, that would require a complete overhaul of the plug-in.
However in the latest update v0.4.5 there is an update to recognise white space before quotes. Meaning you just can set it to Format=CSVDelimited and the plugin will interpret line "abc", "test", "123", "etc" correctly
Thanks for giving us this very useful tooling! Could it be made possible to have the column header getting the same colors as the columns?
Thanks, that's nice to hear you found it useful 😃 The column headers do get the same colors, but maybe it's obscured by the selection line (blue row)? You could try selecting a different colorset from the menu "CSVLint > Settings".
Just wanted to let you know, the next update v0.4.5 makes the cursor line transparent, so column colors are always visible.
Seems like a nice plugin, but I was hoping it had some display features to align the columns.
I want to edit CSV-files, in a sheet, but without text formatting.
If I use Excel, and copy text from a web-page, it's more hassle to paste without formatting.
If I use tab as delimiter, it is a workaround to use increase the tab-setting, but I would love if the view automatically aligned the columns with the width in the metadata.
And I want to keep the tab width for coding purposes.
Thanks for the comment, the CSV Lint plugin was mainly created for error checking and data cleaning. It has column syntax highlighting but it doesn't have a visual column align mode. Although there is an option "Reformat > Align vertically" but this does add extra spaces to the text data.
There's also plugin Columns++ I haven't tried it extensively but maybe that plugin better suits your needs?
Hey, friend. Very good work! Love this plugin. Unfortunately it's not working on version 8.4. Are you aware of this version?
Thanks for the comment, yes I was aware of this. There is a new version 0.4.5.1 which fixes this issue. It will be automatically available in the next Notepad++ update, but in the meantime you can install it manually. Go to github and then "releases" and download the CSVLint_x64.zip and see "How to install" on the main page.
How do you delete columns?
The CSV Lint plugin was updated recently, and in the newest version at "add new column" you can right click to deselect all options and remove a column with the "Remove original column" checkbox, see more info here github.com/BdR76/CSVLint/tree/master/docs#remove-original-column
great video and great tool!
how do I get the CSV values to be vertically aligned like columns are in excel?
Go to the menu item "Plugins > CSV Lint > CSV Lint window" (or click the small toolbar icon), then press "Reformat" button, click only the checkbox "Align vertically" and press OK.
Btw make sure the textbox below the Reformat button contains the correct columns metadata before clicking the "Reformat" button, you can click "Detect columns" to automatically detect the metadata.
@@BdR76 worked like a charm, thanks a bunch - loving the dark mode and config options combined with this 🤌