.. _shorten-field-value-snip:

======================
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