Dendrite

A command-line tool to disaggregate rows in a csv by a "AND"-delimited field

What we have

name,address,date
Naomi and Bob,123 Main St,2018-03-01
Ethan,22 Maple St,2017-12-05
"John,Sybil",22 Oak Ln,2016-2-21

What we want:

name,address,date
Naomi,123 Main St,2018-03-01
Bob,123 Main St,2018-03-01
Ethan,22 Maple St,2017-12-05
John,22 Oak Ln,2016-2-21
Sybil,22 Oak Ln,2016-2-21

Note that Dendrite will disaggregate rows on standard "AND" separators found in the target field. These include &, and, and ,.

Install

npm install -g fdy-dendrite

Usage

dendrite -i <input filename> -f <split field name> -o <output filename>

Arguments

• -i, --input (REQUIRED) Input filename and path (e.g. '/home/ubuntu/inputfile.csv')
• -f, --field (REQUIRED) Name of delimited field on which to duplicate rows (e.g. name)
• -o, --output (OPTIONAL) Output filename and path. Default is the input filename with 'out_' prepended.