Difference between revisions of "Emilysimso Week 6"
From LMU BioDB 2015
Emilysimso (Talk | contribs) (Adding starting statements/sequences) |
Emilysimso (Talk | contribs) (Edited command sequence) |
||
| Line 3: | Line 3: | ||
#* 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) | ||
# 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/.$/);/g" | sed "s/False/&,/g" | + | #*cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/.$/);/g" | sed "s/values (....../&,/g" | sed "s/False/&,/g" | sed "s/.N /'N'/g" | sed "s/.A /'A'/g" | sed "s/'N'/&,/g" | sed "s/False,.TA/'TA'/g" | sed "s/False,.AP/'AP'/g" | sed "s/'TA'/&,/g" | sed "s/P',../&,/g" | sed "s/TA',../&,/g" |
Revision as of 19:42, 10 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)
- sed command sequences
- cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/.$/);/g" | sed "s/values (....../&,/g" | sed "s/False/&,/g" | sed "s/.N /'N'/g" | sed "s/.A /'A'/g" | sed "s/'N'/&,/g" | sed "s/False,.TA/'TA'/g" | sed "s/False,.AP/'AP'/g" | sed "s/'TA'/&,/g" | sed "s/P',../&,/g" | sed "s/TA',../&,/g"
