5 Replies Latest reply on Aug 25, 2018 10:04 AM by Deepak Rai

    Find Function nested in a Right function (Trimming)

    Martin Sellers

      Hi all-

      I have address data that contains street information and site information.  I would like to create a calculated field containing only the street information.

       

      Ex :  MCKINLEY PARK LIBRARY @ 1915 W 35TH STREET

       

      I want just : 1915 W 35TH STREET

       

      The function I am using is

       

      if CONTAINS([Location],'@') THEN

      right([Location],FIND([Location],'@')-1)

      ELSE [Location] END

       

      I seem to be getting some wild results.  In this particular case, the output is:

      BRARY @ 1915 W 35TH STREET

       

      Any thoughts on how to solve this?