Dear all I have a big data file lets say file.dat, it contains two columns
e.g file.dat (showing few rows)
0.0000 -23.4334 0.0289 -23.4760 0.0578 -23.5187 0.0867 -23.5616 0.1157 -23.6045 0.1446 -23.6473 0.1735 -23.6900 0.2024 -23.7324 0.2313 -23.7745 0.2602 -23.8162 0.2892 -23.8574 0.3181 -23.8980 0.3470 -23.9379 0.3759 -23.9772 0.4048 -24.0156 0.4337 -24.0532 0.4627 -24.0898 0.4916 -24.1254 note: data file has a blank line at the end of the file Expected results
I want to find/extract the maximum and minimum from both the column e.g column-1
max - 0.4916 min - 0.0000 similarly column-2
max - -23.4334 min - -24.1254 Incomplete solution (not working for column-2)##
For Column-1
awk 'BEGIN{min=9}{for(i=1;i<=1;i++){min=(min<$i)?min:$i}print min;exit}' file.dat 0.0000 cat file.dat | awk '{if ($1 > max) max=$1}END{print max}' 0.4916 for column-2
awk 'BEGIN{min=9}{for(i=2;i<=2;i++){min=(min<$i)?min:$i}print min;exit}' file.dat -23.4334 cat file.dat | awk '{if ($2 > max) max=$2}END{print max}' **no output showing** Problem
Please help me to find the min and max value from column-2 note: data file has a blank line at the end of the file
