Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: print contents of file2 for matching pattern in file1 - AWK
Top Forums UNIX for Advanced & Expert Users print contents of file2 for matching pattern in file1 - AWK Post 302349403 by i.scientist on Tuesday 1st of September 2009 02:00:18 AM
Old 09-01-2009
print contents of file2 for matching pattern in file1 - AWK
File1 row is same as column 2 in file 2.
Also file 2 will either start with A, B or C.
And 3rd column in file 2 is always F2.

When column 2 of file 2 matches file1 column, print all those rows into a separate file.

Here is an example.


file 1:
Code:
100
103
104
108

file 2:

Code:
A|100|F2|hello
B|100|F2|djhbsdhjf
B|100|F2|dksadbkdfd
C|100|F2|djsbdjinldf
A|101|F2|hellodfd
B|101|F2|djhbsdhjdff
B|101|F2|dksadbkdfgd
C|101|F2|djsbdjinlgfg
A|102|F2|hellodfgfd
B|102|F2|djhbsdhjfgf
C|102|F2|djsbdjinlhgf
A|103|F2|hellohggg
B|103|F2|djhbsdhjhjhj
B|103|F2|dksadbkdfdr
C|103|F2|djsbdjinlfgf
A|104|F2|hellofg
B|104|F2|djhbsdhjfgf
B|104|F2|dksadbkhfgg
C|104|F2|djsbdjinlhgh
A|105|F2|hellohgh
B|105|F2|djhbsdhjdsgh
B|105|F2|dksadbkds
C|105|F2|djsbdjinlds
A|108|F2|hello
B|108|F2|djhbsdhj
B|108|F2|dksadbk
C|108|F2|djsbdjinl

OUTPUT:

Code:
A|100|F2|hello
B|100|F2|djhbsdhjf
B|100|F2|dksadbkdfd
C|100|F2|djsbdjinldf
A|103|F2|hellohggg
B|103|F2|djhbsdhjhjhj
B|103|F2|dksadbkdfdr
C|103|F2|djsbdjinlfgf
A|104|F2|hellofg
B|104|F2|djhbsdhjfgf
B|104|F2|dksadbkhfgg
C|104|F2|djsbdjinlhgh
A|108|F2|hello
B|108|F2|djhbsdhj
B|108|F2|dksadbk
C|108|F2|djsbdjinl


I am trying awk...but no luck...here is what i am trying
Code:
awk -v i="1" 'BEGIN { FS="|" }
FR==NR
{
a[i]=$2
if (a[i]==a[i-1]) {  h[$2,i]=$0; i++ }
else { if (i==1) { h[$2,i]=$0; i++;   } 
       if (i!=1) { h[$2,i]=$0; i=1; ; }
       }
       next
}
{
         for (j=1;j<1000;j++) 
         {
         if (h[$0,j]!="") { print h[$0,j]
                          }
          }
          next
                  }' file2 file1   >  ouputfile




************************************************************
i do not want to use for/while unix loops as it is nt efiicient ..........
Last edited by vgersh99; 09-07-2009 at 08:11 PM.. Reason: code tags, PLEASE!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed search lines in file1 matching columns in file2

Hi All, as you can see I'm pretty new to this board. :D I'm struggling around with small script to search a few fields in another file. Basically I have file1 looking like this: 15:38:28 sz:10001 pr:14.16 15:38:28 sz:10002 pr:18.41 15:38:29 sz:10003 pr:19.28 15:38:30 sz:10004... (1 Reply)
Discussion started by: floripoint
1 Replies

2. UNIX for Dummies Questions & Answers

if matching strings in file1 and file2, add column from file1 to file2

I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

3. Shell Programming and Scripting

Pattern Matching & replacing of content in file1 with file2

I have file 1 & file 2 with content mentioned below. I want to get the output as shown in file3. Requirement: check the content of column 1 & column 2, if value of column 1 in file1 matches with first column of file2 then remaining columns(2&3) of file2 should get replaced, also if value of... (4 Replies)
Discussion started by: siramitsharma
4 Replies

4. Shell Programming and Scripting

Based on column in file1, find match in file2 and print matching lines

file1: file2: I need to find matches for any lines in file1 that appear in file2. Desired output is '>' plus the file1 term, followed by the line after the match in file2 (so the title is a little misleading): This is honestly beyond what I can do without spending the whole night on it, so I'm... (2 Replies)
Discussion started by: pathunkathunk
2 Replies

5. Shell Programming and Scripting

Compare file1 for matching line in file2 and print the difference in matching lines

Hello, I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Discussion started by: RasB15
2 Replies

6. Shell Programming and Scripting

awk read in file1, gsub in file2, print to file3

I'm trying to use awk to do the following. I have file1 with many lines, each containing 5 fields describing an individual set. I have file2 which is a template config file with variable space holders to be replaced by the values in file1. I would like to substitute each set of values in file1 with... (6 Replies)
Discussion started by: msmehaffey
6 Replies

7. UNIX for Dummies Questions & Answers

Compare file1 and file2, print matching lines in same order as file1

I want to print only the lines in file2 that match file1, in the same order as they appear in file 1 file1 file2 desired output: I'm getting the lines to match awk 'FNR==NR {a++}; FNR!=NR && a' file1 file2 but they are in sorted order, which is not what I want: Can anyone... (4 Replies)
Discussion started by: pathunkathunk
4 Replies

8. Shell Programming and Scripting

awk to search field2 in file2 using range of fields file1 and using match to another field in file1

I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited. I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range... (6 Replies)
Discussion started by: cmccabe
6 Replies

9. Shell Programming and Scripting

awk to update field using matching value in file1 and substring in field in file2

In the awk below I am trying to set/update the value of $14 in file2 in bold, using the matching NM_ in $12 or $9 in file2 with the NM_ in $2 of file1. The lengths of $9 and $12 can be variable but what is consistent is the start pattern will always be NM_ and the end pattern is always ;... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

Awk- Indexing a list of numbers in file2 to print certain rows in file1

Hi Does anyone know of an efficient way to index a column of data in file2 to print the coresponding row in file1 which corresponds to the data in file2 AND 30 rows preceding and after the row in file1. For example suppose you have a list of numbers in file2 (single column) as follows:... (6 Replies)
Discussion started by: Geneanalyst
6 Replies

LEARN ABOUT DEBIAN

bib1-attr

BIB-1 ATTRIBUTE SET(7)					   Conventions and miscellaneous				    BIB-1 ATTRIBUTE SET(7)

NAME

       bib1-attr - Bib-1 Attribute Set

DESCRIPTION

       This reference entry lists the Bib-1 attribute set types and values.

TYPES

       The Bib-1 attribute defines six attribute types: Use (1), Relation (2), Position (3), Structure (4), Truncation (5) and completeness (6).

