CODEWITHSUNDEEP
linuxshellunixawkgrep
user3622752
user3622752

Reputation: 43

how to find the column number in a text file using unix commands

Suppose I have a text file with 6 columns as below

a|b|c|d|e|f

I know that somwhere in the file the character 'd' exist, but I want to know the column no for it

I have used the following command

awk 's=index($0,"d"){print "position="s}' filename

but it counts the delimiters too which I dont want....I want the output to be 4 in case of "d"

Upvotes: 4

Views: 9902

Answers (2)

yejinxin
yejinxin

Reputation: 596

define "|" as Record Seperator, and use NR variable in awk:

awk -v RS="|" '/^d$/{print NR;}' filename

change ^d$ to whatever you want to match.

Upvotes: 7

anubhava
anubhava

Reputation: 785581

Using awk you can do:

awk -v val='d' -F '|' '{for (i=1; i<=NF; i++) if ($i==val) {print i} }' file
4

Upvotes: 6

Related Questions