Removing Extra Characters

Version 2

    Description:

     

    Removes extra characters from the end of a string.

     

     

     

    Example Calculation:

     

    //for example in a field similar to [Size After] (which has a format similar to 1KB, 110KB, 1024KB), the desired output is to remove the KB portion

     

    LEFT([Size After], LEN([Size After])-2)

     

     

     


    Comments:

     

    This calculation is good for when the first part of the string is varying lengths.