Splitting the column name

[#1]

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.

[#2 · Accepted solution]

Please find the attached File.

Hope this helps u.

[#3]

hi jain,

     Thank u for that solution. it works.