Difference between revisions of "Troque Week 6"

From LMU BioDB 2015
Jump to: navigation, search
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

User Page        Bio Databases Main Page       


Creating the Table on PostgreSQL

Processing the Data on the Command Line

Assignment Links

Weekly Assignments

Individual Journal Entries

Shared Journal Entries