5 Replies Latest reply: Jan 22, 2014 7:23 AM by Sneha Topre RSS

    Problem with substring function

      Hi,


      My problem is I want to compare the set of values of a field with a String.

      I m getting problem with substring function.

      I m using expression like

       

      =SubStringCount(concat(KRMO_MODULE_NAME,','),'Enrollment')

       

      it is working fine.but values of field KRMO_MODULE_NAME are:

      Compliance
      Data Management
      Data Timeliness
      Enrollment
      Enrollment/Discontinuation
      Monitoring
      Monitoring Visits
      Protocol Deviations
      Queries
      Safety
      SDV

       

      So if I m matching the  string with 'Enrollment' , so there are two values containg this part of string.

      So it is giving incorrect result.

      So which function should i use to compare for the exact substring.?

       

       

      Need urgent help....