Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Length - Find Length of the String in Informatica

  1. Forget Code
  2. Informatica
  3. Length - Find Length of the String
The LENGTH function returns the number of characters in a string, including trailing
blanks. It is available in Informatica Expression Transformation.

General Syntax
LENGTH(Column_Name)


The following expression returns the length of each Student_Name
LENGTH(Student_NAME)


STUDENT_NAME              RETURN VALUE
Leonardo             8
NULL                 NULL
Edwin Britto             12