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.

Pattern Format

substr(field name , where to start from , how many characters 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 , -1 , 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