Grep in specific columns Post: 302927502

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Grep in specific columns Post 302927502 by RudiC on Wednesday 3rd of December 2014 01:07:14 PM

12-03-2014

Registered User

There's syntax errors and logical errors. Having corrected the syntax, it looks like

Code:

while read line; do awk  -v var="$line" '{for(i=1;i<NF;i++) if ($NF==var) break; print var FS $NF }' searchfile; done < listfile

The result shows the logical errors, e.g. $NF is always the last field in the respective line

Code:

Sth. like

Code:

{for(i=1;i<=NF;i++) if ($i==var) print var FS i }
23 2
34 3
45 1

would come closer; still the "not found" missing.

However, as an awk- only solution, try

Code:

awk     'FNR==NR        {T[$1];next}
                        {for (i in T)
                                for (j=1; j<=NF; j++)
                                        if (i == $j)    {print i " matches " j " col"
                                                         delete T[i]
                                                        }
                        }
         END            {for (i in T) print i " not found"}
        ' file1 file2
23 matches 2 col
34 matches 3 col
45 matches 1 col
86 not found

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace specific columns

hi All, Thi sis very urgent. I have large files with pipe delimited. For example: 1.txt 1001024|120|9|-0.0|#| 1001025|120|9|#| 1001026|120|9|#| 1001032|120|2|-0.0|#| 1002026|110|9|#| 1002027|110|9|-0.0|#| 1002028|120|1|1.0|#| I need to replace the 4th filed if it is # by |-| my...

2. Shell Programming and Scripting

Grep based on specific columns.

Hi, How can I grep a record for a value based on specific column. If I simply do a grep 'AB' FilenName.txt, I might end up getting the records returned whose part of value is 'AB'. But I want it specific to second column. cut -d'|' -f 2 FileName.txt | grep 'AB' But now it will return...

3. Shell Programming and Scripting

Mean of the specific columns

I have a input file that has some common values in 1st,2nd and 3rd columns. 4th and 5th are different. Now I would like to print the mean of the fourth column of similar values in 1st.2nd and 3rd columns along with all the values in 5th column. input NM_0 1.22 CR5 0.4 n_21663...

4. Shell Programming and Scripting

Replace specific columns in one file with columns in another file

HELLO! This is my first post here! By the way, I think it is great that people do this. My question: I have two files, one is a .dilm and one is a .txt. It is my understanding that the .dilm file can be treated as a .txt file. I wrote another program where I was able to manipulate it as if it...

5. Homework & Coursework Questions

ls in specific columns

Hello, i need to get the ls output in 2 columns.1st column the directories and 2nd the files... Also each column must be sorted by time... For example if the >>ls command gives me this : /dir2 /dir /dir1 /dir3 file1 file2 I need to take this : /dir file1 /dir1 ...

6. Shell Programming and Scripting

Deleting specific columns

Hi group, Can you please tell how to delete specific columns from a file. I know something like awk -F, '{ print $1" "$2" "15 }' input.txt > output.txt will delete all other columns. But this is in a way to copy some particular columns. But is there any other way to select just some...

7. Shell Programming and Scripting

Can't figure out how to find specific characters in specific columns

I am trying to find a specific set of characters in a long file. I only want to find the characters in column 265 for 4 bytes. Is there a search for that? I tried cut but couldn't get it to work. Ex. I want to find '9999' in column 265 for 4 bytes. If it is in there, I want it to print...

8. UNIX for Dummies Questions & Answers

Printing lines with specific strings at specific columns

Hi I have a file which is tab-delimited. Now, I'd like to print the lines which have "chr6" string in both first and second columns. Could anybody help?

9. UNIX for Dummies Questions & Answers

Intersection by specific columns

Hi, I'd like to intersect two files by the 4th col of the first file and 6th col of the second file. This is the code I use: awk 'NR==FNR{A;next}$6 File1 File2 However, this is only outputting the second file lines. I'd like to have both lines in a single line separated by a tab. Thanks in...

10. Shell Programming and Scripting

Merge specific columns of two files

Hello, I have two tab delimited text files. Both files have the same number of rows but not necessarily the same number of columns. The column headers look like, File 1: f0order CVorder Name f0 RI_9 E99 E199 E299 E399 E499 E599 E699 E799 E899 E999 File 2:...

LEARN ABOUT OSX

svk::log::filter::grep

SVK::Log::Filter::Grep(3)				User Contributed Perl Documentation				 SVK::Log::Filter::Grep(3)

SYNOPSIS

       SVK::Log::Filter::Grep - search log messages for a given pattern

DESCRIPTION

       The Grep filter requires a single Perl pattern (regular expression) as its argument.  The pattern is then applied to the svn:log property
       of each revision it receives.  If the pattern matches, the revision is allowed to continue down the pipeline.  If the pattern fails to
       match, the pipeline immediately skips to the next revision.

       The pattern is applied with the /i modifier (case insensitivity).  If you want case-sensitivity or other modifications to the behavior of
       your pattern, you must use the "(?imsx-imsx)" extended pattern (see "perldoc perlre" for details).  For example, to search for log messages
       that match exactly the characters "foo" you might use

	   svk log --filter "grep (?-i)foo"

       However, to search for "foo" without regards for case, one might try

	   svk log --filter "grep foo"

       The result of any capturing parentheses inside the pattern are not available.  If demand dictates, the Grep filter could be modified to
       place the captured value somewhere in the stash for other filters to access.

       If the pattern contains a pipe character ('|'), it must be escaped by preceding it with a '' character.  Otherwise, the portion of the
       pattern after the pipe character is interpreted as the name of a log filter.

STASH
/PROPERTY MODIFICATIONS
       Grep leaves all properties and the stash intact.

perl v5.10.0							    2008-08-04						 SVK::Log::Filter::Grep(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace specific columns

Discussion started by: jisha

2. Shell Programming and Scripting

Grep based on specific columns.

Discussion started by: deepakwins

3. Shell Programming and Scripting

Mean of the specific columns

Discussion started by: repinementer

4. Shell Programming and Scripting

Replace specific columns in one file with columns in another file

Discussion started by: mehdib

5. Homework & Coursework Questions

ls in specific columns

Discussion started by: giampoul

6. Shell Programming and Scripting

Deleting specific columns

Discussion started by: smitra

7. Shell Programming and Scripting

Can't figure out how to find specific characters in specific columns

Discussion started by: Drenhead

8. UNIX for Dummies Questions & Answers

Printing lines with specific strings at specific columns

Discussion started by: a_bahreini

9. UNIX for Dummies Questions & Answers

Intersection by specific columns

Discussion started by: a_bahreini

10. Shell Programming and Scripting

Merge specific columns of two files

Discussion started by: LMHmedchem

LEARN ABOUT OSX

svk::log::filter::grep