1 Reply Latest reply: May 15, 2014 9:56 AM by Bill Watson RSS

    Remove last 4 digits from text string

    Guy Chowning

      I have a very simple problem but the solution eludes me.

       

      I need to remove the last 4 characters from a string that varies in length.

       

      Any help will be gratly appreciated

        • Remove last 4 digits from text string
          Bill Watson

          Originally posted by GuyChowning:

          I have a very simple problem but the solution eludes me.

           

          I need to remove the last 4 characters from a string that varies in length.

           

          Any help will be gratly appreciated /b[/quote]sometimes the simplest answers are the most difficult to see      

           

          try RIGHT(,4) will pull off the last 4 characters.

           

          If you want to strip these off and leave the main string then how about

           

          LEFT(,LEN() - 4)