How to use if-else statement within while loop in shell script?

Asked Jul 23 '18 at 14:40

Active Jul 23 '18 at 15:07

Viewed 1,179 times

I've got some problems when comparing two variables in my CSV

here's my code

#!/bin/bash
exec < /path/to/file/PARAM.csv || exit 1
read header # read (and ignore) the first line
while IFS=, read table column; do
    if [[ $column = "NULL" ]]; then
        echo "empty"
    else
        echo $column
    fi
done

in my file there are some fields that have "NULL" values, but the comparison isn't working, it always print the $column

Here is some example in my CSV :

MAIN_RPT_STD010,NULL
MAIN_RPT_STD030,NULL
MAIN_RPT_STD050,NULL
MAIN_RPT_STD070,NULL
MAIN_RPT_STD090,NULL
MAIN_ACTIVO,BUSS_DATE
MAIN_ACTUAL_SCORECARD,BUSS_DATE

edited Jul 23 '18 at 15:07

asked Jul 23 '18 at 14:40

afghifari

Add some sample input to the question. – Barmar Jul 23 '18 at 15:03
@Barmar there are some changes – afghifari Jul 23 '18 at 15:08
2

Make sure the file doesn't have Windows CRLF line endings. – Barmar Jul 23 '18 at 15:14
Try wildcard `if [[ "$column" == *NULL* ]];` – Mark Setchell Jul 23 '18 at 15:16
Your script works fine for me. I'll bet there's either a space or CR after `NULL`. – Barmar Jul 23 '18 at 15:16
@Barmar thanks man, that was a CRLF problem. you saved my life – afghifari Jul 23 '18 at 15:18

How to use if-else statement within while loop in shell script?

0 Answers0