summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authortypebrook <typebrook@gmail.com>2020-01-13 15:24:24 +0800
committertypebrook <typebrook@gmail.com>2020-01-13 15:24:24 +0800
commit8383d42c9532b3349b2285a389133b76ce2d6f86 (patch)
treeea4eb8152f31a0eabf7d2df58a76ef6ce964779b
parentdb1b0e06c2a9470b1b5107e20f0f0a12ed2c3c90 (diff)
update
-rwxr-xr-xscripts/csv.reorder6
1 files changed, 2 insertions, 4 deletions
diff --git a/scripts/csv.reorder b/scripts/csv.reorder
index df928f1..8a64239 100755
--- a/scripts/csv.reorder
+++ b/scripts/csv.reorder
@@ -6,14 +6,12 @@ head -1 < $1 | awk -F',' '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}'
6echo -------------- > /dev/tty 6echo -------------- > /dev/tty
7echo > /dev/tty 7echo > /dev/tty
8 8
9# get index of lon/lat column
10read -p "type column numbers by new order, like 3 2 1: " order 9read -p "type column numbers by new order, like 3 2 1: " order
11 10
12arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',') 11arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',')
13 12
14cat $1 |\ 13cat $1 |\
15awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\ 14awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\
16tee /tmp/csv |\ 15tee /tmp/csv
17echo "Also copied to /tmp/csv" > /dev/tty
18
19 16
17echo "Also copied to /tmp/csv" > /dev/tty