diff options
Diffstat (limited to 'scripts')
-rwxr-xr-x | scripts/csv.reorder | 6 |
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 ""}' | |||
6 | echo -------------- > /dev/tty | 6 | echo -------------- > /dev/tty |
7 | echo > /dev/tty | 7 | echo > /dev/tty |
8 | 8 | ||
9 | # get index of lon/lat column | ||
10 | read -p "type column numbers by new order, like 3 2 1: " order | 9 | read -p "type column numbers by new order, like 3 2 1: " order |
11 | 10 | ||
12 | arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',') | 11 | arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',') |
13 | 12 | ||
14 | cat $1 |\ | 13 | cat $1 |\ |
15 | awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\ | 14 | awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\ |
16 | tee /tmp/csv |\ | 15 | tee /tmp/csv |
17 | echo "Also copied to /tmp/csv" > /dev/tty | ||
18 | |||
19 | 16 | ||
17 | echo "Also copied to /tmp/csv" > /dev/tty | ||