Emilysimso Week 6
From LMU BioDB 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"
