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
- -crlf
- use CRLF for end of line (EOL) on write, defaults to true on Windows
- -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.csvcsvjoin 1.3.5