Rons Data Edit

​The CSV Editor plugin for JetBrains IDEs introduces CSV (Comma-Separated Values) as a recognized language, providing syntax definition, structured language elements, and associated file types (.csv/.tsv/.psv). This enables default editor features like syntax validation, highlighting, and inspections for CSV-like files. It supports customizable text and table editors, flexible table editing, syntax validation, customizable syntax highlighting and formatting, quick-fix inspections, and intentions such as quoting/unquoting and shifting columns. It accommodates various value separators, and tab, with support for custom separators and line comments. The table editor allows adding or removing rows and columns via context menus and supports key bindings for efficient navigation and manipulation.

Rons Data Stream is a windows application designed to clean, or update, multiple data sources within seconds, whatever the size of the files, through the use of Cleaners. "Cleaners" are made up of a list of operations that are selected from a broad list of Column, Row and Cell processing rules. They can be built, saved and applied to as many data sources as required, and re-used with as many Jobs as needed. The Preview window displays both the original data and a preview of the processed data. The result of each rule is therefore very clear and comprehensible. "Jobs" contain all the detail needed for batch processing allowing 100's of data files to be processed in one go, making cleaning a whole directory an easy task. Rons Data Stream handles tabular text formats (CSV, HMTL, XML files and tokenized formats), SQL and Parquet, from loading to converting. It can work individually or hand in hand with Rons Data Edit, adding power to both applications.