blob: 8a64239bcdf22c206d3e86f65ba1acd057408517 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
#! /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
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
|
