# '''Provide the DDL (create table) statements that you used for your application and product tables.'''

# '''Provide the DDL (create table) statements that you used for your application and product tables.'''

#* Application:

#* Application:

#** <code>cat application.txt | sed "s/\t/~/g" | sed -r "s/( ){2}//g" | sed "s/ ~/~/g" | sed "s/~~/~null~/g" | sed "s/~~/~null~/g" | sed "s/~\r$/~null/g" | sed "s/~/~'/1" | sed "s/~/~'/2" | sed "s/~/~'/5" | sed "s/~/~'/7" | sed "s/~/~'/8" | sed "s/~/'~/2" | sed "s/~/'~/3" | sed "s/~/'~/6" | sed "s/~/'~/8" | sed "s/$/'/g" | sed "s/'null'/null/g" | sed "s/~/,/g" | sed "s/^/insert into application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag,CurrentPatentFlag,ActionType,Chemical_Type,Ther_Potential,Orphan_Code) values(/g" | sed "s/$/);/g" > ~/public_html/application.sql.txt</code>

#** <code>cat application.txt | sed "s/\t/~/g" | sed -r "s/( ){2}//g" | sed "s/ ~/~/g" | sed "s/~~/~null~/g" | sed "s/~~/~null~/g" | sed "s/~\r$/~null/g" | sed "s/~/~'/1" | sed "s/~/~'/2" | sed "s/~/~'/5" | sed "s/~/~'/7" | sed "s/~/~'/8" | sed "s/~/'~/2" | sed "s/~/'~/3" | sed "s/~/'~/6" | sed "s/~/'~/8" | sed "s/$/'/g" | sed "s/'null'/null/g" | sed "s/~/,/g" | sed "s/^/insert into application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag,CurrentPatentFlag,ActionType,Chemical_Type,Ther_Potential,Orphan_Code) values(/g" | sed "s/$/);/g" > ~/public_html/application.sql.txt</code>

==Protocol==

==Protocol==

====A New Command====

====A New Command====

# As Anu discovered, one viable character for separating columns is the tilde (<code>~</code>) because it does not appear elsewhere in the file.

# As Anu discovered, one viable character for temporarily separating columns is the tilde (<code>~</code>) because it does not appear elsewhere in the file.

#* <code>sed "s/\t/~/g"</code> replaces all tabs with tildes...

#* <code>sed "s/\t/~/g"</code> replaces all tabs with tildes...

# Still, the consecutive spaces (between SponsorApplicant and MostRecentLabelAvailableFlag) remain. But removing all spaces is problematic because many of the SponsorApplicant entries have spaces in them, which need to stay in the file.  

# Still, the consecutive spaces (between SponsorApplicant and MostRecentLabelAvailableFlag) remain. But removing all spaces is problematic because many of the SponsorApplicant entries have spaces in them, which need to stay in the file.  

# But the previous command leaves a few lingering single spaces at the end of sponsor applicant names. However these will ''always'' precede a tilde.

# But the previous command leaves a few lingering single spaces at the end of sponsor applicant names. However these will ''always'' precede a tilde.

#* <code>sed "s/ ~/~/g"</code> will remove these final spaces.

#* <code>sed "s/ ~/~/g"</code> will remove these final spaces.

# Blank inputs need to be designated with "null." One way to do this is to select for consecutive tildes (remember, tildes now denote the beginning of the column).

# Blank inputs need to be designated with "null." One way to do this is to select for consecutive tildes (remember, tildes now denote the beginning of the column, so the null should succeed the tilde).

#* <code>sed "s/~~/~null~/g"</code> adds "null" between double tildes.

#* <code>sed "s/~~/~null~/g"</code> adds "null" between double tildes.

#* In the case of ''three'' consecutive tildes, the first execution of this command will interrupt the second pair in the triplet, causing sed to not recognize it. For this reason, '''this command must be entered twice.'''  

#* In the case of ''three'' consecutive tildes, the first execution of this command will interrupt the second pair in the triplet, causing sed to not recognize it. For this reason, '''this command must be entered twice.'''  

#* <code>sed "s/^/insert into application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag,CurrentPatentFlag,ActionType,Chemical_Type,Ther_Potential,Orphan_Code) values(/g" | sed "s/$/);/g" > ~/public_html/application.sql.txt</code>

#* <code>sed "s/^/insert into application(ApplNo,ApplType,SponsorApplicant,MostRecentLabelAvailableFlag,CurrentPatentFlag,ActionType,Chemical_Type,Ther_Potential,Orphan_Code) values(/g" | sed "s/$/);/g" > ~/public_html/application.sql.txt</code>

#** ''Note: this command is slightly different than on the tutorial. The final single-quote in the second sed command must be removed.''

#** ''Note: this command is slightly different than on the tutorial. The final single-quote in the second sed command must be removed.''