8 Replies Latest reply: Sep 2, 2014 2:27 AM by Ashfaq Mohammed RSS

    Urgent help

    Timba Roocha

      Dear All

       

      I need suggestions over below field, where i have to split EMPIDDATE field on the basis of EMP ID & DATE

       

      EMPIDDATE

      1[01$022&014]

      2[11$042&014]

      3[14$022&014]

      4[04$012&014]

      5[05$092&014]

       

      Needed O/P:

       

      EMPID    DATE

      1          01 -02-2014

      2          11-04-2014

       

      and So on..

       

      Thanks in Advance

      Timba