[New Plugin] CSV Lint
My CSV has a large number of columns and different headers every few rows. It defaults to FixedLength but after changing to CSVDelimited it just adds the text “XML” at the top and nothing changes.
Thanks for mentioning your issue. It sounds like the plug-in can’t recognise this specific data file. I suspect the file includes many
>characters as well as many
;characters or something like that. This can “confuse” the autodetect function so to speak, meaning it can’t determine which is the correct separator character, so it doesn’t interpret the data and columns correctly.
Is it possible to send the data file to my e-mail address (see About dialog)? If it contains privacy sensitive data or is too large, then maybe edit the file and just include a few lines of data to reproduce this issue?
Btw someone metioned a similar issue so in a future update I want to add a where you can (optionally) manually specify the separator character.
In the mean time you can somehow manually construct the meta data, like below.
Col1=Field1 Text Width 50
Col2=Field2 Text Width 50
Col3=Field3 Text Width 50
Col4=Field4 Text Width 50
Or alternatively, first try to delete the rows (if possible) that are causing trouble, so keep only a few rows with representative data, and then click
Refresh from data, and then apply that resulting metadata to the complete file with all the rows.
any update planned to update CSV Lint to work with current version of notepad ++
Like @Lycan-Thrope mentioned, there is a new CSV Lint v0.4.5.2 which you can manually download from the github page. That version will be included automatically in the Plugin Admin in the upcoming Notepad++ v8.4.3.
It looks like the compatibility issues with the new Lexer v5 are solved now 🤞 and I want to wait and see before continuing and adding too many other features to the plug-in.
Eric Yang last edited by
Is there a way not to change the background color? Notepad++'s default theme has white background so CSV Lint looks OK after syntax coloring. But I normally use Solarized theme (dark bg) and CSV Lint changes all the text to white background.
@Eric-Yang sorry for the late answer, I had missing this post.
You can go to the menu
Plugins -> CSV Lint -> Settingsthere is a button “Colors” to select from 4 pre-defined colorsets for the column syntax highlighting, see color preview here.
If you use a dark mode/dark background theme, then it’s best to select either
Dark mode (pastel)or
Dark mode (neon). Btw you need to close and restart Notepad++ before the new colors are visible.
With the Notepad++ update to v8.4.7 yesterday, the new Plugin Admin now also contains an update for CSVLint plug-in from v0.4.5.4 to v0.4.6.2. I hope the plugin will save everyone some time when working with csv files, let me know what you think.
It now also has a sort function and improved compatibility with Windows 11 unicode UTF8 setting. Also the default syntax highlighting now has 12 colors instead of 8, with a bit more pleasing colors imho.
See below for complete list of plugin updates and bugfixes since the last Notepad++ version:
- Improved compatibility with Windows unicode UTF8 setting
- Sort data, new option to sort on column
- Split column, add options
search and replace
- Split column, remove options
decode multiple value
- Default color sets now have 12 colors instead of 8 (less repeats) + optimal color contrast
- Settings dialog, color set preview icons
- Autodetect improved, skip empty lines + clear message when nothing detected
- Metadata for fixed width, also output absolute positions
- Apply quotes bugfix, also values that contain CrLf character
- Sort data and split column, use quotes correctly
- Sort data and split column, also support fixed width
- Detect fixed width, allow manual column positions
- Button to toggle syntax highlighting
- Allow user to change font in docked window textboxes
Thank you for the plugin. The plugin is nice, but sometimes I want to switch to the original Notepad++ view for a .csv file. Is there an option to turn off the CSV Lint view?
I have found out that switching the menu point “Language” - “CSVLint” to Language - “None (Normal Text)” is most probably the solution.
@datatraveller1 Yes you’re right , it’s the menu
Language > None (Normal Text)to clear the syntax highlighting colors from a csv file.
Btw in the latest version of the plug-in v0.4.6.2 there is also a button on the docked windows to toggle between CSV Lint colors or no syntax highlighting. It does the same thing as the
Languagemenu items though.
Fruchtzwerg94 last edited by
The latest version includes a PR which I’ve created exactly to target this issue:
PR: Added button to enable or disable language #42
Should be exactly what you are looking for in a very simple way.
le dinhyen last edited by
Hello guys i’m newbie here :( i have a csv data as below. Is there any way to align it to column like excel did?
"@ABC_INFORMATION" "ID1","ID2","ID3" "ip1","ip2",""
@le-dinhyen There is another plugin (CSVQuery) that displays the columns aligned, but this plugin is not suitable for editing. I would recommend a CSV editor for editing CSV files. (I could tell you good CSV editors, but they are not freeware).
BTW, your CSV file is not a valid CSV file. A CSV file must conform to RFC 4180 CSV rules (https://www.rfc-editor.org/rfc/rfc4180).
Each line must have the same number of fields, but your first line contains one field and the other three fields.
le dinhyen last edited by
@datatraveller1 Yes . my csv file format is specific for customer system. we used to open it by rainbow csv in visual studio. i’m just wondering if we have any function that can display the columns aligned and edit it in realtime. Thank you so much for reply