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

Len Function

Returns the number of characters in a string.

Syntax

Len (string)

string is the string whose characters are counted. All characters are counted, including spaces and trailing blanks. If string is a null value, 0 is returned.

Examples

These examples find the length of a string, or a number when expressed as a string:

MyStr = "PORTLAND, OREGON" 
StrLen = Len(MyStr)                ;* answer is 16
NumLen = Len(12345.67)                ;* answer is 8 (note
                  ;* decimal point)

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

Update timestamp Last updated: 2010-09-30