diff options
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 8a64239..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 | read -p "type column numbers by new order, like 3 2 1: " order | ||
10 | |||
11 | arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',') | ||
12 | |||
13 | cat $1 |\ | ||
14 | awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\ | ||
15 | tee /tmp/csv | ||
16 | |||
17 | echo "Also copied to /tmp/csv" > /dev/tty | ||