Skip to content
Infoveave Help

LEN

The LEN function returns a number of characters in a text string.

Applicable to

Calculated Columns

Return Value

  • The LEN function return integer value representing the number of characters in the input text string.
  • If the input is NULL or BLANK, the function returns NULL.

Remark

  • The LEN function is often used to determine the length of a text string, which can be useful for various purposes such as validating input, manipulating strings, or formatting output.
  • LEN function is applicable only for text values.

Syntax

LEN(<expression>)

LEN in Calculated Columns

ExpressionA placeholder in a function that is replaced with the actual column name.
Column NameThe name of the column in the dataset or Datasource that contains the values you want to analyze.

Steps to Use LEN Function

  1. Write the LEN function. For instance LEN(<expression>)
  2. Replace <expression> with VALUE([Column Name]).
  3. Replace the Column Name with the actual name of your column required.
  4. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.
ORDER DATECUSTOMER IDCATEGORYUNIT PRICEMARKET PRICEQUANTITY
2024-01-03CUSTID124Baby Food38.4143.78742
2024-01-07CUSTID182Spices45.5650.815520
CUSTID128543.787410
2024-01-1832.30194
2024-01-22CUSTID8527Cosmetics28.33523.01097
2024-01-26CUSTID528820.18523.01099
2024-01-04CUSTID1245Cereal25.2628.79649
2024-01-09CUSTID2525Cereal44.57550.81558
2024-01-14CUSTID2325Snacks20.1854
CUSTID262Cosmetics40.48546.15292

You can use the LEN function like

LEN(VALUE([CUSTOMER ID]))

The new calculated column ” Text ” will return

ORDER DATECUSTOMER IDCATEGORYUNIT PRICEMARKET PRICEQUANTITYTEXT LENGTH
03-01-2024CUSTID124Baby Food38.4143.787429
07-01-2024CUSTID182Spices45.5650.8155209
CUSTID128543.78741010
18-01-202432.30194
22-01-2024CUSTID8527Cosmetics28.33523.0109710
26-01-2024CUSTID528820.18523.0109910
04-01-2024CUSTID1245Cereal25.2628.7964910
09-01-2024CUSTID2525Cereal44.57550.8155810
14-01-2024CUSTID2325Snacks20.185410
CUSTID262Cosmetics40.48546.152929