Find matches and write the data before it

11-08-2012

Banned

50, 0

Join Date: Nov 2012

Last Activity: 7 June 2013, 1:42 AM EDT

Posts: 50

Thanks Given: 2

Thanked 0 Times in 0 Posts

Request to check

Yes, it didnt wrk as output is just first file and

the sample which I provided is above is exactly from real file

shall I attach file?

let me know but its same as my sample provided above.

Priyanka Chopra

View Public Profile for Priyanka Chopra

Find all posts by Priyanka Chopra

11-08-2012

Registered User

1,650, 478

Join Date: Mar 2012

Last Activity: 11 September 2019, 8:06 AM EDT

Posts: 1,650

Thanks Given: 58

Thanked 478 Times in 474 Posts

Quote:

Originally Posted by Priyanka Chopra

Yes, it didnt wrk as output is just first file and

the sample which I provided is above is exactly from real file

I don't know what you are trying.

Please check..

Code:

$ cat file1
F2
B2
CAD
KGM
HTC
CSP

Code:

$ cat file2
F2 XYZ CDT CAD          it is part of agriculture    it is part of university   it is part of ...             it is used for....

KGM HTC CSP      it is part of agriculture    it is part of university   it is part of ...             it is used for....

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="  +" file2
F2           it is part of agriculture    it is part of university   it is part of ...             it is used for....
CAD           it is part of agriculture    it is part of university   it is part of ...             it is used for....
KGM       it is part of agriculture    it is part of university   it is part of ...             it is used for....
HTC       it is part of agriculture    it is part of university   it is part of ...             it is used for....
CSP       it is part of agriculture    it is part of university   it is part of ...             it is used for....

Is this what you want..?

I hope this helps

pamu

View Public Profile for pamu

Find all posts by pamu

11-08-2012

Banned

50, 0

Join Date: Nov 2012

Last Activity: 7 June 2013, 1:42 AM EDT

Posts: 50

Thanks Given: 2

Thanked 0 Times in 0 Posts

Hi

It seems some error

Finally I am attaching both BD(first) 1diseasedrug(second) files and output file(see)

Pleas check it

these are just part as the files are big and I also got one error

Code:

bash-3.2$ 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}}}' BD FS="  +" diseasedrugbank >see
awk: (FILENAME=diseasedrugbank FNR=471) fatal: Unmatched ( or \(: /DRD2 ADRA1A  Droperidol      DHBP    DRD2 ADRA1A     The exact mechanism of action is unknown, however, droperidol causes a CNS depression at subcortical levels of the brain, midbrain, and brainstem reticular formation. It may antagonize the actions of glutamic acid within the extrapyramidal system. It may also inhibit cathecolamine receptors and the reuptake of neurotransmiters and has strong central antidopaminergic action and weak central anticholinergic action. It can also produce ganglionic blockade and reduced affective response. The main actions seem to stem from its potent Dopamine(2) receptor antagonism with minor antagonistic effects on alpha-1 adrenergic receptors as well.      A butyrophenone with general properties similar to those of haloperidol. It is used in conjunction with an opioid analgesic such as fentanyl to maintain the patient in a calm state of neuroleptanalgesia with indifference to surroundings but still able to cooperate with the surgeon. It is also used as a premedicant, as an antiemetic, and for the control of agitation in acute psychoses. (From Martindale, The Extra/
bash-3.2$

so output is not as expected in these files

BD1.txt (64.1 KB)

1diseasedrug.txt (37.5 KB)

1output.txt (21.2 KB)

Priyanka Chopra

View Public Profile for Priyanka Chopra

Find all posts by Priyanka Chopra

11-08-2012

Registered User

1,650, 478

Join Date: Mar 2012

Last Activity: 11 September 2019, 8:06 AM EDT

Posts: 1,650

Thanks Given: 58

Thanked 478 Times in 474 Posts

From your sample file it looks like your file2 has no pattern to get the required result.

still try using "\t"

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

pamu

View Public Profile for pamu

Find all posts by pamu

11-16-2012

Banned

50, 0

Join Date: Nov 2012

Last Activity: 7 June 2013, 1:42 AM EDT

Posts: 50

Thanks Given: 2

Thanked 0 Times in 0 Posts

Hi Pamu

This semed to be a good code I apllied to many other files and suddenly I realise it didnt wrok fo rmy many other files and my hard goes waste!

Becasuse it was matching with just first entry of second file

Kindly help me as I have to again run on all those files.

I have attachedone of those files

May be it has happened becuase second file contain first oclumn with entire separarated by comma.........

sorry for inconvenience.

Kindly guide me