2 Replies Latest reply: Mar 6, 2013 9:19 AM by Dimitri Pietersz RSS

    String function

      Hi all wizards,


      Client have a table looking like this:


      AAA, BB, CCC, DDDD, EE

      AAA, CCC, DDDD, EE

      CCC, DDDD, EE

      AAA, BB, CCC, DDDD, EE

      AAA, DDDD, EE

      AAA, BB, CCC, DDDD


      I need to capture DDDD, but it moves all the time as a result of bad input in underlying systems. Which string function can I use to do this?

      Can't use Right or Left, Subfield or FindOneOf (as it's not a string) - so what have I left, or am I missing something...



      Best regards


      Torbjörn Ungvall (@Ungvall)

      Senior Business Discovery Manager

      Advectas AB