Difference between revisions of "Emilysimso Week 6"
From LMU BioDB 2015
Emilysimso (Talk | contribs) (Edited command sequence) |
Emilysimso (Talk | contribs) (Added create table sequence) |
||
| Line 2: | Line 2: | ||
# DDL (create table) statements | # DDL (create table) statements | ||
#* create table application3 (ApplNo int, ApplType varchar, SponsorApplicant varchar, MostRecentLabel varchar, AvailableFlag varchar, CurrentPatent varchar, Flag int, ActionType varchar) | #* create table application3 (ApplNo int, ApplType varchar, SponsorApplicant varchar, MostRecentLabel varchar, AvailableFlag varchar, CurrentPatent varchar, Flag int, ActionType varchar) | ||
| + | #* create table Product2 (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus varchar, TECode varchar, ReferenceDrug varchar, drugname varchar, activeingred varchar) | ||
# sed command sequences | # sed command sequences | ||
#*cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/\r$/);/g" | sed "s/values (......\t/&, /g" | sed "s/ N\t/'N', /g" | sed "s/\t, A/, 'A', /g" | sed "s/False\t/ 'False',/g" | sed "s/,AP\t/ 'AP', /g" | sed "s/S\t/ 'S'/g" | sed "s/P\t/ 'P'/g" | sed "s/'AP', 1\t/'AP', 1,/g" | sed "s/'AP', 3\t/'AP', 3,/g" | sed "s/'AP', 5\t/'AP', 5,/g" | sed "s/'AP', 7\t/'AP', 7,/g" | sed "s/, N\t/, 'N', /g" | sed "s/, N /, 'N', /g" | sed "s/\t, 'N',/, 'N',/g" | sed "s/\t,'N'/, 'N' /g" | sed "s/'N' ,/'N', /g" | sed "s/\t 'False',/, 'False',/g" | sed "s/'N',\t/'N', /g" | sed "s/\t, 'False'/, 'False'/g" | sed "s/'A', \t/'A', '/g" | sed "s/'N', /'N' '/g" | sed "s/'N'/'N',/g" | sed "s/\t//g" | sed "s/ //g" | sed "s/'A', /'A', '/g" | sed "s/, 'False'/', 'False/g" | sed "s/'False 'AP'/'False', 'AP'/g" | sed "s/'False,TA/'False', 'TA'/g" | #*cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/\r$/);/g" | sed "s/values (......\t/&, /g" | sed "s/ N\t/'N', /g" | sed "s/\t, A/, 'A', /g" | sed "s/False\t/ 'False',/g" | sed "s/,AP\t/ 'AP', /g" | sed "s/S\t/ 'S'/g" | sed "s/P\t/ 'P'/g" | sed "s/'AP', 1\t/'AP', 1,/g" | sed "s/'AP', 3\t/'AP', 3,/g" | sed "s/'AP', 5\t/'AP', 5,/g" | sed "s/'AP', 7\t/'AP', 7,/g" | sed "s/, N\t/, 'N', /g" | sed "s/, N /, 'N', /g" | sed "s/\t, 'N',/, 'N',/g" | sed "s/\t,'N'/, 'N' /g" | sed "s/'N' ,/'N', /g" | sed "s/\t 'False',/, 'False',/g" | sed "s/'N',\t/'N', /g" | sed "s/\t, 'False'/, 'False'/g" | sed "s/'A', \t/'A', '/g" | sed "s/'N', /'N' '/g" | sed "s/'N'/'N',/g" | sed "s/\t//g" | sed "s/ //g" | sed "s/'A', /'A', '/g" | sed "s/, 'False'/', 'False/g" | sed "s/'False 'AP'/'False', 'AP'/g" | sed "s/'False,TA/'False', 'TA'/g" | ||
#* cat Product.txt | sed "s/^/insert into Product2 (ApplNo, ProductNo, Form, Dosage, ProductMktStatus, TECode, ReferenceDrug, drugname, activeingred) values (/g" | sed "s/\t/', /g" | sed "s/TABLET,/TABLET/g" | sed "s/', /', '/g" | sed "s/'',/null,/g" | sed "s/', '00/, 00/g" | sed "s/00.',/&',/g" | sed "s/',',/,/g" | sed "s/'.',/'&,',/g" | sed "s/''//g" | sed "s/',,',/,/g" | sed "s/00., '/&'/g" | sed "s/''//g" | sed "s/ SODIUM; /SODIUM/g" | sed "s/;//g" | sed "s/\r$/');/g" | sed "s/ 0.., /&'/g" | sed "s/', '0/, 0/g" | sed "s/, 0..',/&'/g" | sed "s/','/,/g" | sed "s/5'/5/g" |sed "s/, 0...MG/'&/g" | sed "s/0...MG/'&/g" | sed "s/, 0..MG/'&/g" | sed "s/0..MG/'/g" | sed "s/, 0....MG/'&/g" | sed "s/0....MG/'&/g" | sed "s/EQ '/EQ /g" > ~/public_html/Product.sql.txt | #* cat Product.txt | sed "s/^/insert into Product2 (ApplNo, ProductNo, Form, Dosage, ProductMktStatus, TECode, ReferenceDrug, drugname, activeingred) values (/g" | sed "s/\t/', /g" | sed "s/TABLET,/TABLET/g" | sed "s/', /', '/g" | sed "s/'',/null,/g" | sed "s/', '00/, 00/g" | sed "s/00.',/&',/g" | sed "s/',',/,/g" | sed "s/'.',/'&,',/g" | sed "s/''//g" | sed "s/',,',/,/g" | sed "s/00., '/&'/g" | sed "s/''//g" | sed "s/ SODIUM; /SODIUM/g" | sed "s/;//g" | sed "s/\r$/');/g" | sed "s/ 0.., /&'/g" | sed "s/', '0/, 0/g" | sed "s/, 0..',/&'/g" | sed "s/','/,/g" | sed "s/5'/5/g" |sed "s/, 0...MG/'&/g" | sed "s/0...MG/'&/g" | sed "s/, 0..MG/'&/g" | sed "s/0..MG/'/g" | sed "s/, 0....MG/'&/g" | sed "s/0....MG/'&/g" | sed "s/EQ '/EQ /g" > ~/public_html/Product.sql.txt | ||
Revision as of 07:02, 12 October 2015
Questions to Answer
- DDL (create table) statements
- create table application3 (ApplNo int, ApplType varchar, SponsorApplicant varchar, MostRecentLabel varchar, AvailableFlag varchar, CurrentPatent varchar, Flag int, ActionType varchar)
- create table Product2 (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus varchar, TECode varchar, ReferenceDrug varchar, drugname varchar, activeingred varchar)
- sed command sequences
- cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/\r$/);/g" | sed "s/values (......\t/&, /g" | sed "s/ N\t/'N', /g" | sed "s/\t, A/, 'A', /g" | sed "s/False\t/ 'False',/g" | sed "s/,AP\t/ 'AP', /g" | sed "s/S\t/ 'S'/g" | sed "s/P\t/ 'P'/g" | sed "s/'AP', 1\t/'AP', 1,/g" | sed "s/'AP', 3\t/'AP', 3,/g" | sed "s/'AP', 5\t/'AP', 5,/g" | sed "s/'AP', 7\t/'AP', 7,/g" | sed "s/, N\t/, 'N', /g" | sed "s/, N /, 'N', /g" | sed "s/\t, 'N',/, 'N',/g" | sed "s/\t,'N'/, 'N' /g" | sed "s/'N' ,/'N', /g" | sed "s/\t 'False',/, 'False',/g" | sed "s/'N',\t/'N', /g" | sed "s/\t, 'False'/, 'False'/g" | sed "s/'A', \t/'A', '/g" | sed "s/'N', /'N' '/g" | sed "s/'N'/'N',/g" | sed "s/\t//g" | sed "s/ //g" | sed "s/'A', /'A', '/g" | sed "s/, 'False'/', 'False/g" | sed "s/'False 'AP'/'False', 'AP'/g" | sed "s/'False,TA/'False', 'TA'/g"
- cat Product.txt | sed "s/^/insert into Product2 (ApplNo, ProductNo, Form, Dosage, ProductMktStatus, TECode, ReferenceDrug, drugname, activeingred) values (/g" | sed "s/\t/', /g" | sed "s/TABLET,/TABLET/g" | sed "s/', /', '/g" | sed "s/,/null,/g" | sed "s/', '00/, 00/g" | sed "s/00.',/&',/g" | sed "s/',',/,/g" | sed "s/'.',/'&,',/g" | sed "s///g" | sed "s/',,',/,/g" | sed "s/00., '/&'/g" | sed "s///g" | sed "s/ SODIUM; /SODIUM/g" | sed "s/;//g" | sed "s/\r$/');/g" | sed "s/ 0.., /&'/g" | sed "s/', '0/, 0/g" | sed "s/, 0..',/&'/g" | sed "s/','/,/g" | sed "s/5'/5/g" |sed "s/, 0...MG/'&/g" | sed "s/0...MG/'&/g" | sed "s/, 0..MG/'&/g" | sed "s/0..MG/'/g" | sed "s/, 0....MG/'&/g" | sed "s/0....MG/'&/g" | sed "s/EQ '/EQ /g" > ~/public_html/Product.sql.txt
