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

CGI/Perl Guide | Learning Center | Forums | Advertise | Login

Site Search: in


	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

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

Post #1 of 3 (4213 views)

Mapping values with Column header and row header	Can't Post

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

Post #2 of 3 (4206 views)

Re: [vinodkaushik] Mapping values with Column header and row header [In reply to]	Can't Post

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

vinodkaushik
Novice

Jul 28, 2009, 10:04 PM

Post #3 of 3 (4200 views)

Re: [KevinR] Mapping values with Column header and row header [In reply to]	Can't Post

Hi,

I am done with this. Thanks for your response.

Regards,

Search for (options)

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives