![]() I found a terminal-based editor, but its keybindings were beyond my comprehension and I frequently destroyed my CSV files. Plaintext editors are a nuisance and I end up playing “count the commas”. ![]() Excel and other spreadsheet programs just mangle CSV format. I can chew through 100s of GB of data without batting an eye.īut hand-editing individual rows in CSV files has _always_ been a headache. I can slap together pipelines using xsv, perl, sed, csvkit, awk, grep, and countless other CLI utilities in my sleep. The CSV files varied in size from a 10s to 100s of rows, each one needing to be lovingly entered by hand. It can load up to 11 times faster than Excel.I inherited an ETL system that used a set of CSV files to “program” the ETL process. Modern CSV comes with a read-only mode that loads large files quickly and with a small memory footprint just a fraction of the file size. You can also manually hide whichever rows or columns you want. The filters use a powerful syntax that is clearly described in the filter query. The sort feature uses stable sort so the order of other columns is preserved as much as possible. The find/replace feature has options for searching with regular expressions, highlighting matches, limiting search to a range of cells, or previewing replace operations before you perform them. Modern CSV has powerful features for finding and arranging your CSV data. ![]() ![]() ![]() You can call any command with a keyboard shortcut which you can customize. Furthermore, most commands work on multiple rows, columns, or cells at once. If you need to move a column, duplicate a row, split cells, convert date/time formats, or any number of other operations, you can do so with a single command. Modern CSV makes it easy to quickly edit your files. It makes up for the weaknesses of spreadsheet programs in handling CSV files while incorporating the strengths of the best text editors. Modern CSV is a tabular file editor/viewer with advanced editing features and large file handling. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |