Difference between revisions of "Troque Week 6"
From LMU BioDB 2015
m (Commenting out code since it's not working) |
(Added new version of sed commands) |
||
Line 35: | Line 35: | ||
sed "s/null$/&);/g" | | sed "s/null$/&);/g" | | ||
sed "s/'V'$/&);/" > ~/public_html/application.sql.txt | sed "s/'V'$/&);/" > ~/public_html/application.sql.txt | ||
+ | |||
+ | |||
+ | |||
+ | cat application.txt | sed "s/\t/,/g" | sed "s/,/,'/1" | sed "s/,'[A-Z]/&'/1" | sed "s/,/,'/2" | sed "s/\s*,False/',False/1" | sed "s/,/,'/5 " | sed "s/,/',/6" | sed "s/,,/,null,/" | sed "s/,,/,null,/" | sed "s/,\r$/,null/g" | sed "s/,S,/,'S',/g" | sed "s/,P,/,'P',/g" | sed "s/,V/,'V'/g" | sed "s/P\*/'P\*'/g" | ||
--> | --> | ||
{{Template:Troque_Journal}} | {{Template:Troque_Journal}} |
Revision as of 22:19, 14 October 2015
Contents
Creating the Table on PostgreSQL
Processing the Data on the Command Line
Assignment Links
Weekly Assignments
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- No Week 13 Assignment
- Week 14
- Week 15
Individual Journal Entries
- Week 1 - This is technically the user page.
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- No Week 13 Assignment
- Week 14
- Week 15