See
http://secretGeek.net/wscg.htm
A new drop down list lets you insert some useful little function calls
into the pattern.
Working so far:
TO UPPER CASE
to lowercase
entire current row
current row number (zero based)
current row number (one based)
if statement.
There's also some work in progress functions like:
To sentence case (i.e. first word capitalised, the rest not.)
To title case (ever word capitalised)
To camel case (turn 'Microsoft word' into 'microsoftWord')
To pascal case (turn 'Microsoft word' into 'MicrosoftWord')
To words (splits a camelCaseWord into multiple words)
Not yet an ability for users to add their own macros (and reuse them
across sessions).
This would be handy though.
(i'm using WSCG in my day job at the moment, so it's getting some love)