5 Replies Latest reply: Sep 27, 2013 2:36 AM by Tresesco B RSS

    how to use wildcard in if

    ben lim

      I have this field call Load_Berth and Discharge_Berth, which is

      A01

      A02

      A03

      B01

      B02

      B03

       

      First letter A and B means place such as A stands for Australia and B stands for Brazil. Basicallly this field will tell you tht this particular person was loaded to a bus at this berth and discharge at this berth

       

      I would want to find passengers that load and berth at the same country

       

      So my code is if(Load_Berth = {'A*'} and Discharge)Berth = {'A*'},'Intra-Country')

       

      However it seems that it is not working,

       

      is my wildcard usage wrong

       

      thanks