TECode varchar, ReferenceDrug int, drugname varchar, activeingred varchar);

  TECode varchar, ReferenceDrug int, drugname varchar, activeingred varchar);

* After creating the tables, I needed to change the structure of the txt files so that I could insert them into the tables. I knew that I needed to add the insert command at the start of each line. I began with the application.txt file. I first ran the command to see whether or not I had the correct command to add the insert statements at the beginning of each line.

* After creating the tables, I needed to change the structure of the txt files so that I could insert them into the tables. I knew that I needed to add the insert command at the start of each line. I began with the application.txt file. I first ran the command to see whether or not I had the correct command to add the insert statements at the beginning of each line.

  cat application.txt | sed "s/^/insert into application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailable,

  cat application.txt | sed "s/^/insert into application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag,

  CurrentPatentFlag,ActionType,ChemicalType,Ther_Potential,Orphan_char) values(/g"

  CurrentPatentFlag,ActionType,ChemicalType,Ther_Potential,Orphan_Code) values(/g"

* The command seemed to be correct, so next I needed to remove the first line, which contained the column headers.  

* The command seemed to be correct, so next I needed to remove the first line, which contained the column headers.