How to Reorder columns in delimited file using awk

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

[easyazon_block add_to_cart=”default” align=”left” asin=”0596000707″ cloaking=”default” layout=”left” localization=”default” locale=”US” nofollow=”default” new_window=”default” tag=”wn0d5-20″]