csvjoin.1.md

%csvjoin(1) user manual | version 1.2.12 03b4ff7 % R. S. Doiel % 2024-11-14

NAME

csvjoin

SYNOPSIS

csvjoin [OPTIONS] CSV1 CSV2 COL1 COL2

DESCRIPTION

csvjoin outputs CSV content based on two CSV files with matching column values. Each CSV input file has a designated column to match on. The values are compared as strings. Columns are counted from one rather than zero.

OPTIONS

-help : display help

-license : display license

-version : display version

-allow-duplicates : allow duplicates when searching for matches

-case-sensitive : make a case sensitive match (default is case insensitive)

-col1 : column to on join on in first CSV file

-col2 : column to on join on in second CSV file

-contains : match columns based on csv1/col1 contained in csv2/col2

-csv1 : first CSV filename

-csv2 : second CSV filename

-d, -delimiter : set delimiter character

-delete-cost : deletion cost to use when calculating Levenshtein edit distance

-in-memory : if true read both CSV files

-insert-cost : insertion cost to use when calculating Levenshtein edit distance

-levenshtein : match columns using Levensthein edit distance

-max-edit-distance : maximum edit distance for match using Levenshtein distance

-o, -output : output filename

-quiet : supress error messages

-stop-words : a column delimited list of stop words to ingnore when matching

-substitute-cost : substitution cost to use when calculating Levenshtein edit distance

-trim-leading-space : trim leading space in field(s) for CSV input

-trimspaces : trim spaces around cell values before comparing

-use-lazy-quotes : use lazy quotes for CSV input

-verbose : output processing count to stderr

EXAMPLES

Simple usage of building a merged CSV file from data1.csv and data2.csv where column 1 in data1.csv matches the value in column 3 of data2.csv with the results being written to merged-data.csv..

    csvjoin -csv1=data1.csv -col1=2 \
       -csv2=data2.csv -col2=4 \
       -output=merged-data.csv

csvjoin 1.2.12