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.