Sponsored Content
Top Forums Shell Programming and Scripting Request to check: compare two files , match same entries, write data before it Post 302675943 by manigrover on Monday 23rd of July 2012 10:34:12 PM
Old 07-23-2012
Request to check: new file with 3 separated rows rows

Hi all

Now I have got the second file with 3 columns for sure

like this:

Kindly check it.Pelase let me know scripting for above question
Code:
   	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; } 	   	 	 		 			    	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; } 	   	 	 		 			Lepirudin:Refludan:F2
Cetuximab:Erbitux:FCGR2A,FCGR2B,FCGR2C,EGFR,FCGR3B,C1R,C1QA,C1QB,C1QC,FCGR3A,C1S,FCGR1A
Dornase Alfa:Pulmozyme:Not Available
Denileukin diftitox:Ontak:IL2RA,IL2RB,IL2RG
Etanercept:Enbrel:C1S,C1R,C1QA,C1QB,C1QC,TNF,TNFRSF1B,FCGR1A,FCGR3A,FCGR2A,FCGR2B,FCGR2C,LTA,FCGR3B
Bivalirudin:Angiomax:F2
Leuprolide:Eligard:GNRHR
Peginterferon alfa-2a:Pegasys:IFNAR2,IFNAR1
Alteplase:Activase (Genentech Inc):PLG,FGA,PLAUR,SERPINE1
Sermorelin:Geref:GHRHR
Interferon alfa-n1:Wellferon (GlaxoSmithKline):IFNAR2,IFNAR1
Darbepoetin alfa:Aranesp:EPOR
Urokinase:Abbokinase:NID1,PLG,PLAUR,PLAU,PLAT,SERPINE1,SERPINB2,SERPINA5,LRP2,ST14
Goserelin:Zoladex:LHCGR,GNRHR
Reteplase:Retavase (Centocor):PLG,FGA,PLAUR,SERPINE1
Epoetin alfa:Epogen:EPOR
Salmon Calcitonin:Calcimar:CALCR
Interferon alfa-n3:Alferon (Interferon Sciences Inc.):IFNAR1,IFNAR2
Pegfilgrastim:Neulasta (Amgen Inc.):CSF3R,ELANE
Sargramostim:Immunex:CSF2RA,IL3RA,CSF2RB,SDC2,PRG2
Secretin:SecreFlo:SCTR
Peginterferon alfa-2b:PEG-Intron    (Schering Corp):IFNAR1,IFNAR2
Asparaginase:Elspar (Merck & Co. Inc):Not Available
Thyrotropin Alfa:Thyrogen (Genzyme Inc):TSHR
Antihemophilic Factor:Advate:LRP1,MCFD2,F10,F9,VWF,PHYH,ASGR2,HSPA5,CALR,CANX,LMAN1
Anakinra:Kineret (Amgen Inc):IL1R1
Gramicidin D:Neosporin:
Intravenous Immunoglobulin:Civacir:C4B,C5,FCGR1A,FCGR1B,FCGR2A,FCGR2B,FCGR2C,FCGR3A,FCGR3B,C3,C4A
Anistreplase:Eminase (Wulfing Pharma GmbH):PLG,FGA,PLAUR,SERPINE1
Insulin recombinant:Novolin R (Novo Nordisk):LRP2,IGFBP7,SYTL4,INSR,IGF1R,RB1,CTSD,IDE,PCSK2,CPE,PCSK1,NOV
Tenecteplase:TNKase (Genentech Inc):CANX,LRP1,PLG,FGA,PLAUR,SERPINE1,SERPINB2,CLEC3B,KRT8,ANXA2,CALR
Menotropins:Repronex:FSHR,LHCGR
Interferon gamma-1b:Actimmune:IFNGR1,IFNGR2
Interferon Alfa-2a, Recombinant:Roferon A (Hoffmann-La Roche Inc):IFNAR1,IFNAR2
Desmopressin:Adiuretin:AVPR2,AVPR1A,AVPR1B
Coagulation factor VIIa:NovoSeven (Novo Nordisk):F10,HPN,TFPI,GGCX,F7,F3
Oprelvekin:Neumega:IL11RA
Palifermin:Kepivance (Amgen Inc):FGFR2,NRP1,FGFR1,FGFR4,FGFR3,HSPG2
Glucagon recombinant:GlucaGen (Novo Nordisk):GCGR,GLP2R,GLP1R
Aldesleukin:Proleukin:IL2RB,IL2RA,IL2RG


