Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Match first column entries precisely and fetch whatever in front of it
Top Forums Shell Programming and Scripting Match first column entries precisely and fetch whatever in front of it Post 302732243 by Priyanka Chopra on Saturday 17th of November 2012 02:19:20 AM
Old 11-17-2012
Match first column entries precisely and fetch whatever in front of it
Hi all

I have 2 files:

first file
Code:
AABC
TTYP
JKBH
CVBN
NHJK
KJHM

Second file is

Code:
AABC,XCYU,JUHD      Alllele1        GACXT  It is approved study
TTYP,JKBH               Allele2         PPRD      It is clinical trial study   
JKBH                         Allele2         PPRD      It is clinical trial study 
CVBN                      Allele23        PKHGN     It is clinical trial study 
NHJK,CVBN                Allele2         PPRD      It is clinical trial study 
KJHM,CVBN,GHCY,BVCHJ             Allele5         PPRD      It is approved/clinical trial study


If the entries of first file matches with any entry of first column in second file whether it's after comma even(This is problem because my code is only checking first entry not entries after comma)


Then fetch entries present in next columns after it.


Code:
AABC    Alllele1        GACXT  It is approved study
TTYP              Allele2         PPRD      It is clinical trial study
JKBH               Allele2         PPRD      It is clinical trial study   
JKBH                Allele2         PPRD      It is clinical trial study 
CVBN               Allele23        PKHGN     It is clinical trial study 
NHJK,              Allele2         PPRD      It is clinical trial study 
CVBN                Allele2         PPRD      It is clinical trial study 
KJHM                Allele5         PPRD      It is approved/clinical trial study 
CVBN                Allele5         PPRD      It is approved/clinical trial study

The code which I was using is
Code:
awk 'NR==FNR{X[$1]=$0;next}{n=split($1,P," ");sub($1,"",$0);for(i=1;i<=n;i++){if(X[P[i]]){print P[i],$0}}}' file1 FS="\t" file2

which is mapping only first entries not after comma of firs tcolumn of second file

I am also attaching sample from original files(first and second). please checkit
first.txt (161 Bytes) 
second.txt (37.1 KB) 
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS... (7 Replies)
Discussion started by: rydz00
7 Replies

2. Shell Programming and Scripting

fetch last line no form file which is match with specific pattern by grep command

Hi i have a file which have a pattern like this Nov 10 session closed Nov 10 Nov 9 08:14:27 EST5EDT 2010 on tty . Nov 10 Oct 19 02:14:21 EST5EDT 2010 on pts/tk . Nov 10 afrtetryytr Nov 10 session closed Nov 10 Nov 10 03:21:04 EST5EDT 2010 Dec 8 Nov 10 05:03:02 EST5EDT 2010 ... (13 Replies)
Discussion started by: Himanshu_soni
13 Replies

3. Shell Programming and Scripting

match sentence and word adn fetch similar words in alist

Hi all, I have ot match sentence list and word list anf fetch similar words in a separate file second file with 2 columns So I want the output shuld be 2 columns like this (3 Replies)
Discussion started by: manigrover
3 Replies

4. Shell Programming and Scripting

Match the word or words and fetch the entries

Hi all, I have 7 words Now I have 1 file which contain data in large number of rows and columns and 6th column contain any of these words or may be more than one words among above 7 words: I want script should search for the above mentioned 7 words in the 6th column ... (9 Replies)
Discussion started by: manigrover
9 Replies

5. Shell Programming and Scripting

Match words and fetch data in front of it in second column

Hi all, I have 2 files one file contain data like this in one column AST3 GSTY4 JST3 second file containign data like this in 2 columns AST3(PAXXX),GSTY4(PAXXY) it is used in diabetes KST4 it is used in blood... (6 Replies)
Discussion started by: manigrover
6 Replies

6. Shell Programming and Scripting

Fetch entries in front of specific word till next word

Hi all I have following file which I have to edit for research purpose file:///tmp/moz-screenshot.png body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: &quot;Liberation Sans&quot;; font-size: x-small; } Drug: KRP-104 QD Drug: Placebo Drug: Metformin|Drug:... (15 Replies)
Discussion started by: Priyanka Chopra
15 Replies

7. Shell Programming and Scripting

Find common and fetch what ever in front of it

Hi guys As my previous one is not working now I have a different problem with me one file with entries F2 F3 YUH SUH second fiel several columns like excel sheet (8-9) but my file in text F2 fgf gfhjhjghjghj dhgfhgfh 234324 F3 ... (6 Replies)
Discussion started by: Priyanka Chopra
6 Replies

8. Shell Programming and Scripting

Match columns and fetch whatever in front of it

Hi Solved these kind of issues using these codes But these are not wrking for my attached files can anybody check........ awk 'NR==FNR{X++;next}{if(X){print}}' file1 file2 awk 'NR==FNR{X=$0;next}{n=split($1,P," ");sub($1,"",$0);for(i=1;i<=n;i++){if(X]){print P,$0}}}' file1 FS="\t" file2 ... (6 Replies)
Discussion started by: Priyanka Chopra
6 Replies

9. Shell Programming and Scripting

Match first column and separate entries

Hi I have 2 big files containing following information: file 1 12345 345634 217341 87234693 8236493 file 2: 12345 1237 (6 Replies)
Discussion started by: kaav06
6 Replies

10. Shell Programming and Scripting

How to dynamically fetch lines after a match?

Hi Friends, How to fetch current hour data from a log file, given below? I want all lines after the match "Wed Aug 13 16:" I have tried below command, but not working. If I put exact string, then it is working. cat /iscp/user/monitor/ORA_errors |awk '/`date +%h" "%d" "%h`/,printed==999 {... (7 Replies)
Discussion started by: suresh3566
7 Replies
All times are GMT -4. The time now is 01:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy