This content has been marked as final. Show 4 replies
I have a data field that as an example contains:-
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.
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