4 Replies Latest reply on Jan 20, 2011 5:52 PM by RandyHaaga

    removing space from field

    wrcooke

      Title

      removing space from field

      Post

      Hi all,

      This has to be simple but Trim, TrimAll functions does not seem to do what I thinkit should do.  I have imported manes into a DB and some of the names have a space as the first character that I want to getrid of.  I had thought using field validationa nd the trim/trimall function would do the trick.  so far nogo.  I am far from a guru (just a learner) so please be patient!  Can you suggest what I need to do please to remove the first space in my field "fname".

      BTW using FM MAc version 8.x

       

      Thanks

      Bill