How to parse characters using functions in the expression transformation. For example if a column has character like mgr=a. I have to parse the character 'mgr='. Which function should I use?

swati

• Feb 20th, 2007

 

Hi,
use IIF function.
IIF(mgr='a','mgr=',null)
Thanks.

karthumyl

 Profile Answers by karthumyl Questions by karthumyl

• Mar 2nd, 2007

 

Which characer function can I use to do the same function?

pal

• Mar 6th, 2007

 

use chrcode().

kanak3

 Profile Answers by kanak3 

• Mar 26th, 2007

 

Pal....We can not use charcode() function here.

When you configure the PowerCenter Server to run in ASCII mode, CHRCODE returns the
numeric ASCII value of the first character of the string passed to the function. ASCII values
fall in the range 0 to 255.
When you configure the PowerCenter Server to run in Unicode mode, CHRCODE returns
the numeric Unicode value of the first character of the string passed to the function. Unicode
values fall in the range 0 to 65,535.