Bash/Linux - Compare decimal numbers in a script, data from a .csv column

Question

I am trying to compare the decimal numbers in a column one by one. These comparisons are made with respect to constants.

I want to count the number of times the condition is true. But this part is ok.

The file with the data is a csv separated by ";" and the decimals are separated by a "."

I have the following code, but I have not achieved anything.

fixed_acidity_filter=$(awk 'BEGIN{FS=";"} {if($1>0 && $1<15) ]{print}}' winequality-white_sincabecera.csv | wc -l)

Can anyone help me?

Please add sample input (no descriptions, no images, no links) and your desired output for that sample input to your question (no comment). — Cyrus
– Cyrus, Commented May 25, 2020 at 7:47
Does How to compare two decimal numbers in Bash/Awk? or How to compare two floating point numbers in Bash? answer your question? — U880D
– U880D, Commented May 25, 2020 at 7:53
@Alorher, probably typo, but you have syntax error in your code in question. And BTW, there are better tools for your task than awk. You probably know. — Petr Matousu
– Petr Matousu, Commented May 25, 2020 at 7:59

Petr Matousu · Accepted Answer · 2020-05-25 08:03:13Z

1

# concept
echo -e "20\n10\n18\n15\n13\n21" | awk '{if($1>0 && $1<15) print $1}'
# your code
echo -e "20;10\n10;10\n18;10\n15;10\n13;10\n21;10" | awk 'BEGIN{FS=";"} {if($1>0 && $1<15) print $1}' | wc -l

answered May 25, 2020 at 8:03

Petr Matousu

3,1501 gold badge22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alorher Over a year ago

Thanks for the reply but it doesn' work. And I don't understand this part of the code "echo -e "20;10\n10;10\n18;10\n15;10\n13;10\n21;10". Thanks again

Petr Matousu Over a year ago

Try in terminal and you will understand. It just simulates your input.

Collectives™ on Stack Overflow

Bash/Linux - Compare decimal numbers in a script, data from a .csv column

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related