aboutsummaryrefslogtreecommitdiffhomepage
path: root/scripts/csv_reorder
diff options
context:
space:
mode:
authortypebrook <typebrook@gmail.com>2019-11-12 14:30:20 +0800
committertypebrook <typebrook@gmail.com>2019-11-12 14:30:20 +0800
commit2d2594e95e3e6a52ddb90cb66165ec297243b5d0 (patch)
tree81a57cf2b10bd31d3a1f8feeb85e84cc990ec519 /scripts/csv_reorder
parenta84199f155f56d13d554c9427b5351d0d8807ef7 (diff)
update
Diffstat (limited to 'scripts/csv_reorder')
-rwxr-xr-xscripts/csv_reorder18
1 files changed, 0 insertions, 18 deletions
diff --git a/scripts/csv_reorder b/scripts/csv_reorder
deleted file mode 100755
index a62701f..0000000
--- a/scripts/csv_reorder
+++ /dev/null
@@ -1,18 +0,0 @@
1#! /bin/bash
2
3# show each field with index in csv
4echo -------------- > /dev/tty
5head -1 < $1 | sed 's/,/ /g' | awk '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' > /dev/tty
6echo -------------- > /dev/tty
7echo > /dev/tty
8
9# get index of lon/lat column
10read -p "Move which column? " origin_col
11read -p "To which index? " new_col
12
13cat $1 |
14# move lon and lat to the first and second column
15awk -F',' -v OFS="," -v origin_th=$origin_col -v new_th=$new_col '\
16 {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 ""}\
17 ' |\
18sed 's/,$//g'