drugname varchar, activeingred varchar);

  drugname varchar, activeingred varchar);

== Formatting application.txt ==

=== Formatting application.txt ===

I removed the spaces using the regex for the tab character which was <code>\t</code>.

I removed the spaces using the regex for the tab character which was <code>\t</code>.

Redirected the processed data and formatted the original lines using:  

Redirected the processed data and formatted the original lines using:  

  application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag, CurrentPatentFlag,ActionType,ChemicalType,Ther_Potential,Orphan_Code) values(/g" | sed "1d"  > ~/public_html/application.sql.txt\

  application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag, CurrentPatentFlag,ActionType,ChemicalType,Ther_Potential,Orphan_Code) values(/g" | sed "1d"  > ~/public_html/application.sql.txt\