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

substring-after

substring-after

Returns the characters in a string that occurs after a substring.

Syntax

substring-after (
string, substring
)
The following table describes the arguments for this function:
Argument
Description
string
String datatype. Passes the string to search.
substring
String datatype. Passes a substring to search for in the string.

Return Value

String.
Empty string if the substring is not found.
NULL if a value passed to the function is NULL.

Example

The following expression returns the string of characters in PHONE that occurs after the area code (415):
substring-after ( PHONE, (415) )
The following table includes examples of arguments and return values:
PHONE
RETURN VALUE
(415)555-1212
555-1212
(408)368-4017
-
NULL
NULL
(415)366-7621
366-7621

0 COMMENTS

We’d like to hear from you!