diff options
author | typebrook <typebrook@gmail.com> | 2019-11-17 09:18:07 +0800 |
---|---|---|
committer | typebrook <typebrook@gmail.com> | 2019-11-17 09:18:07 +0800 |
commit | 1d3508f66fddf3f8c6416e59ab9fbde405dbcf25 (patch) | |
tree | 4f703dfa01596c133a4898c88fe837b8971e47e1 /scripts/csv.reorder | |
parent | e0673805fc648d47eadf5c76b822ccef5780d241 (diff) |
update
Diffstat (limited to 'scripts/csv.reorder')
-rwxr-xr-x | scripts/csv.reorder | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/scripts/csv.reorder b/scripts/csv.reorder deleted file mode 100755 index ef9766b..0000000 --- a/scripts/csv.reorder +++ /dev/null | |||
@@ -1,17 +0,0 @@ | |||
1 | #! /bin/bash | ||
2 | |||
3 | # show each field with index in csv | ||
4 | echo -------------- > /dev/tty | ||
5 | head -1 < $1 | awk -F',' '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' > /dev/tty | ||
6 | echo -------------- > /dev/tty | ||
7 | echo > /dev/tty | ||
8 | |||
9 | # get index of lon/lat column | ||
10 | read -p "type column numbers by new order, like 3 2 1: " order | ||
11 | |||
12 | arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',') | ||
13 | |||
14 | cat $1 |\ | ||
15 | awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" | ||
16 | |||
17 | |||