Search Results

For the wrap around at 9999, tryawk -F, '
{$3=sprintf ("%04d", ($3 == $4)?0:($3+1)%1E4)
}
$2!="N"
' OFS=, file

Try awk -F, '
{$3=sprintf ("%04d", ($3 == $4)?0:$3+1)
}
$2!="N"
' OFS=, file

scenario
1. will be met if you double quote the "N" (instead of single quoting). Pls note that line 4 will not be read/printed if script exits on line 3, and your output wouldn't match this.
2. is...