Bash: Display CSV vertically

Question

I am trying to display some CSV file by switching rows and columns, so that this:

a,b,name
20,10,"Hello World"

Would looks like:

a,20
b,10
name,"Hello World"

For instance in Sqlite one can use the pivot clause, but I'm looking for something more general and not SQL specific.

So is there an easy way to convert rows to columns by splitting them at a given separator (here ,)?

Not an exact duplicate, but very close: Transpose a file in bash — Benjamin W.
– Benjamin W., Commented Dec 22, 2016 at 15:10

Kent · Accepted Answer · 2016-12-22 12:25:40Z

1

#!/bin/bash
#########################################
# Matrix transpose with Awk
#
# Usage: matrixT file fs ofs
# The last two arguments are optional
#
# Kent
# 2011-07-07
#
#########################################
fs=${2:-" "}
ofs=${3:-" "}
file=$1

awk  -v FS="$fs" -v OFS="$ofs" '{for (i=1;i<=NF;i++) a[i,NR]=$i; }END{
    for(i=1;i<=NF;i++) {
        for(j=1;j<=NR;j++)
            printf "%s%s", a[i,j], (j==NR? ORS:OFS);
    } 
}' "$file"

Sometimes I need do this also quite often, so I wrote a script (see above).

You can do :

theScript.sh file ","  ","

answered Dec 22, 2016 at 12:25

Kent

197k36 gold badges248 silver badges317 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Bash: Display CSV vertically

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related