Match function

[#1]

Hi  Guys,

Please Help me   in  below IF condition  when ever  all listed curriculum_title matches its  returned  as 'certified'  ( and condition)

but i want  'or'   condition  any  one of  the  curriculum_title matches    and status matched  then also  i should get  result as  'certified'

if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

        'Corporates Analyst and Associate Director',

        'Covered Bonds Analyst and Associate Director',

        'International Public Finance Analyst and Associate Director',

        'Sovereigns Analyst and Associate Director',

         'Structured Finance Analyst and Associate Director',

         'Insurance Analyst and Associate Director',

         'Fund and Asset Management Analyst and Associate Director',

         'US Public Finance Analyst and Associate Director',

         'Global Infrastructure Group Analyst and Associate Director') and  CURRICULUM_STATUS= 'ACQUIRED','Certified')

please help me. how  can i get same result  if  any  thing matches in the list

Thanks

Damodhar

[its_anandrjs]

I believe your expression worked as OR condition also or you can try with

if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

        'Corporates Analyst and Associate Director',

        'Covered Bonds Analyst and Associate Director',

        'International Public Finance Analyst and Associate Director',

        'Sovereigns Analyst and Associate Director',

         'Structured Finance Analyst and Associate Director',

         'Insurance Analyst and Associate Director',

         'Fund and Asset Management Analyst and Associate Director',

         'US Public Finance Analyst and Associate Director',

         'Global Infrastructure Group Analyst and Associate Director') OR  CURRICULUM_STATUS= 'ACQUIRED','Certified')

[Anonymous]

Hi

Match() returns an integer of the matching string, so you need to check it is > 0, as per below.

if( ( Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

        'Corporates Analyst and Associate Director',

        'Covered Bonds Analyst and Associate Director',

        'International Public Finance Analyst and Associate Director',

        'Sovereigns Analyst and Associate Director',

         'Structured Finance Analyst and Associate Director',

         'Insurance Analyst and Associate Director',

         'Fund and Asset Management Analyst and Associate Director',

         'US Public Finance Analyst and Associate Director',

         'Global Infrastructure Group Analyst and Associate Director') > 0 ) and  CURRICULUM_STATUS= 'ACQUIRED','Certified')

[PradeepReddy]

if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

        'Corporates Analyst and Associate Director',

        'Covered Bonds Analyst and Associate Director',

        'International Public Finance Analyst and Associate Director',

        'Sovereigns Analyst and Associate Director',

         'Structured Finance Analyst and Associate Director',

         'Insurance Analyst and Associate Director',

         'Fund and Asset Management Analyst and Associate Director',

         'US Public Finance Analyst and Associate Director',

         'Global Infrastructure Group Analyst and Associate Director') and  (CURRICULUM_STATUS= 'ACQUIRED' OR CURRICULUM_STATUS='Certified')

[alexandros17]

Try to use wildmatch instead of Match, do you use the formula in a expression?

[its_anandrjs]

Another one you try with

if( ( Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',

        'Corporates Analyst and Associate Director',

        'Covered Bonds Analyst and Associate Director',

        'International Public Finance Analyst and Associate Director',

        'Sovereigns Analyst and Associate Director',

         'Structured Finance Analyst and Associate Director',

         'Insurance Analyst and Associate Director',

         'Fund and Asset Management Analyst and Associate Director',

         'US Public Finance Analyst and Associate Director',

         'Global Infrastructure Group Analyst and Associate Director') OR CURRICULUM_STATUS='ACQUIRED') ,'Certified')