You can group parts of the pattern expression enclosing them with “\(” and “\)” and refer to them inside the replacement pattern by their special number \1, \2 ... \9. Typical example is swapping first two words of the line:
s:\(\w\+\)\(\s\+\)\(\w\+\):\3\2\1: where \1 holds the first word, \2 - any number of spaces or tabs in between and \3 - the second word.
Most awesome stuff:
SELECT contactID
, RTRIM
( xmlagg (xmlelement (c, subjectName || ‘,’) order by subjectName).extract (’//text()’)
, ‘,’ ) AS concatenated
FROM tableExperts
GROUP BY contactID;
This will convert:
contactID | subjectName
5| 279
5| 701
5| 909
To:
5| 279,701,090
I have had issues with this and removed this change. I don’t recommend it but I have archived the rest of this post.
http://web.archive.org/web/20050319002415/http://www.mikeg2.freeserve.co.uk/masterful/rgb.html
I updated wordpress to 2.5 and now its broke. Damn 
There is a WLAN Optimizer for Vista to fix the lag that windows creates every 60 seconds which is when windows checks the nearby wireless stations. This stuffs up games something shocking! This program is only for Vista and it works.
I have experienced a few problems with firefox, satellite internet connection and webpage time outs. To fix this problem you need to goto the url bar in firefox and goto about:config page. A special config menu for firefox will show up and a search for timeout will display a dozen or so options. network.http.keep-alive.timeout is the entry that needs it’s value increased. I changed it from the default 300 to 1500 and the problem went away.
My neighbour at home got a new projector that boasts “HD READY” and component plugs. However on inspection there is no component plugs, indeed no plugs that can support any sort of HD. But this is incorrect, apparently the VGA port on the projector is the Component port but a separate cable is needed to convert Component to VGA. Specifically RCAx3 to D15HD. This plug doubles as a computer VGA plug and a Component plug but this took over 4 hours to figure out as its not explicitly stated anywhere even on similar projectors. I will update this post when I get the plug and see what the results are.
I’ve published my Xcode Project of what I have done so far, its in the Game Programming Page. Thanks to the tutorials from the SDL website on initialising SDL. Thanks to nehe.gamedev.net for the tutorial on displaying text using letters in a tga file.
The game isn’t much but its further than I’ve gotten before. I’ll probably put it to rest for a while so I can go back to uni work/GTA4.
