Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

find the field number

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting find the field number
# 1  
Old 11-10-2010
find the field number
######################## SOLVED ##################

Hi

I have a header file like the following and the field "IDENTIFIER" can be at any possition on this line,
The line can containt a variable number of field, not alway the same depending of the header file i use

Code:
 
BAS,FastZeroSurfUNIT,ZeroSurfCAL,FastZeroSurfDAYC,IDENTIFIER,FunctionIdFLAG

I try to write a fonction that will return me the position of the collum "IDENTIFIER"


any idea ?
Last edited by kykyboss023; 11-10-2010 at 12:03 PM..
# 2  
Old 11-10-2010
How does the file look like?
Last edited by Franklin52; 11-10-2010 at 10:22 AM..
# 3  
Old 11-10-2010
the file is compose of one line the following

Code:
BAS,FastZeroSurfUNIT,ZeroSurfCAL,FastZeroSurfDAYC,IDENTIFIER,FunctionIdFLAG

what i am trying to do, is to create a array of the line, then test the array in order to find the position of the field = IDENTIFIER

so on my example output would be

echo "the field IDENTIFIER is on position $pos"
the field IDENTIFIER is on position 5
# 4  
Old 11-10-2010
Try:
Code:
awk -F, '{for(i=1;i<=NF;i++)A[$i]=i;print "The field "v" is on position "A[v];delete A}' v=IDENTIFIER infile

or without arrays:
Code:
awk -F, '{for(i=1;i<=NF;i++)if($i==v)print "The field "v" is on position "i}' v=IDENTIFIER infile

These 2 Users Gave Thanks to Scrutinizer For This Post:
jack.bauer kykyboss023
# 5  
Old 11-10-2010
hi

this commande doesn't work, and how do you check that the A[$1]=IDENTIFIER


Code:
 
awk -F, '{for(i=1;i<=NF;i++)A[$i]=i;print "The field "v" is on position "A[v];delete A}' FastZero_header.csv
 Syntax Error The source line is 1.
 The error context is
                {for(i=1;i<=NF;i++)A[$i]=i;print "The field "v" is on position "A[v];delete >>>  A} <<<
 awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.

# 6  
Old 11-10-2010
Code:
 
perl -F, -lane'BEGIN {
    $f = shift
 } 
    $F[$_] eq $f 
   and print "The field $f is on position ", ++ $_
        for 0 .. @F
  ' IDENTIFIER infile

---------- Post updated at 04:02 PM ---------- Previous update was at 03:55 PM ----------

Quote:
Originally Posted by kykyboss023
hi

this commande doesn't work, and how do you check that the A[$1]=IDENTIFIER


Code:
 
awk -F, '{for(i=1;i<=NF;i++)A[$i]=i;print "The field "v" is on position "A[v];delete A}' FastZero_header.csv
 Syntax Error The source line is 1.
 The error context is
                {for(i=1;i<=NF;i++)A[$i]=i;print "The field "v" is on position "A[v];delete >>>  A} <<<
 awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.

delete <array_name> is a GNU awk extention.
With most other awk implementations you could use split("", <array_name>) with the same effect.
These 2 Users Gave Thanks to radoulov For This Post:
kykyboss023 Scrutinizer
# 7  
Old 11-10-2010
Thanks the probleme is solve thanks a lot
both solution work fine the perl one and the awk one

Is used the awk, i just undertand it better
here is the final line i used

Code:
export POSITION=`grep "IDENTIFIER" FastZero_header.csv | awk -F, '{for(i=1;i<=NF;i++)if($i==v)print i}' v=IDENTIFIER`

Thanks all
Last edited by radoulov; 11-10-2010 at 01:42 PM.. Reason: Please use code tags!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Different field number in the file

Hello Friends I have a data file which is comma seperate (,) where i am expecting 2 column but there are number of time when file comes with data having more than 2 column. I want to check which line has more columns 20141115,15/11/2014 20141129,29/11/2014 20141003,03/10/2014... (4 Replies)
Discussion started by: guddu_12
4 Replies

2. Shell Programming and Scripting

awk to find number in a field then print the line and the number

Hi I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field. The source file is pipe delimited and looks something like 1|net|ABC Letr1|1530||| 1|net|EXP_1040 ABC|1121||| 1|net|EXP_TG1224|1122||| 1|net|R_North|1123|||... (5 Replies)
Discussion started by: Mudshark
5 Replies

3. Shell Programming and Scripting

Changed Field Number

HI, I have two files and contains many Fields or columns with | (pipe) delimitor, wanted to compare both the files and get only unmatched perticular fields number. ex: first.txt 1 | 2 | 3 111 |abc| 230 hbc | bb2 | cs second.txt 1 | 2 | 3 111 |abc |230 abn | bb2 | fp Here the... (7 Replies)
Discussion started by: prawinmca
7 Replies

4. Shell Programming and Scripting

Get the changed field number

HI, I have two files and contains many Fields or columns with | (pipe) delimitor, wanted to compare both the files and get only unmatched perticular fields number. ex: first.txt 111 |abc| 230| hbc | bb2 | cs second.txt 111 |abc |230 |abn | bb2 | fp Here the different data in two... (2 Replies)
Discussion started by: prawinmca
2 Replies

5. Shell Programming and Scripting

Help with number field manipulation

I have a comma separated file containing numbers, I would like to read the file and divide each number by 1024 and create an output file. Input file : 50312.00,3434.05, ,3433.34,124344.00,434343.00, , , Output file: 49.13,3.35,3.35,0,12.05,424.16,0,0 Please click this link: How to... (2 Replies)
Discussion started by: inditopgun
2 Replies

6. Shell Programming and Scripting

Adding total of first field for each number in the second field

Dears, I need a script or command which can find the unique number from the second filed and against that number it adds the total of first field . 17215630 , 0 907043 ,1 201050 ,10 394149 ,4 1964 ,9 17215630, 0 907043 ,1 201050, 10 394149 ,4 1964 ,9 1234234, 55 23 ,100 33 ,67 ... (2 Replies)
Discussion started by: shary
2 Replies

7. Shell Programming and Scripting

Count number of occurences of a character in a field defined by the character in another field

Hello, I have a text file with n lines in the following format (9 column fields): Example: contig00012 149606 G C 49 68 60 18 c$cccccacccccccccc^c I need to count the number of lower-case and upper-case occurences in column 9, respectively, of the... (3 Replies)
Discussion started by: s052866
3 Replies

8. Shell Programming and Scripting

Sorting on two fields time field and number field

Hi, I have a file that has data in it that says 00:01:48.233 1212 00:01:56.233 345 00:09:01.221 5678 00:12:23.321 93444 The file has more line than this but i just wanted to put in a snippet to ask how I would get the highest number with time stamp into another file. So from the above... (2 Replies)
Discussion started by: pat4519
2 Replies

9. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies

10. Shell Programming and Scripting

How to search a number in a certain field

Hello, I have a file that looks like this: num11 num12 num13 word1 num21 num22 num23 word2 num31 num32 num33 word3 . . . I would like to search for the lines that contain a given number, but I need to narrow the search only to the first field, that means that the number has to... (4 Replies)
Discussion started by: shira
4 Replies
Login or Register to Ask a Question