First off I HATE SSPU.

Why!!! Why would you buy this product, bolt it on and rebrand it as stellent/oracle?..
It causes so many problems and gives me real bad headaches, especially when trying to setup transformations..

The documentation for SSPU makes everything sound so simple… That is; if you can find any documentation… it makes SSPU sound like a great asset.. But in reality I haven`t been able to get a third of the commands to work.. Maybe I`m using them incorrectly.. But your try raising a service request with Oracle and the engineers run into the same problems..

I just don`t understand why Stellent didn’t just write their own transformation tool which plugged into the inbound refinery.. Now that would of been a good idea and I really hope that Oracle have plans to replace it in the future.

Any way over the next couple of months I will be updating this post with some of the XML configs I use to do transformation you never know it may help some of you guys in the future..

Read On to see the examples..

Before you begin, I would recommend upgrading to the latest version of SSPU 10gR3.
I have tested this on 7.x+ and it seems to work fine.

1. Howto parse and transform content:

Example of using regex to transform the localhost domain.

s/http:\/\/localhost/http:\/\/ecm.bluestudios.com/g

This will globally replace all instances of whatever is in s/(before)/(after)/g
(s is for search, g is for globally and it will replace before with after). You can transform any content not only webaddresses.

2. Working with triggers

This shows how you can use command prompt within SSPU

<trigger when="after" type="cmd">
cmd /C mkdir "C:\inetpub\global\docs"
</trigger>

This basic cmd will create a new folder if it does not exist.
But whats good about this is you don`t necessary need to install Publisher, you could create a trigger to replicate publisher and really customise what you do and where you publish your content.

3.