15 Replies Latest reply: Jan 24, 2012 9:35 AM by Erica de+Boer RSS

    Get part of a string

      Hi Everyone,

       

      I have two fields that mean the same from 2 different tables, but are not the same in characters.

       

      The first one is like ODI-1, the second one is like [#ODI-1].

       

      I have tried mid(field, 3, 5) and that works for now. But what do to when we reach [#ODI-10]  until [#ODI-99] or higher?

       

      Or is there maybe another way to connect these fields because they mean the same?