Last edited by Scrutinizer; 07-24-2012 at 12:47 AM.. Reason: code tags instead of quote tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Request to check: Not printing all entries

Dear all, I am facing one problem in my input file there are many Entries which starts from *FIELD * AV (checked the attached file) I want all the entries in the output file which start from *FIELD * AV I have written this programm but its not printing all the entries with *FIELD... (4 Replies)
Discussion started by: manigrover
4 Replies

2. Shell Programming and Scripting

Request to check: find common and write before it

Hi all, I have 2 big files with such kind of inputs File I File II I want the output file shuld contain Please let me knw scripting regarind this (1 Reply)
Discussion started by: manigrover
1 Replies

3. Shell Programming and Scripting

Request to check remove duplicates but write before it

Hi alll I have a file with following kind input I want in output duplicates should not be there but there should be numbering mentioned before that like (4 Replies)
Discussion started by: manigrover
4 Replies

4. Shell Programming and Scripting

Request to check:remove duplicates and write sytematically

Hi all I have a file with following input It contains 5 columns gene name drug drug ID disease approved Now the same gene is repeated many times with different data in column2,3 ,4,5 I want to arrange dat in such a way that there shuld be one entry in the column(no... (2 Replies)
Discussion started by: manigrover
2 Replies

5. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

6. Shell Programming and Scripting

Request to check:Fetch certain entries

Hi all. Kindly check it it's urgent!! I have one big file from which which I have to fetch certain data I have attached a small part of this file. from the attached file, I have to fetch and arrange data in 3 columns 1 Generic name 2. Brand names 3. Drug... (10 Replies)
Discussion started by: manigrover
10 Replies

7. Shell Programming and Scripting

Compare two files and write data to second file using awk

Hi Guys, I wanted to compare a delimited file and positional file, for a particular key files and if it matches then append the positional file with some data. Example: Delimited File -------------- Byer;Amy;NONE1;A5218257;E5218257 Byer;Amy;NONE1;A5218260;E5218260 Positional File... (3 Replies)
Discussion started by: Ajay Venkatesan
3 Replies

8. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

9. UNIX for Dummies Questions & Answers

Compare data - Match first column and compare second

Hi guys, looking for some help with a way to compare data in two files but with some conditions. example, File 1 consists of site1,10.1.1.1 site2,20.2.2.2 site3,30.3.3.3 File 2 contains site1,l0.1.1.1 site2,50.1.1.1 site3,30.3.3.3 site4,40.1.1.1 I want to be able to match the... (1 Reply)
Discussion started by: mutley2202
1 Replies

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
ADDFTINFO(1)						      General Commands Manual						      ADDFTINFO(1)

NAME
addftinfo - add information to troff font files for use with groff SYNOPSIS
addftinfo [ -v ] [ -param value... ] res unitwidth font DESCRIPTION
addftinfo reads a troff font file and adds some additional font-metric information that is used by the groff system. The font file with the information added is written on the standard output. The information added is guessed using some parametric information about the font and assumptions about the traditional troff names for characters. The main information added is the heights and depths of characters. The res and unitwidth arguments should be the same as the corresponding parameters in the DESC file; font is the name of the file describing the font; if font ends with I the font will be assumed to be italic. OPTIONS
-v prints the version number. All other options changes one of the parameters that is used to derive the heights and depths. Like the existing quantities in the font file, each value is in inches/res for a font whose point size is unitwidth. param must be one of: x-height The height of lowercase letters without ascenders such as x. fig-height The height of figures (digits). asc-height The height of characters with ascenders, such as b, d or l. body-height The height of characters such as parentheses. cap-height The height of uppercase letters such as A. comma-depth The depth of a comma. desc-depth The depth of characters with descenders, such as p,q, or y. body-depth The depth of characters such as parentheses. addftinfo makes no attempt to use the specified parameters to guess the unspecified parameters. If a parameter is not specified the default will be used. The defaults are chosen to have the reasonable values for a Times font. SEE ALSO
groff_font(5), groff(1), groff_char(7) Groff Version 1.19.2 23 March 2013 ADDFTINFO(1)
All times are GMT -4. The time now is 09:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy