5 Replies Latest reply: Jan 12, 2015 9:53 AM by Marco Wedel RSS

    Sub-string

    Rakesh Paul

      Hi All,

       

      I am trying to extract the text's before the open braces. How can I do that. Here I am pasting my data points, please help me out how I can do that.

                             

      GUJRAT
      MUMBAI (2 to 2.5 Kg)
      NASIK (2 to 2.5 Kg)
      PUNE (2 to 2.5 Kg)
      PUNJAB (1.8 to 2 Kg)
      PUNJAB (1.4 to 1.6 Kg)
      PUNJAB (1 Kg)
      SKYLARK HR (2 to 2.3 Kg)
      SKYLARK HR (1.6 to 1.7 Kg)
      SKYLARK HR (1.2 to 1.3 Kg)
      RAIPUR (1.8 to 2.5 kg)
      RAIPUR (1.1 to 1.3 kg)

       

      Regards,

      Rakesh Paul