Possible bug when field-separator used

[Jeroen Hoek]

Hello!

I was trying to sum up values from a CSV input, and I am seeing 
something odd.

Tested in datamash 1.4 and 1.8.


This works:


# Tab separated input, sum column 2 and 3.

echo -e "a\t14\t1\nb\t1\t14\na\t2\t1" | \
    datamash -s groupby 1 sum 2,3


# Space separated input, sum column 2 and 3.

echo -e "a 14 1\nb 1 14\na 2 1" | \
    datamash --field-separator=' ' -s groupby 1 sum 2,3


# Semicolon separated input, sum column 2 and 3.

echo -e "a;14;1\nb;1;14\na;2;1" | \
    datamash --field-separator=';' -s groupby 1 sum 2,3


# Comma separated input, sum ONLY column 3.

echo -e "a,14,1\nb,1,14\na,2,1" | \
    datamash --field-separator=, -s groupby 1 sum 3


This fails:


# Comma separated input, sum column 2 and 3.

echo -e "a,14,1\nb,1,14\na,2,1" | \
    datamash --field-separator=, -s groupby 1 sum 2,3

datamash: invalid numeric value in line 1 field 2: '14'


Is this a bug or Am I overlooking something?

Kind regards,

Jeroen Hoek

OpenPGP_signature.asc
Description: OpenPGP digital signature