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?

Questions by karthumyl   answers by karthumyl

Showing Answers 1 - 8 of 8 Answers

swati

  • Feb 20th, 2007
 

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

  Was this answer useful?  Yes

pal

  • Mar 6th, 2007
 

use chrcode().

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions