Dear All, I have a field “State” in the Employee table that has 3 characters: 2 alpha and one space such as "CA ". I need to delete that space. What is the best way to do it? Thanks Denis Petrov
Run a ProcessingOnly Report over the Employee Table which does only this in the OnAfterGetRecord Trigger:
State := DELCHR(State,'<>'); MODIFY; This will delete any leading and/or trailing spaces in the State Field. Lookup the DELCHR on the C/SIDE Reference Guide for further options.