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. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

starts-with

starts-with

Returns TRUE if the first string starts with the second string. Otherwise, returns FALSE.

Syntax

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

Return Value

Boolean.

Example

The following expression determines if NAME starts with FIRSTNAME:
starts-with ( NAME, FIRSTNAME )
The following table contains example arguments and return values:
NAME
FIRSTNAME
RETURN VALUE
Kathy Russell
Kathy
TRUE
Joe Abril
Mark
FALSE

0 COMMENTS

We’d like to hear from you!