using regular expression in a trim function..possible?

[suneyes]

Hi,
Can I use a regular expression stating the trimming criteria inTRIM function.

I have a requirement to trim the non numerals values of acolumn in a transformer stage.
can any one provide some inputs for my problem??

[ray.wurlod]

There is no capacity to use regular expressions in a trim function. You could create a stage variable containing all the non-numeric characters, and use Convert() to remove these from the input column.