4 Replies Latest reply: Aug 26, 2013 4:23 AM by Hoek RSS

    Need to extract the values from a column

    Thej


      Hi Experts,

       

      I need to extract the values and store it in seperate column. Can some one help me out to write the function to extract the data from column.

      I am having column DOC_NO from which i have to extract dob, gender, nationality

       

      Doc_no:   9005070288080

       

      DOB : 900507- yyddmm

       

      Gender : 0288- if less than 5000 then female else male

       

      Nationality: 080-  0 means India 1 means forgiener.

       

      Thanks

      Thej