How to get position of multiple column name

Question

i have a scenario where i want to know in which position number the column name comes

like i have sample data below

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

Colum name : S1 S2 D1

output should be :

3
5
7

You can use the same method I described here: https://unix.stackexchange.com/a/558381/364705 — markgraf, Jan 01 '20 at 08:35
You changed the expected output format. Now the accepted answer is no longer correct. — Kusalananda, Jan 01 '20 at 08:59

Guru · Accepted Answer · 2020-01-01T09:41:47.043

1

Assuming the sample data is in file1:

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

Using awk, we read only the 1st line and split into multiple columns where it is represented as col vs column number. Using grep, we are filtering only the list we are interested in.

Updated solution since OP changed the output format:

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

edited Jan 01 '20 at 09:41

answered Jan 01 '20 at 08:35

Guru

5,905

can you able to get me only values not with colun name question updated pls look – genip26057 Jan 01 '20 at 09:25
@ Kusalananda can you able to get me the required output in question updated – genip26057 Jan 01 '20 at 09:26
@Thank u so much bro worked as expected – genip26057 Jan 01 '20 at 11:40

How to get position of multiple column name

1 Answers1

Linked

Related