Hi all

I have a problem similar to someone else while getting output using awk and retrieving certain entries.

From the attached sample file of big file I have to retreive following headings in columns from each drug card as there are many drug cards..

# Drug_Target_.*_Gene_Name

# Brand_Name

# Generic_Name

# Drug_Type

# Indication

#Mechanism_ Of_ Action


Using below code, my output is a bit random and wired even though some part are correct as mehanism keep on repeating agian and again

some time starts with the next line rather than being fit in columns

Brand name keep going wrong sometime!!

I am trying to retreive

awk 'k>0 {if (a[k] && k==2) {print a[1]":"a[2]":"a[3]":"a[4]":"a[5]":"a]6]; a[1]=a[2]=a[3]=a[4]=a[5]=a[6]"";} a[k]=a[k]?a[k]","$0:$0; k=0;} /^# / {k=1;} /^# Generic/ {k=1;} /^# Brand_Name/ {k=2;}  /^# Drug_Type/ {k=3;} /^# Indication/ {k=5;} /^# Mechanism_ Of_ Action / {k=6;} END {if (a[1]) print a[1]":"a[2]":"a[3]":"a[4]":"a[5]":"a[6];}' drugbank.txt >drugbanknew.txt

Attached Files

Input file.txt (15.8 KB, 14 views)

Not sure I understand what you want to achieve. Pls post desired output.

BTW, your script above contains a few typos...

Hi Rudi

I have to fetch above mentioned bold headings in my first post as columns in my expected output.
This input file is sample of my big input file which contain many drug cards
So,

My out put shoulbe like following six coulmns



F2 lepirudin refuldan approved " sentence under indication" "sentence under machanism of action"

As my real input file is big so there will be many rows with different names like this and with my current code these rows are overlapping!

see my post #2.

Sorry I was not able to get your post#2 could you please explain which one it is.

High thanks for this

Post #2

Not sure I understand what you want to achieve. Pls post desired output.

Hi

For my above attached sample input expected output is 6 columns like this:

F2    Lepirudin    Refludan    Approved    For the treatment of heparin-induced thrombocytopenia     Lepirudin forms a stable non-covalent complex with alpha-thrombin, thereby abolishing its ability to cleave fibrinogen and initiate the clotting cascade. The inhibition of thrombin prevents the blood clotting cascade.

# Drug_Target_.*_Gene_Name

# Brand_Name

# Generic_Name

# Drug_Type

# Indication

#Mechanism_ Of_ Action