USE (1)
	       1     Personal-name
	       2     Corporate-name
	       3     Conference-name
	       4     Title
	       5     Title-series
	       6     Title-uniform
	       7     ISBN
	       8     ISSN
	       9     LC-card-number
	       10    BNB-card-number
	       11    BGF-number
	       12    Local-number
	       13    Dewey-classification
	       14    UDC-classification
	       15    Bliss-classification
	       16    LC-call-number
	       17    NLM-call-number
	       18    NAL-call-number
	       19    MOS-call-number
	       20    Local-classification
	       21    Subject-heading
	       22    Subject-Rameau
	       23    BDI-index-subject
	       24    INSPEC-subject
	       25    MESH-subject
	       26    PA-subject
	       27    LC-subject-heading
	       28    RVM-subject-heading
	       29    Local-subject-index
	       30    Date
	       31    Date-of-publication
	       32    Date-of-acquisition
	       33    Title-key
	       34    Title-collective
	       35    Title-parallel
	       36    Title-cover
	       37    Title-added-title-page
	       38    Title-caption
	       39    Title-running
	       40    Title-spine
	       41    Title-other-variant
	       42    Title-former
	       43    Title-abbreviated
	       44    Title-expanded
	       45    Subject-precis
	       46    Subject-rswk
	       47    Subject-subdivision
	       48    Number-natl-biblio
	       49    Number-legal-deposit
	       50    Number-govt-pub
	       51    Number-music-publisher
	       52    Number-db
	       53    Number-local-call
	       54    Code-language
	       55    Code-geographic
	       56    Code-institution
	       57    Name-and-title
	       58    Name-geographic
	       59    Place-publication
	       60    CODEN
	       61    Microform-generation
	       62    Abstract
	       63    Note
	       1000  Author-title
	       1001  Record-type
	       1002  Name
	       1003  Author
	       1004  Author-name-personal
	       1005  Author-name-corporate
	       1006  Author-name-conference
	       1007  Identifier-standard
	       1008  Subject-LC-childrens
	       1009  Subject-name-personal
	       1010  Body-of-text
	       1011  Date/time-added-to-db
	       1012  Date/time-last-modified
	       1013  Authority/format-id
	       1014  Concept-text
	       1015  Concept-reference
	       1016  Any
	       1017  Server-choice
	       1018  Publisher
	       1019  Record-source
	       1020  Editor
	       1021  Bib-level
	       1022  Geographic-class
	       1023  Indexed-by
	       1024  Map-scale
	       1025  Music-key
	       1026  Related-periodical
	       1027  Report-number
	       1028  Stock-number
	       1030  Thematic-number
	       1031  Material-type
	       1032  Doc-id
	       1033  Host-item
	       1034  Content-type
	       1035  Anywhere
	       1036  Author-Title-Subject

RELATION (2)
	       1 Less than
	       2 Less than or equal
	       3 Equal
	       4 Greater or equal
	       5 Greater than
	       6 Not equal
	       100 Phonetic
	       101 Stem
	       102 Relevance
	       103 AlwaysMatches

POSITION (3)
	       1 First in field
	       2 First in subfield
	       3 Any position in field

STRUCTURE (4)
	       1 Phrase
	       2 Word
	       3 Key
	       4 Year
	       5 Date (normalized)
	       6 Word list
	       100 Date (un-normalized)
	       101 Name (normalized)
	       102 Name (un-normalized)
	       103 Structure
	       104 Urx
	       105 Free-form-text
	       106 Document-text
	       107 Local-number
	       108 String
	       109 Numeric-string

TRUNCATION (5)
	       1 Right truncation
	       2 Left truncation
	       3 Left and right truncation
	       100 Do not truncate
	       101 Process # in search term  . regular #=.*
	       102 RegExpr-1
	       103 RegExpr-2
	       104 Process # ?n . regular: #=., ?n=.{0,n} or ?=.* Z39.58

       Thw 105-106 truncation attributes below are only supported by Index Data's Zebra server.

	       105 Process * ! regular: *=.*, !=. and right truncate
	       106 Process * ! regular: *=.*, !=.

COMPLETENSS (6)
	       1 Incomplete subfield
	       2 Complete subfield
	       3 Complete field

SORTING (7)
	       1 ascending
	       2 descending

       Type 7 is an Index Data extension to RPN queries that allows embedding a sort critieria into a query.

SEE ALSO

       Bib-1 Attribute Set[1]

       Attibute Set Bib-1 Semantics[2].

NOTES

	1. Bib-1 Attribute Set
	   http://www.loc.gov/z3950/agency/defns/bib1.html

	2. Attibute Set Bib-1 Semantics
	   http://www.loc.gov/z3950/agency/bib1.html

YAZ 4.2.30							    04/16/2012						    BIB-1 ATTRIBUTE SET(7)
All times are GMT -4. The time now is 10:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy