4 Replies Latest reply: Jun 5, 2017 7:23 PM by Rob Wunderlich RSS

    Put unstructured text in columns

    Neha Mishra


      I have data in the following format in one of the columns in my table


      Area : CXX
      Application : Happy
      Spot : xyz42i
      Component : xyz42i
      Summary xyz42i - The value of Avg_Response_Time for /D:/Docs/ABDCD/WASparty2 is 1.54 seconds



      I need to put all this information in different columns to eavluate the data. The Summary bit also needs to be sliced to give groups Like Average response time, time in queues, address of component etc. The length and format of summary are variable and it is a large file. Any suggestions on how to approach this problem?

      Many thanks!