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

    Need to extract the values from a column


      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.