create table product (ApplNo int references application, ProductNo int, Form varchar,

  create table product (ApplNo int references application, ProductNo int, Form varchar,

  Dosage varchar, ProductMktStatus int, TECode varchar, ReferenceDrug int,

  Dosage varchar, ProductMktStatus int, TECode varchar, ReferenceDrug int,

  drugname varchar, activeingred varchar)

  drugname varchar, activeingred varchar);

== Processing the Data on the Command Line ==

== Processing the Data on the Command Line ==

Before starting this assignment, I didn't realized that I could easily remove the spaces using the regex for the tab character <code>\t</code>, and so I tried to take out the unnecessary blank spaces using the regex <code>\s*</code>. The result of using this method is the following (which didn't really work out since I got frustrated from all the outliers in this txt file and I eventually trashed this set of commands):

Before starting this assignment, I didn't realized that I could easily remove the spaces using the regex for the tab character <code>\t</code>, and so I tried to take out the unnecessary blank spaces using the regex <code>\s*</code>. The result of using this method is the following (which didn't really work out since I got frustrated from all the outliers in this txt file and I eventually trashed this set of commands):

cat application.txt |  

cat application.txt |  

  sed -e 's/\s\+/,/2' |  

  sed -e 's/\s\+/,/2' |  

  sed -e 's/\s/,/1'|  

  sed -e 's/\s/,/1'|  

=== Formatting product.txt file ===

=== Formatting product.txt file ===

  cat Product.txt |

  cat Product.txt |

                               (/g" > ~/public_html/Product.sql.txt

                               (/g" > ~/public_html/Product.sql.txt