This content has been marked as final. Show 2 replies
I have a keepchar() function in a formula I use to calculate a keyfield in one of my tables.
That encompasses two letters, "B" and "M" because some shelfs around here all start with "BM". There is, however, one that I do not want and that also has these two letters in the name - not right next to each other, but the KEEPCHAR() function does not by default recognize that.
=> Is there any way I can use that function (just that one, without combining it with any other (I will try that now)) that I can specify for the KEEPCHAR() function that I want to look for those two letters only if they are right next to each other?
Thanks a lot!