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

    How to truncate text



      How to truncate text


      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?