AnsweredAssumed Answered

removing space from field

Question asked by wrcooke on Dec 30, 2008
Latest reply on Jan 20, 2011 by RandyHaaga


removing space from field


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