Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(3 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Is there a PowerCenter function that is equivalent to the LIKE function?
Problem Description

In an Expression transformation, I want to search for the string 'ABC' in the input port.

For example:

IIF(in_port like '%ABC%') then ...

Since PowerCenter does not have a function named LIKE is there an alternative to achieving this logic?

Cause
Solution

You can use the INSTR function to search for the string in the ports.

For example:

IIF(INSTR(in_port,'ABC')!=0,...

The INSTR function returns zero if the search is unsuccessful.
If the search is successful, it will return the position of the character set in the string.

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:10/22/2009 12:45 PMID:13648
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)