USAGE

csvfind [OPTIONS] TEXT_TO_MATCH

DESCRIPTION

csvfind processes a CSV file as input returning rows that contain the column with matched text. Columns are counted from one instead of zero. Supports exact match as well as some Levenshtein matching.

OPTIONS

Below are a set of options available.

    -allow-duplicates         allow duplicates when searching for matches
    -append-edit-distance     append column with edit distance found (useful for tuning levenshtein)
    -case-sensitive           perform a case sensitive match (default is false)
    -col, -cols               column to search for match in the CSV file
    -contains                 use contains phrase for matching
    -d, -delimiter            set delimiter character
    -delete-cost              set the delete cost to use for levenshtein matching
    -examples                 display example(s)
    -generate-manpage         generation man page
    -generate-markdown        generation markdown documentation
    -h, -help                 display help
    -i, -input                input filename
    -insert-cost              set the insert cost to use for levenshtein matching
    -l, -license              display license
    -levenshtein              use levenshtein matching
    -max-edit-distance        set the edit distance thresh hold for match, default 0
    -nl, -newline             include trailing newline from output
    -o, -output               output filename
    -quiet                    suppress error messages
    -skip-header-row          skip the header row
    -stop-words               use the colon delimited list of stop words
    -substitute-cost          set the substitution cost to use for levenshtein matching
    -trim-leading-space       trim leadings space in field(s) for CSV input
    -trimspace, -trimspaces   trim spaces around cell values before comparing
    -use-lazy-quotes          use lazy quotes on CSV input
    -v, -version              display version

EXAMPLES

Find the rows where the third column matches “The Red Book of Westmarch” exactly

csvfind -i books.csv -col=2 "The Red Book of Westmarch"

Find the rows where the third column (colums numbered 1,2,3) matches approximately “The Red Book of Westmarch”

csvfind -i books.csv -col=2 -levenshtein \
   -insert-cost=1 -delete-cost=1 -substitute-cost=3 \
   -max-edit-distance=50 -append-edit-distance \
   "The Red Book of Westmarch"

In this example we’ve appended the edit distance to see how close the matches are.

You can also search for phrases in columns.

csvfind -i books.csv -col=2 -contains "Red Book"

csvfind v0.0.25