Adding a column with awk

Question

I want to add a new column at the beggining of every row. Command used:

tree -afispugD --inodes

I want to put a new column which will be the name of the file.

Example:

119801433 -rwxr--r-- u1915811 alum          1252 Apr  1 21:06  ./file
119802284 -rw-r--r-- u1915811 alum          1255 Mar 20 10:25  ./text.txt
119865862 drwxr-xr-x u1915811 alum          4096 Feb 27 10:20  ./S3/folder2

To this:

file       119801433 -rwxr--r-- u1915811 alum          1252 Apr  1 21:06  ./file
text.txt   119802284 -rw-r--r-- u1915811 alum          1255 Mar 20 10:25  ./text.txt
folder2    119865862 drwxr-xr-x u1915811 alum          4096 Feb 27 10:20  ./S3/folder2

PS: I have to do it because tree command doesn't show names :(

Ed Morton · Accepted Answer · 2013-04-01 20:33:55Z

All you need is:

$ awk -F'/' '{print $NF,$0}' file
file 119801433 -rwxr--r-- u1915811 alum          1252 Apr  1 21:06  ./file
text.txt 119802284 -rw-r--r-- u1915811 alum          1255 Mar 20 10:25  ./text.txt
folder2 119865862 drwxr-xr-x u1915811 alum          4096 Feb 27 10:20  ./S3/folder2

or if you want to use some specific spacing in the output use printf instead of print:

$ awk -F'/' '{printf "%-10s%s\n",$NF,$0}' file
file      119801433 -rwxr--r-- u1915811 alum          1252 Apr  1 21:06  ./file
text.txt  119802284 -rw-r--r-- u1915811 alum          1255 Mar 20 10:25  ./text.txt
folder2   119865862 drwxr-xr-x u1915811 alum          4096 Feb 27 10:20  ./S3/folder2

or, since this is a simple substitution on a single line, you could use sed instead of awk:

$ sed 's/\(.*\/\(.*\)\)/\2 \1/' file
file 119801433 -rwxr--r-- u1915811 alum          1252 Apr  1 21:06  ./file
text.txt 119802284 -rw-r--r-- u1915811 alum          1255 Mar 20 10:25  ./text.txt
folder2 119865862 drwxr-xr-x u1915811 alum          4096 Feb 27 10:20  ./S3/folder2

A human being · Accepted Answer · 2013-04-01 20:58:56Z

0

This one will also work, if file has whitespaces in its name or if it's a symbolic link

tree -afispugD --inodes | awk '{FS="./"; ORS=""; printf("%-60s%s\n",$NF,$0)}'

edited Apr 1, 2013 at 20:58

answered Apr 1, 2013 at 20:16

A human being

1,2208 silver badges18 bronze badges

4 Comments

Chris Seymour Over a year ago

You know you are setting the values of FS and ORS on every line in the file!? You should instead do awk '{printf("%-60s%s\n",$NF,$0)}' FS="./" ORS=""

A human being Over a year ago

I searched for it and found that doing this in BEGIN block is better, because it's executed once, before the first input record has been read. Thanks a lot :)

Chris Seymour Over a year ago

Yes you can also set the values in the BEGIN block but for a one liner just set the values after script

A human being Over a year ago

Okay, I didn't know about it! Thanks once again :)

Zsolt Botykai · Accepted Answer · 2013-04-02 09:32:40Z

0

Until there are spaces in the filenames, this should work:

tree -afispugD --inodes | awk '{printf("-30s%s\n",$NF,$0}'

edited Apr 2, 2013 at 9:32

answered Apr 1, 2013 at 20:19

Zsolt Botykai

52k14 gold badges90 silver badges111 bronze badges

Collectives™ on Stack Overflow

Adding a column with awk

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related