2 Replies Latest reply: May 24, 2011 3:56 AM by Rajan Balamurugan RSS

    Splitting the column name

      Hello Guys,

       

           I had a gud support from u so far.Thanks for that.

       

           I ve an excel source file. the columns are like M.13-17 Where M stands for Male and 13-17 for the age group.

       

           Wat I need is, I want to seperate the columns into AgeGroup and Gender.

       

           I tried with FieldName method.Its working for the first column only. There are 20 columns. I want to do this for all in the source file.

       

           Help me to solve this problem.

       

           Thanks in advance.