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

    Filtering text



      Filtering text


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

        • 1. Re: Filtering text

          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.