![]() ![]() Instantly zoom the interface with the F11/F12 keys.The program is designed generally for the Windows. Multiple rows can be selected and deleted in one step. PDFtoPrinter is a program for printing PDF files from the Windows command line.Drag and drop of rows, columns, and text.Automatically creates a backup before overwriting a file.Imports databases and Excel spreadsheets.While not easily readable when not split across columns and rows, you should be able to. For 8-bit files, you may choose a code page. csv file in a text editor like Notepad on Windows, or TextEdit on MacOS. Supports UTF-8 and UTF-16 encoded files and unicode characters.The CSV data can be displayed as a graph, histogram, or pie chart.Cut, copy, and paste rows from one CSV file to another, even if they have different column names.Search and replace on the entire table or a single column.Full set of text editing tools: spell checking, keyboard macros, calculator, calendar, character map, and much more.The filter can look for a simple phrase, a search engine style query, regular expression, or even a conditional such as "amount < 50". "Filter Mode" will hide all rows that don't meet a specific criteria.You can jump directly to a damaged line and fix it by shifting cells left or right. Warns if any line of data has too many or too few fields.Supports an optional "multiline editing mode" where you can edit multiple lines of text in a cell.Tabbed Document Interface allows you to open and edit multiple files. I suggest VS-Code, since its cross platform, and because it probably has some kind of plug-in to make it less painful (and editing CSV data is painful).Full set of tools for manipulating columns and rows: insert, delete, copy, paste, duplicate, rearrange, and shift.The sed command takes care of changing those empty values to a space. I updated the command to fix a problem with handling empty entries, such as “…,data,data,…”. For example, all commas will be treated as separating out columns, even if the comma is escaped by quotes or a backslash. Since I’m tying together various command line tools that have no concept of the CSV format, there are some contents that this does not handle well. You can increase or decrease this as needed to make navigating easier.įor those interested, I’ve tested this on Debian-based (Ubuntu, Mint, etc) and Redhat-based (CentOS) systems, and it works on all of them. The -#5 determines how many columns to scroll when using the left and right arrow keys. ![]() To use for your files, simply replace file.csv in the above example with your file’s name. The output is easy to navigate with the cursor keys and is perfect for quickly verifying the generated data. Using a combination of the cat, column, and less commands that are available from most *nix shells, the CSV data can be rendered into a nice table and quickly navigated. Sure, I could transfer the files to my local system and open them up in OpenOffice Spreadsheet or a similar program, but I want to do quick checks of the generated data and constantly copying the data and opening it up again in a program would just slow me down. The CSV files work well for using in other scripts, but they are a bit difficult to read in order to verify that the data looks good. I recently wrote a script to dump data into CSV files. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |