http://www.andrewmcdonough.co.uk/wiki/doku.php?id= 2008-11-19T17:09:39+01:00 text/html 2008-09-23T10:36:36+01:00 andrew@78.86.158.171 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:sed sed sed is a stream editor. It takes input from a file, processes it, and outputs to STDOUT: Substitutions: sed -e 's/Andrew/Andy/' -e 's/McDonough/Donut/' file Read somefile and substitute all occurrences of somexpession with a replacement cat so... text/html 2008-07-09T12:34:28+01:00 andrew@193.202.113.219 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:excel Excel Excel Web Queries Excel Macros Excel Annoyances Excel Validation To open the VBA editor in Excel hit Alt-F11 To view the object model, hit F2 while in the VBA editor. Syntax Declaring Variables Dim mystring As String Iterating over a Se... text/html 2008-05-22T11:52:53+01:00 andrew@193.202.113.215 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:samba Samba Samba is a UNIX tool used to share Unix directories on a Windows Network, or access Windows shares from a UNIX Network. Mounting a Windows Share on a Linux FS You will need to install the samba client on machines where you want to access shar... text/html 2008-05-14T20:30:20+01:00 andrew@80.229.151.248 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:computers Programming Ruby Ruby Ruby on Rails Java Java Eclipse Hibernate Struts JSP Middlegen JSTL Ant Certification Lucene Groovy Taglibs Tomcat SCJP Annotations Autoboxing Quartz - An open source Java scheduling framework Acegi - Security for Java usin... text/html 2008-04-17T13:44:47+01:00 andrew@193.202.113.219 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:ruby Ruby Ruby is an object oriented scripting language. Ruby is of particular interest because of the popular framework Ruby on Rails Getting Started Command line ruby irb --simple-prompt Documentation ri ClassName ri ClassName#method_name Command li... text/html 2008-04-16T22:44:07+01:00 andrew@80.229.151.248 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:awk awk awk is a data processing tool that scans text one line at a time and checks for a match against one or more patterns (regular expresions). If the line matches a patterns, some it is processed. Command line syntax: awk <search pattern> {&lt... text/html 2008-04-08T15:17:10+01:00 andrew@193.202.113.219 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:ruby_on_rails Ruby on Rails Ruby on Rails is a web framework that has turned the IT industry on its head. It is an opinionated framework, which follows serveral important rules: Convention over configuration - Rather than spending your life configuring the frame... text/html 2008-01-21T23:11:39+01:00 andrew@80.229.151.248 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:interesting_projects [created] Interesting Projects http://www.nakedyak.com/ ... text/html 2008-01-04T09:44:33+01:00 andrew@193.202.113.220 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=start Programming Ruby Ruby Ruby on Rails Java Java Eclipse Hibernate Struts JSP Middlegen JSTL Ant Certification Lucene Groovy Taglibs Tomcat SCJP Annotations Autoboxing Quartz - An open source Java scheduling framework Acegi - Security for Java usin... text/html 2007-12-07T11:42:48+01:00 andrew@193.202.113.215 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:excel_validation [created] Excel Validation Customers often like to use Excel as a means of consolidating data that needs to be imported into a database. Asking them to adhere to a consistent formatting can be a real pain. Fortunately, Excel has an option to restrict cells to... text/html 2007-08-07T12:28:00+01:00 andrew@193.202.113.215 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:excel_annoyances Excel Annoyances Excel Automatic Formatting One of the things that annoys me most about Excel, is when it tries to predict what you are going to do next. An example of this is it's automatic typing of pasted data. This is particularly annoying when ... text/html 2007-08-07T12:03:34+01:00 andrew@193.202.113.215 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:excel_macros [created] Excel Macros Macros using relative references One of the annoying things about recording Excel Macros, is that their default behaviour will record absolute references to the cells operated on. You can change this, so that the Macro will operate on c... text/html 2007-07-23T11:34:56+01:00 andrew@193.202.113.218 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:linux_useful_commands Useful Linux Commands File System Create a symbolic link: ln -s source target List disk usage of directorys, but limit output to one level. Show size (blocksize) in bytes: du --max-depth=1 --block-size=1 As above but sort by decending use: du --ma... text/html 2007-07-09T14:30:08+01:00 andrew@193.202.113.218 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:certification Java Certification Sun's Java Certification Path Sun Certified Java Programmer (310-025) -> Sun Certified Java Developer -> Sun Certified Enterprise Architect (310-051) http://www.jchq.net/essentials/ http://uk.sun.com/training/catalog/cour... text/html 2007-07-09T13:24:19+01:00 andrew@193.202.113.218 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:web_design Web Design Scope This document covers design principles and *not* technologies. For technologes please visit the following links: HTML Javascript CSS Speed WebSiteOptimization.com Affordances In design, an affordance is a visual clue to the fu... text/html 2007-07-04T12:41:41+01:00 andrew@80.229.151.248 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:oracle:oracle_for_mysql_users Oracle for MySQL Users This page is intended for those who know how to use MySQL, and want to learn the Oracle syntax quickly, without having to trawl through a book teaching them from scratch about relational databases. It assumes knowledge of MySQ... text/html 2007-05-22T14:46:51+01:00 andrew@193.202.113.219 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:ssh_tunneling SSH Tunneling You can use an SSH connection to tunnel a connection on another port to a third sever on an internal network. Chose an abitrary port e.g. 1234 ssh -L xxxx:<app server>:yyyy <username>@<ssh hostname> e.g. you could ... text/html 2007-03-16T16:13:10+01:00 andrew@193.202.113.217 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:fonts Fonts Identification of Fonts For identication of fonts, or to find a font by name, use: http://www.identifont.com/ Serif Fonts Serifs are the small ticks at the end of letters. Serif fonts use these ticks, and in printed media, can guide the read... text/html 2007-02-27T16:30:46+01:00 andrew@193.202.113.217 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:photoshop [created] Photoshop Removing Red-Eye ... text/html 2007-02-27T09:58:17+01:00 andrew@193.202.113.217 http://www.andrewmcdonough.co.uk/wiki/doku.php?id=computers:oracle:sql_plus SQL*Plus SQL*Plus is annoying as it has no command editing, completion or history. gqlplus is a better implementation which has all of these so should be used instead. Below, gqlplus will be referred to as SQL*plus. http://gqlplus.sourceforge.net/ ...