blob: df928f1b9a9ae3d12e3cd21533e3e04a57710a56 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
#! /bin/bash
# show each field with index in csv
echo -------------- > /dev/tty
head -1 < $1 | awk -F',' '{for (i=1; i<=NF; i++) printf $i "_" i " "; print ""}' > /dev/tty
echo -------------- > /dev/tty
echo > /dev/tty
# get index of lon/lat column
read -p "type column numbers by new order, like 3 2 1: " order
arrange=$(echo $order | sed -r 's/([^ ]+)/$\1/g' | tr ' ' ',')
cat $1 |\
awk -F',' "BEGIN{OFS=\",\"}{print $arrange}" |\
tee /tmp/csv |\
echo "Also copied to /tmp/csv" > /dev/tty
|
