Preface
XML Concepts
Using XML with PowerCenter
Working with XML Sources
Using the XML Editor
Working with XML Targets
XML Source Qualifier Transformation
Midstream XML Transformations
Appendix A: XML Datatype Reference
- XML and Transformation Datatypes
  - XML Date Format
Appendix B: XPath Query Functions Reference
- XPath Query Functions Overview
- Function Quick Reference
- boolean
- ceiling
- concat
- contains
- false
- floor
- lang
- normalize-space
- not
- number
- round
- starts-with
- string
- string-length
- substring
- substring-after
- substring-before
- translate
- true

XML Guide

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5
- 10.4.0

Back Next

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

Rename Saved Search

Table of Contents

XML Guide

XML Guide

normalize-space

normalize-space

Syntax

Return Value

Example