Splitting the column name

Tue, 24 May 2011 07:01:08 GMT

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.

Re: Splitting the column name

Tue, 24 May 2011 07:12:52 GMT

Please find the attached File.

Hope this helps u.

Tue, 24 May 2011 07:56:27 GMT

hi jain,

Thank u for that solution. it works.