3 Replies Latest reply on Aug 13, 2018 5:34 PM by Shanker Raman

    Splitting text without a delimiter

    Shanker Raman

      Hi,

       

      I have data in 2 fields  which contains values such as

       

       

        

      SupplierProducts & Services
      XAcids and Solvents
      Oilfield Production Chemicals
      Manufacture of Chemicals
      YCrane Rental / Supply / Erection
      Heavy Transport
      Trucking Services, General
      ZDownhole Services
      Machining
      Well Casing Services
      Well Services with Rigs

       

      I want to split the data as so:

       

           

      SupplierProduct 1Product 2Product 3Product 4
      XAcids and Solvents

      Oilfield Production ChemicalsManufacture of Chemicals
      YCrane Rental / Supply / Erection
      Heavy TransportTrucking Services, General
      ZDownhole ServicesMachiningWell Casing ServicesWell Services with Rigs

       

       

      There is no delimiter such as , tab or pipe. The only logic which I could find was that a small letter was immediately followed by a capital letter. e.g.the last character of  Downhole Services s is a small letter and is immediately followed by a capital letter M in Machining. Is there anyway to split based on this ?

       

      Thank you for your assistance.