Vpachec3: /* Product text file */ added a NOTE

2015-10-14T23:30:17Z

‎Product text file: added a NOTE

Vpachec3: /* Product text file */ linked to sql txt page

2015-10-14T22:59:18Z

‎Product text file: linked to sql txt page

@@ Line 59: / Line 59: @@
 '''FINAL COMMAND''':
    cat Product.txt | sed "s/\t/~/g"|sed "s/'/\"/g"|sed "s/~~/~null~/g"| sed "s/~/~'/2"|sed "s/~/'~'/3"|sed "s/~/'~/4"|sed "s/~/~'/5"| sed s"/~/'~/6"|sed "s/~/~'/7"| sed "s/~/'~'/8"|sed "s/'null'/null/g"|sed "s/~/,/g"|sed "s/^/insert into Product(ApplNo,ProductNo,Form,Dosage,ProductMktStatus,TECode,ReferenceDrug,drugname,activeingred) values(/g" |sed "s/\r$/');/g"|sed "s/\*\*Federal Register determination that product was not discontinued or withdrawn for safety or efficacy Register notice determination that product was not discontinued or withdrawn for safety or efficacy reasons\*\*//g" > ~/public_html/Product.sql.txt
 == Questions to Answer ==

@@ Line 55: / Line 55: @@
 Thus, after playing around with the different commands several times, I got the pipe that worked.
+http://my.cs.lmu.edu/~vpachec3/Product.sql.txt
 '''FINAL COMMAND''':