jqCSV is a html client utility to manage csv files, read, filter, modify rows, add new rows, delete rows, hide/show columns, export file csv in JSON, XML, CSV, TXT, SQL and MS-Excel.
Tools presents a input field to insert commands to filter columns or summarize it.
Each command is separated from each other by comma (,).
Posible Syntaxs are :
Column Number (ex. 1)
Column Number from - Column Number to (ex 1-3 )
Column Number : Regular Expression or 'C' for sum columns values> (ex. 3:^ABC or 4:C )
Column Number starts from 1. Second parameter it's not necessary.
For example expression : 1:^.John.$,2-3,4:C,5:C in a csv with 5 Columns I want select only rows with :
- First columns contains John
- Show columns 2 and 3
- Sum columns values of columns 4 and 5
Rows Selected :
Clone this repo
Run npm install
Run npm start
Open site "http://(ip server):8080/jqCSV.html"
Visual Code Editor
- Giovanni Palleschi - gpalleschi
npm installed
This project is licensed under the GNU GENERAL PUBLIC LICENSE 3.0 License - see the LICENSE file for details