3 Replies Latest reply: Jul 13, 2012 6:54 AM by Jonathan Dienst RSS

    Split date from one column into 3 separate columns

      Hello,

       

      I am trying to split data from one column into 3 separate columns. My data is being loaded from an Oracle database. Following is my script example:

       

      SQL SELECT "column" FROM LOG.TABLE

       

      The data in the column are of the following format:

       

      abc/123/textdescription

       

      How can I separate this into 3 different columns in QV?

      Please help.

      Thank you in advance.