You can use like the below
You may find the below solution useful from Informatica Marketplace web site. You can get clear idea on how to use Regular expression in PewerCenter. Please follow the below link to download the solution with detailed user guide.
You may also find many other tools and solutions from the same web site.
A small correction.. I suppose, there should be a .(dot) before *(astrik).
Divya, could you please try this and confirm?
Please try below suggested solutions.
Hope the above helps you
As a side note, using a regular expression for this kind of task is a waste of processing power and time. This can be done far faster by using the following DECODE() invocation:
InStr( Column_Name, 'ORGIN') > 0, 'ORIGIN',
InStr( Column_Name, 'DEST') > 0, 'DESTINATION',
This is far faster to execute than regular expressions. And in this case it's good to use because you are searching for a fixed string value and not for something "variable".