5 Replies Latest reply: Jan 12, 2018 5:48 AM by kaan erisen RSS

    Subfield returns first value only

    Mei Zheng Tay

      Hi all,

       

      I have an Application field that has either one or more than one Application name. I use a replace to get ride of any spaces. The App names are separated by a comma. My code is as follows:

      if(isNull(Application),'NIL', if(Application like '*,*',

              Replace(Subfield("Application",','),' ', ''), Replace(Application, ' ', '')))

       

      The problem is with a value like "App A, App B - XXX, App C - XXX"

      The desired result would be like so:

      Application...
      AppA...
      AppB-XXX...
      AppC-XXX...

       

      However I am getting only AppA

      Application...
      AppA...
      AppA...
      AppA...

       

      Any ideas on how I can achieve this splitting?

       

      Update: Am able to split the Application names correctly, it is when linked with another table that only the first Application name appears in the straight table.

       

      Thanks.

       

      Best Regards

      Serena