4 Replies Latest reply: Oct 4, 2016 6:01 AM by Deepak Sharma RSS

    Splitting/Cleaning Field

    Deepak Sharma
      CountryCount
      Canada (North America);UK (incl IoM) (Europe)1
      Bahrain (Middle East);Egypt (Middle East);Qatar (Middle East);United Arab Emirates (Middle East)1

       

      I have the above table and Country information Is coming saperated by ';'

       

      Please assist me in getting below out put

       

      CountryCount
      Canada1
      UK1
      Bahrain1
      Egypt1
      Qatar1
      United Arab Emirates1