From 09410d75a6e0314afbb2cd60eee82743fa79620f Mon Sep 17 00:00:00 2001 From: typebrook Date: Tue, 29 Oct 2019 14:57:36 +0800 Subject: update --- scripts/csv_reorder | 18 ++++++++++++++++++ scripts/reorder_csv | 18 ------------------ 2 files changed, 18 insertions(+), 18 deletions(-) create mode 100755 scripts/csv_reorder delete mode 100755 scripts/reorder_csv (limited to 'scripts') diff --git a/scripts/csv_reorder b/scripts/csv_reorder new file mode 100755 index 0000000..a62701f --- /dev/null +++ b/scripts/csv_reorder @@ -0,0 +1,18 @@ +#! /bin/bash + +# show each field with index in csv +echo -------------- > /dev/tty +head -1 < $1 | sed 's/,/ /g' | awk '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' > /dev/tty +echo -------------- > /dev/tty +echo > /dev/tty + +# get index of lon/lat column +read -p "Move which column? " origin_col +read -p "To which index? " new_col + +cat $1 | +# move lon and lat to the first and second column +awk -F',' -v OFS="," -v origin_th=$origin_col -v new_th=$new_col '\ + {for (i=1; i<= NF; i++) if (i == new_th) printf $origin_th OFS $i OFS; else if (i == origin_th); else printf $i OFS; print ""}\ + ' |\ +sed 's/,$//g' diff --git a/scripts/reorder_csv b/scripts/reorder_csv deleted file mode 100755 index a62701f..0000000 --- a/scripts/reorder_csv +++ /dev/null @@ -1,18 +0,0 @@ -#! /bin/bash - -# show each field with index in csv -echo -------------- > /dev/tty -head -1 < $1 | sed 's/,/ /g' | awk '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' > /dev/tty -echo -------------- > /dev/tty -echo > /dev/tty - -# get index of lon/lat column -read -p "Move which column? " origin_col -read -p "To which index? " new_col - -cat $1 | -# move lon and lat to the first and second column -awk -F',' -v OFS="," -v origin_th=$origin_col -v new_th=$new_col '\ - {for (i=1; i<= NF; i++) if (i == new_th) printf $origin_th OFS $i OFS; else if (i == origin_th); else printf $i OFS; print ""}\ - ' |\ -sed 's/,$//g' -- cgit v1.2.3-70-g09d2