Home: Need a Custom or Prewritten Perl Program?: I need a program that...:
Mapping values with Column header and row header



vinodkaushik
Novice

Jul 28, 2009, 12:43 AM


Views: 4058
Mapping values with Column header and row header

Hi,

I have some files with below data.

sample File 1:
sitename1,2009-07-19,"A1",11975,17.23
sitename1,2009-07-19,"A2",11,0.02
sitename1,2009-07-20,"A1",2000,17.23
sitename1,2009-07-20,"A2",538,0.02

I want to map the values in column 4 with column 2 and 3 as shown below.

Output required.
*Site,Type,2009-07-19,2009-07-20*
sitename1,"A1",11975,2000
sitename1,"A2",11,538

I will really appreciate any quick help.

Regards,
VKS


KevinR
Veteran


Jul 28, 2009, 10:51 AM


Views: 4051
Re: [vinodkaushik] Mapping values with Column header and row header

please delete this duplicate thread. This question has been resolved.
-------------------------------------------------


vinodkaushik
Novice

Jul 28, 2009, 10:04 PM


Views: 4045
Re: [KevinR] Mapping values with Column header and row header

Hi,

I am done with this. Thanks for your response.

Regards,