4 Replies Latest reply: May 15, 2014 10:09 AM by Joe Berry RSS

    Help with Calculated Field

    Joe Berry

      It is cold in Illinois and my brain is frozen.  Can someone help me with what I thought was simple, but I can't seem to come up with a quick and easy solution?

       

      I am trying to validate that a name field contains only alpha (a-z) characters.  IsAlpha will only check a specific character of the name field and Search_XL will only check one specific non-alpha character at a time. 

       

      We are attempting to clean up a less than perfect data conversion.  I appreciate any help you can offer.