1head -1 /Users/ctxm1pro/Desktop/08jun.csv > /tmp/header.csv && tail -n +2 /Users/ctxm1pro/Desktop/08jun.csv | awk -F, '{split($1,d,"/"); print d[3]d[2]d[1]","$0}' | sort | cut -d, -f2- > /tmp/sorted.csv && cat /tmp/header.csv /tmp/sorted.csv > /Users/ctxm1pro/Desktop/08jun_sorted.csv && echo "CSV sorted by date in ascending order and saved as 08jun_sorted.csv"
Created on 6/8/2025