2 Replies Latest reply on Feb 2, 2012 9:42 AM by Brae

    How to truncate text

    Brae

      Title

      How to truncate text

      Post

      I need to create a field, ShortName, that takes the text in the field, Name, and truncates it to a maximum length of 28 characters (incluidng any spaces and punctuation). So, for example, the ShortName of the Name "Children's Hospital of Greater Middleton" is "Children's Hospital of Great".

      Can someone help me write this caculation?