aboutsummaryrefslogtreecommitdiffhomepage
path: root/tools/csv.reorder
diff options
context:
space:
mode:
authortypebrook <typebrook@gmail.com>2020-03-02 20:34:54 +0800
committertypebrook <typebrook@gmail.com>2020-03-02 20:34:54 +0800
commita2497077066d4e26268bdd071851482252e45020 (patch)
treef8f9c868abda19dd85744db84367966abe3f944b /tools/csv.reorder
parentaf7ce43c718cb6bc0d7aac4633a8113f9a540ec5 (diff)
parent00b136155183ae522ca458e540a8cf29bf525e74 (diff)
Merge branch 'dev' of github.com:typebrook/settings into dev
Diffstat (limited to 'tools/csv.reorder')
-rwxr-xr-xtools/csv.reorder17
1 files changed, 17 insertions, 0 deletions
diff --git a/tools/csv.reorder b/tools/csv.reorder
new file mode 100755
index 0000000..8a64239
--- /dev/null
+++ b/tools/csv.reorder
@@ -0,0 +1,17 @@
1#! /bin/bash
2
3# show each field with index in csv
4echo -------------- > /dev/tty
5head -1 < $1 | awk -F',' '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' > /dev/tty
6echo -------------- > /dev/tty
7echo > /dev/tty
8
9read -p "type column numbers by new order, like 3 2 1: " order
10
11arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',')
12
13cat $1 |\
14awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\
15tee /tmp/csv
16
17echo "Also copied to /tmp/csv" > /dev/tty