Shell Programming and Scripting

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 Target_gene name

In the attached file this data is arranged like this along with so much other data mixed in between
End Drug card II....

in this way there are many drug cards.


Please check the attached file and Kindly let me know scripting to perform this task.

I want the output shuld be like this:

Hi all

Please check attached file. sorry I forgot to attach previously.

Mani

Hi,

Try this

Code:

awk 'k>0 {if (a[k] && k==2) {print a[1]" "a[2]" "a[3]; a[1]=a[2]=a[3]="";} a[k]=a[k]?a[k]" "$0:$0; k=0;} /^# Drug_Target_.*_Gene_Name/ {k=3;} /^# Generic/ {k=1;} /^# Brand_Name/ {k=2;} END {if (a[1]) print a[1]" "a[2]" "a[3];}' drug_bank.dat

Hi CHirel

Thankyou very much It was very helpful

On the same lines I posted one more question

Extract certain entries from big file:Request to check Hi all


I have a big file which I have attached here.

And, I have to fetch certain entries and arrange in 5 columns


Code:
Name Drug DAP ID disease approved or not

In the attached file data is arranged with tab separated columns in this way:
Quote:
TTDS00001 Name

Drug(s) DAPID Disease name Approved /(blank)


and other data is also present which I dont want to fetch

I want the output should be like this


Quote:
Name Drug DAP ID disease Approved or not

Muscarinic Bethanechol DAP000263 Urinary retention Approved
acetylcholine
receptor
Can u please check once. Highly thankful toyou.

---------- Post updated at 12:00 PM ---------- Previous update was at 01:46 AM ----------

Hi

I found one issue from previous answer because I have to separate into three different columns and its not showing in three columns as there is space beteeen gene names as well as within generic and brand ame then I m trying to make 2 different files with generic and brand names

can we separate brand name and generic name?

means
For only generic name using


For only brand name

Hi

I'm not sure i really understand what you want, but i guess that if you replace in my code,
print a[1]" "a[2]" "a[3] by print a[1]":"a[2]":"a[3], then you will have an output with always 3 fields separated by ":".

This way you can process them is any way you want, being sure that field 1 is always generic & field 2 is always brand name.