Город МОСКОВСКИЙ
00:07:37

CSV Lint plug-in for Notepad++, view and edit text data more easily

Аватар
Python путеводитель
Просмотры:
72
Дата загрузки:
02.12.2023 12:18
Длительность:
00:07:37
Категория:
Технологии и интернет

Описание

The CSV Lint plug-in for Notepad++ is useful when working with CSV files (comma separated values) and fixed width text files. It adds syntax highlighting to a csv file, so display each column in a different color, automatically detect the column meta data and data types, it can validate data and check for errors, reformat datetime and decimal values, count unique values and it can generate a data analyze report and SQL insert script.

CSV Lint is somewhat similar to Rainbow CSV or CudaText CSV, except it also recognizes column datatypes, it can convert datetime and decimal values and it has additional processing and data validation features.

0:00 How to install
1:30 Syntax highlight colors
3:25 Meta data
4:22 Validate data
5:21 Reformat data
6:25 Other features

CSV Lint plug-in on GitHub
https://github.com/BdR76/CSVLint

If you want to support this project, you can buy me a coffee.
https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=US5SMK2DC6TXE

This is not strictly CSV Lint related, but if you have a Microsoft account, you can help me by upvoting my two csv questions on the Microsoft feedback page, thanks
https://feedback.azure.com/d365community/search/?q=schema.ini

* The data in this video is not real production data, it is randomly generated test data, see https://github.com/BdR76/RandomValuesNPP

Рекомендуемые видео