4 Replies Latest reply: Nov 15, 2012 11:26 AM by Rolf Beggerow RSS

    How to conditionally remove last Char from a text field ?

      Hi

      I have a data field that as an example contains:-

       

      CB12123A

      REQ03456

      AT1234B

      AT1234A

       

      The A or B in the last Char cannot be guaranteed to always be in the same char position.

       

      What I need to do is strip off the last digit if it is an Alpha Character A or B so I end up with.

       

      CB12123

      REQ03456

      AT1234

      AT1234

       

      I have tried using If Statements with Right and PurgeChar but it does not give desired results.

       

      Any help from the QV community would be welcome