Table of Contents

String Length

Description

Determines a column's total string length per row.

Calculation Editor

Options

Input Parameter Values Input Values
Strip Blanks Check Box
Only Rollup If Generic Criteria

Input

Input Input Values Required
Input 1 Column or Literal

Remarks

  • Strip Blanks will remove the blank characters in a column before doing the String Length calculation. For example, the business unit column frequently has leading spaces. If you want those spaces to be maintained in the string length count, uncheck the "Strip Blanks" check box.

Example

  1. Input: 48AC83
  2. Quick Calculations > Text > String Length
  3. Output: 6