2 Replies Latest reply: Jan 22, 2016 6:13 AM by Friedrich Hofmann RSS

    Keepchar() function - can I make that more precise?

    Friedrich Hofmann

      Hi,

       

      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!

      Best regards,

       

      DataNibbler