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