Use the LEFT() function in your formula. The basic syntax of this function is LEFT(str,length) where str=field name of string type and length=number of characters to remove

The following examples are applicable to Crystal syntax:

LEFT("abcdefg", 4)

Returns "abcd" as the first four letters in the string.


Retrieves the first character or letter contained in the {CUSTOMER.EN_US} field.