agiledata-docs

Table Of Contents

Shorten Field Value

Sometimes you want to shorten the length of of a field value.

For example when you are creating a Consume view to be used as a data services and the system that will import the data has a restriction on the length of the field that can be imported.

Rule Type Format

substr(field name , where to start from , how many characters to keep)

substr(field name , - then how many characters from the end to keep)

Snippits

Shorten right from the first character

Shorten based on the number characters from the first character.

Shorten Text Value

Rule Type = Calculated Output Field

Rule Attribute = substr(Title , 0 , 4)

Examples

• Chief Product Officer becomes Chief

• Managing Director becomes Mana

Shorten left from the last character

Rule Type = Calculated Output Field

Rule Attribute = substr(Title , -4)

Examples

• Chief Product Officer becomes icer

• Managing Director becomes ctor

Shorten in the middle

Rule Type = Calculated Output Field

Rule Attribute = substr(Title , 5 , 4)

Examples

• Chief Product Officer becomes Prod

• Managing Director becomes ing D

Table Of Contents

• Shorten Field Value
  • Rule Type Format
  • Snippits
    • Shorten right from the first character
      • Shorten Text Value
      • Examples
    • Shorten left from the last character
      • Examples
    • Shorten in the middle
      • Examples

arrow_back

Previous

Remove Whitespace

arrow_forward

Next

Split Text