Home
> Crystal Reports > Remove trailing character in Crystal Reports Formula
Remove trailing character in Crystal Reports Formula
This is a relatively straight forward formula to help you remove the last character of a string.
It may be that you wish to remove a period from the end of a field name or an inverted comma. Here we will call our field {DBField1}
left({DBField1},len({DBField1})-1)
All we are doing here is using the left function to display all the characters to the left, excluding the last chacter, (which is determineted by the “Len” function)
Categories: Crystal Reports
Crystal Reports, forumla, Function, remove last character
Comments (0)
Trackbacks (0)
Leave a comment
Trackback