hfmrow / csveditor Goto Github PK

A simple software to Edit, create, modify, search, sort, save csv files.

• It is not designed to use with large csv files (over 10k entries), at the risk of longer processing times.
• An issue exist with columns list, in option tab or edition window when you have more than 16 fields (columns) and screen size of 1080 pixels height. The window haven't vertical scroll bar so you get some columns and "ok", "cancel" buttons to be invisible. Simply use [alt]+left mouse button to move whole window.

• Programmed with go language: golang
• GUI provided by andlabs go-libui, Platform-native GUI library for Go.

• Edition, on the fly or using fields window.
• Adding/Removing/Duplicating row.
• Adding/Removing fields.
• Create new csv file.
• Auto detection of field names row.
• Auto set of fields type (string, date, numeric).
• Searching on whole document.
• Sorting by string, date, numeric type. (option must be set for date format and numeric values for decimal separator if needed). The Sort By Date feature allows you to automatically recognize the date in a string.
• Selection of displayed fields.
• Selection of saved fields.
• Option for saving csv: charset type, line-end type, comma character.
• Load csv via command line.

This is the main screen.

New row window. If no line is checked, you get this window. If one or more lines are checked, you get an edit window with a duplicate option for the last checked line. You can check [Cell editing on the fly] at the bottom left to edit a row directly by double-clicking a cell.

Search option. Everything is said looking at the picture

Selecting the table, Where you can change the target table, you have 3 modes, main, search and sort. Only the "main" tables have possibility to modify the options, "search" and "sort" can be sorted, searched, saved, edited. If you want to change the column options, you must select the main view, otherwise the option is grayed out.

Options tab. Output file depend on selected options, field types are used in sort tab to define type of sorting, decimal character and date format are also used in it.

Sort tab. The sort order must be taken into consideration to obtain the desired result

• Be sure you have golang installed in right way. Go installation.

• Open terminal window and at command prompt, type: go get github.com/hfmrow/csveditor

• If you have a problem with GTK, please check at andlabs go-libui for gui installation instruction.

    Debian, Ubuntu, etc.: sudo apt-get install libgtk-3-dev
    Red Hat/Fedora, etc.: sudo dnf install gtk3-devel
  

• I'm working on linuxmint 18.3 (more informations available under release tab).
• I haven't tested compilation under Windows or Mac OS, but all file access functions, line-end manipulations or charset implementation are made with OS portability in mind.

• Sorry, no issue accepted for this EOL project.

• H.F.M Linux softwares Free linux software on Github. Sharing knowledge.