Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. Appendix A: XML Datatype Reference
  10. Appendix B: XPath Query Functions Reference

XML Guide

XML Guide

contains

contains

Determines if a string contains another string.

Syntax

contains(
string, substring
)
The following table describes the arguments for this function:
Argument
Description
string
String datatype. Passes the string to examine. The argument is case sensitive.
substring
String datatype. Passes the string to search for in the string. The argument is case sensitive.

Return Value

Boolean.

Example

The following expressions returns TRUE if the NAME contains SHORTNAME:
contains( NAME, SHORTNAME )
The following table includes example arguments and return values:
NAME
SHORTNAME
RETURN VALUE
John
Baer
FALSE
SuzyQ
Suzy
TRUE
WorldPeace
World
TRUE
CASE_SENSITIVE
case
FALSE

0 COMMENTS

We’d like to hear from you!