well let me clarify a bit here. My hash is backwards, data file example is below. Database has columns for Date,Login,SearchLoad,etc, Date column is a date/time login real searchload real when I read file into hash I get timevalue->columnname, I want the reverse which would be columname->timevalue. In order to fix my data file, I want to add a label Date to the first value which is a timestamp for each record throughout the file, then I want to read the file into a hash so I can input it into the database which is currently empty and only contains the columns I want to use for the table. The sql for the table creation is in the bottom of this comment. 
05/12/2006 12:21:10 AM,Login,19.748396,SearchLoad,13.459355,SearchCoun
+t,64:0.660950,SearchResults,12.988677,SearchSave,6.138828,SearchDelet
+e,1.682419,SearchDetails,10.114545,TaxLoad,3.995745,TaxResults,567:5.
+287602,TaxDetails,3.975717,ClientAdd,2.643801,CMALoad,2.603744,CMASav
+e,14.350635,CMADelete,1.021467,ClientDelete,0.731053,Logout,2.733931,
+05/12/2006 12:54:07 AM,Login,18.015907,SearchLoad,13.259065,SearchCou
+nt,64:0.620893,SearchResults,12.187526,SearchSave,5.327662,SearchDele
+te,1.111600,SearchDetails,9.914256,TaxLoad,3.755399,TaxResults,567:5.
+047257,TaxDetails,4.055832,ClientAdd,2.583715,CMALoad,2.834077,CMASav
+e,14.350636,CMADelete,0.690993,ClientDelete,0.610879,Logout,2.743947,
+05/12/2006 01:21:15 AM,

[download]
database stuff.. 
USE [performancetesting]
GO
/****** Object:  Table [dbo].[AllResults]    Script Date: 03/20/2009 1
+3:35:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AllResults](
    [Date] [datetime] NOT NULL,
    [Login] [real] NULL,
    [SearchLoad] [real] NULL,
    [SearchCount] [real] NULL,
    [SearchResults] [real] NULL,
    [SearchSave] [real] NULL,
    [SearchDelete] [real] NULL,
    [SearchDetails] [real] NULL,
    [ClientAdd] [real] NULL,
    [CMALoad] [real] NULL,
    [CMASave] [real] NULL,
    [CMADelete] [real] NULL,
    [ClientDelete] [real] NULL,
    [Logout] [real] NULL,
    [SiteCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NUL
+L
) ON [PRIMARY]

[download]

In reply to Re^4: insert label into file by grashoper
in thread insert label into file by grashoper

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.