* I began to edit the products.txt file by first removing the first line that contained only the column headers. A quick search of the file in excel revealed that there were several lines that contained single quotes. Those single quotes would need to be escaped using two single quotes. To test, I performed both of those commands at the same time.

* I began to edit the products.txt file by first removing the first line that contained only the column headers. A quick search of the file in excel revealed that there were several lines that contained single quotes. Those single quotes would need to be escaped using two single quotes. To test, I performed both of those commands at the same time.

  cat Product.txt | sed "1D" | sed "s/'/''/g"

  cat Product.txt | sed "1D" | sed "s/'/<nowiki>''</nowiki>/g"

* After confirming that worked, I began separating the columns with commas, and wrapping the varchars with quotes. The third, fourth, sixth, eigth, and ninth columns needed to be wrapped in quotes. The procedure for doing so was the same as before: I stepped through each tab, adding quotes around the ones that needed quotes. The command in full was as follows:

* After confirming that worked, I began separating the columns with commas, and wrapping the varchars with quotes. The third, fourth, sixth, eigth, and ninth columns needed to be wrapped in quotes. The procedure for doing so was the same as before: I stepped through each tab, adding quotes around the ones that needed quotes. The command in full was as follows: