From ddafd9c1f61bb2a359a254e99d637cd6dba4b6ce Mon Sep 17 00:00:00 2001
From: typebrook <typebrook@gmail.com>
Date: Sun, 17 Nov 2019 11:11:13 +0800
Subject: update

---
 scripts/csv.reorder | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100755 scripts/csv.reorder

(limited to 'scripts/csv.reorder')

diff --git a/scripts/csv.reorder b/scripts/csv.reorder
new file mode 100755
index 0000000..df928f1
--- /dev/null
+++ b/scripts/csv.reorder
@@ -0,0 +1,19 @@
+#! /bin/bash
+
+# show each field with index in csv
+echo -------------- > /dev/tty
+head -1 < $1 | awk -F',' '{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 "type column numbers by new order, like 3 2 1: " order
+
+arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',')
+
+cat $1 |\
+awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\
+tee /tmp/csv |\
+echo "Also copied to /tmp/csv" > /dev/tty
+
+
-- 
cgit v1.2.3-70-g09d2