CSV Utility

About

Usage

Installation

Install csv_utility via cargo with the following command

cargo install csv_utility

or build it yourself by pulling the repo.

Using CSV Utility from the Command Line

Name
        csv_utility

Author:
        Matthias Lodner <matthias.lodner@uni-ulm.de>

Description:
        csv_utility command [flags]

Flags:
        -s, --source <string>      : path to source file
        -d, --destination <string> : path to destination file
        -o, --output <string>      : path to output file
        -m, --mappings <string>    : path to mappings file
        -t, --threshold <string>   : threshold, a positiv number
        -h, --help                 : Show help

Commands:
        m, map     : Maps entries from source file to header from header file and saves to output file
        rer, rmer  : Removes empty rows from source csv file and saves to output file
        rrwt, rmwt : Remove rows with less than --threshold entries from source csv file and saves to output file
        a, append  : Appends two csv files with the same header line
        s, stats   : Shows some stats about the content of the csv file

Version:
        0.1.0

Examples

In the following examples, the table below is used as the source.csv file.

Map

In this example the content of source.csv gets mapped to the following header from dest.csv and saved to out.csv.

csv_utility map -s source.csv -d dest.csv -o out.csv

Running the command above opens a user interface with the following options:

• Map
  Let you map the columns from the source file to the destination file.
• Save mapping file
  Saves the mapping created in Map.
• Save as new mapping file
  Saves the mapping created in Map to a new mapping file.
• Cancel
  Cancels the command.
• Save and exit
  Saves the columns according to the mapping in the output file and exit afterwards.

The result looks like

rmer

Running the following command on source.csv

csv_utility rmer -s source.csv -o out.csv

Gets us out.csv with the following content:

rmwt

Running the following command on source.csv

csv_utility rmwt -s source.csv -o out.csv -t 1

Gets us out.csv with the following content:

Using the 2 for -t the output file would look like this.

append

With append the -d file get appended to the -s file and written to the output file.

csv_utility append -s source.csv -d source.csv -o out.csv

stats

The Stats command shows some information about the content of the csv file.

csv_utility append -s source.csv -d source.csv -o out.csv

Stats for in.csv
  - 3 columns
  - 9 lines total
  - 4 full lines
  - 2 partly full lines
  - 3 empty lines