Here is very useful command line to help you out to nicely reorder columns in delimited file with using awk.
cat mybigfile.txt | awk 'BEGIN{FS="," OFS="|";} {print $1,$2,$4,$5,$6;}' > sourtedoutfile.txt
Here is very useful command line to help you out to nicely reorder columns in delimited file with using awk.
cat mybigfile.txt | awk 'BEGIN{FS="," OFS="|";} {print $1,$2,$4,$5,$6;}' > sourtedoutfile.txt