Information icon IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
space Feedback

MCN

Extracts all numeric characters in a field.

Syntax

MCN

Examples

The following example shows the effect of an MCN conversion code with the Iconv function:

Conversion Expression
Internal Value
X = Iconv("John Smith 1-234", "MCN")
X = "1234"

The following example shows the effect of an MCN conversion code with the Oconv function:

Conversion Expression
External Value
X = Oconv("John Smith 1-234", "MCN")
X = "1234"

PDFThis topic is also in the IBM InfoSphere DataStage Server Job Developer's Guide.

Update timestamp Last updated: 2010-09-30