Removing Extra Characters

Version 2



    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)






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