1 Reply Latest reply on Nov 9, 2008 4:07 PM by davidhead

    Filtering text

    mandrax

      Title

      Filtering text

      Post

      How do I create a calculation that filters out the last 7 characters of text from a field?

        • 1. Re: Filtering text
          davidhead
            

          When you say "...filters out the last 7 characters...", do you mean you want to keep them or remove them?

           

          If you want to keep just the last seven characters, use this:

           

             Right ( field; 7 )

           

          If you want to chop them off, use this:

           

             Left ( field; Length ( field ) - 7 )

           

          But I would be interested in why you want to keep or chop the last seven characters ;) I suspect it would be better if the calculation was smarter than that. But it may work for you OK.