fdy-dendrite

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

Usage no npm install needed!

<script type="module">
  import fdyDendrite from 'https://cdn.skypack.dev/fdy-dendrite';
</script>

README

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.