How do get column position for multiple column names

Question

I have a scenario where I want to get column position number

ID|NAME|S1|BQ|S2|VN|D1
1|vimal|10.12|12.4|56.2|12.2|11.22
2|vilas|10.12|12.4|56.2|12.2|11.22
3|viky|10.12|12.4|56.2|12.2|11.22

column name : S1|S2|D1

Output should be below:

3
5
7

I tried below code but partially provide output

awk -F"|" 'NR==1{for(i=1;i<=NF;i++){print $i"=$"i}}' demo.txt | grep -E "S1|S2|D1"

S1=$3
S2=$5
D1=$7

Need output like below

3
5
7

@Kusalananda i have run previously shared answer but i am passing it in for loop in my script it is iterating all the values from 1 till 6 that y need only 3 5 7 — genip26057, Jan 01 '20 at 11:26
@Kusalananda my solution not working even though it gives expected output is their any way i can cut only values from S1=$3 to 3 , S2=$5 to 5 and so on — genip26057, Jan 01 '20 at 11:27
i have tried this code : awk -F"|" 'NR==1{for(i=1;i<=NF;i++){print $i"=$"i}}' demo.txt | grep -E "S1|S2|D1" | sed -r 's/=$/\t/g' — genip26057, Jan 01 '20 at 11:29
Context and other clarifications should be added to the question itself, not in comments. — Kusalananda, Jan 01 '20 at 11:51

Cbhihe · Answer 1 · 2020-01-01T12:06:14.453

0

Try:

$ awk -F"|" 'NR==1 {for(i=1;i<=NF;i++) if ($i=="S1" || $i=="S2" || $i=="D1" ) {print i}}' demo.txt

However (I just checked it out), @guru's answer does the same and is nicer to look at, from my point of view.

edited Jan 01 '20 at 12:06

answered Jan 01 '20 at 11:59

Cbhihe

2,701

How do get column position for multiple column names

1 Answers1