The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

merge_csv_files.pl - Command line client to Text::CSV::Merge

VERSION

version 0.03

Synopsis

    merge_csv_files.pl \
        --base=merge_into.csv \
        --merge=merge_from.csv \ 
        --columns=EMAIL,FNAME,LNAME,LOCATION,JAN,FEB,MAR,APR,MAY,JUN \
        --output=merge.csv \
        --search=EMAIL \
        --first-row-is-headers

Description

You have two CSV files with mostly the same column names. But, the 'base' CSV files has gaps in its data, i.e. some cells are empty. Another CSV has data, but its too laborious to comb through it by hand. Use this CLI to fill in the gaps.

Options

Required Options

base

merge

columns

Optional Options

output

first-row-is-headers

Default is 1, or TRUE (Remember, Perl has no built-in Boolean).

AUTHOR

Michael Gatto <mgatto@lisantra.com>

COPYRIGHT AND LICENSE

This software is copyright (c) 2013 by Michael Gatto.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.