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

normalize-space

normalize-space

Removes leading and trailing white space from a string. White space contains characters that do not display, such as the space character and the tab character. This function replaces sequences of white space with a single space.

Syntax

normalize-space (
string
)
The following table describes the argument for this function:
Argument
Description
string
String datatype. Passes a string that contains white space.

Return Value

String.
NULL if the string is NULL.

Example

The following expression removes excess white space from a name:
normalize-space ( NAME )
The following table contains example arguments and return values:
NAME
RETURN VALUE
Jack   Dog
Jack Dog
  Harry   Cat
Harry Cat

0 COMMENTS

We’d like to hear from you!