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