HN
login
CSV Lint update (Notepad++) text data syntax highlighting and quality validationgithub.com

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 un...

3 points•BdR1976•2 days ago•4 comments•
#csv#lint#validation#syntax#highlighting#notepad#data#csv lint

4 comments

BdR19762 days ago
CSV Lint plug-in for Notepad++ was updated recently to v0.4.9 which adds support for regular expressions when validating columns. A previous update added the new "Select Columns" dialog to easily select, delete and rearrange columns.

CSV Lint adds syntax highlighting, csv validation, automatic column and datatype detection. The plug-in can update the column separator, datetime format, decimal separator, sort data, count unique values and convert data to an SQL INSERT script. Supports both csv and fixed width text data. The plugin can be used for data quality control on text data files.

Validating your .csv data doesn't require uploading your files to any third party server, all data processing is done offline on the PC that runs Notepad++.

MiroslavPokorny2 days ago
Is there a "defacto" standard for CSV schemas ?
BdR19761 day ago
There's the open source W3C CSV schema (in JSON format) and the schema.ini from the text file driver by Microsoft, both haven't been updated in a while.

The plugin tries to stay mostly compatible with schema.ini. The most obvious missing features are no skiplines or comment characters, but the plug-in works around this using ; comment lines.

Btw I tried contacting Microsoft to add a "skiplines" to the text file driver, but I get the impression it's not in active development anymore -> https://learn.microsoft.com/en-us/answers/questions/1640430/...

MiroslavPokorny2 days ago
followed thanks for sharing.

Read the full thread on Hacker News →

Related stories