[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Need to change columns of data to something more useful.

I've tried a few times,  but i cant get the time, date and data to align up

,, Load Forecast - PSP_Integrated - Last Update on Oct. 07 at 09:12 Central Prevailing Time
Hour,Yesterday Actual,10/07/11,10/08/11,10/09/11,10/10/11,10/11/11,10/12/11,10/13/11
 1, 4458, 4472, 4437, 4054, 3973, 4177, 4193, 4165
 2, 4238, 4295, 4231, 3888, 3851, 3998, 4014, 3991
 3, 4100, 4108, 4065, 3761, 3768, 3868, 3880, 3860
 4, 4001, 4124, 3990, 3713, 3777, 3855, 3863, 3844
 5, 4108, 4224, 3985, 3699, 3885, 3937, 3944, 3926
 6, 4409, 4550, 4082, 3746, 4241, 4273, 4267, 4250
 7, 5072, 5217, 4319, 3877, 4890, 4902, 4883, 4881
 8, 5434, 5611, 4498, 3989, 5273, 5288, 5283, 5278 
 9, 5537, 5756, 4725, 4174, 5421, 5418, 5432, 5411
10, 5737, 5944, 4949, 4353, 5549, 5505, 5533, 5522
11, 5887, 6116, 5099, 4487, 5706, 5622, 5655, 5632
12, 6056, 6229, 5214, 4629, 5817, 5709, 5751, 5711
13, 6183, 6327, 5275, 4718, 5903, 5773, 5814, 5751
14, 6251, 6403, 5273, 4744, 5963, 5813, 5847, 5762
15, 6277, 6439, 5282, 4772, 5962, 5823, 5853, 5751
16, 6230, 6410, 5275, 4800, 5922, 5796, 5814, 5688
17, 6170, 6364, 5299, 4877, 5868, 5767, 5774, 5631
18, 6031, 6208, 5288, 4961, 5787, 5708, 5703, 5541
19, 5901, 6017, 5256, 5029, 5713, 5647, 5609, 5453
20, 6089, 6074, 5380, 5170, 5793, 5756, 5711, 5589
21, 5972, 5912, 5232, 5063, 5647, 5629, 5581, 5460
22, 5634, 5543, 4922, 4783, 5280, 5297, 5261, 5140
23, 5193, 5116, 4609, 4467, 4817, 4851, 4824, 4740
24, 4774, 4709, 4304, 4143, 4412, 4447, 4422, 4356
,, Temp Forecast - PSP_Integrated - Last Update on Oct. 07 at 09:12 Central Prevailing Time
Hour,Yesterday Actual,10/07/11,10/08/11,10/09/11,10/10/11,10/11/11,10/12/11,10/13/11
 1,   64,   66,   71,   62,   57,   61,   60,   58
 2,   63,   69,   70,   62,   56,   59,   59,   57
 3,   62,   69,   69,   60,   55,   56,   58,   56
 4,   59,   70,   68,   60,   55,   54,   56,   55
 5,   58,   67,   68,   59,   55,   53,   55,   54
 6,   57,   64,   67,   58,   55,   52,   55,   54
 7,   56,   64,   67,   58,   55,   52,   55,   54
 8,   57,   65,   67,   58,   57,   53,   57,   55 
 9,   60,   68,   67,   58,   59,   55,   59,   57
10,   64,   70,   68,   59,   61,   58,   61,   60
11,   69,   73,   70,   61,   65,   61,   64,   62
12,   76,   76,   73,   64,   68,   64,   66,   63
13,   79,   79,   74,   65,   72,   67,   68,   64
14,   81,   81,   74,   67,   72,   68,   70,   65
15,   82,   82,   76,   67,   72,   69,   70,   65
16,   82,   82,   76,   67,   72,   69,   70,   64
17,   82,   83,   74,   67,   69,   69,   69,   63
18,   79,   80,   73,   66,   69,   68,   68,   61
19,   75,   78,   71,   65,   67,   67,   66,   59
20,   73,   76,   70,   64,   64,   65,   64,   57
21,   71,   75,   69,   62,   62,   64,   62,   55
22,   71,   74,   68,   61,   60,   64,   60,   52
23,   69,   72,   66,   61,   59,   63,   58,   51
24,   68,   71,   65,   60,   56,   61,   58,   51

Open in new window


I want to convert it to:


Load Forecast - PSP_Integrated,10/07/11,1:00,4458,
Load Forecast - PSP_Integrated,10/07/11,1:00,4238,

etc

then the 2nd Set


Temp Forecast - PSP_Integrated,10/07/11 1:00,64,
Temp Forecast - PSP_Integrated,10/07/11 2:00,63,

etc

Its beyond me, anybody see a way to do it?
0
JCS_Unlimited
Asked:
JCS_Unlimited
  • 6
  • 4
1 Solution
 
Bill PrewCommented:
I don't understand what you are looking for, this looks like a CSV file, which are typically not "formatted" to align columns, etc?

Can you share a before and after look at a sample set of data, that might help.

~bp
0
 
JCS_UnlimitedAuthor Commented:
Hey Billprew.

If you look above I showed the before in a code window and a example of output below it. Here is what I want it to look like.

I want to convert it to:


Load Forecast - PSP_Integrated,10/07/11,1:00,4458,
Load Forecast - PSP_Integrated,10/07/11,1:00,4238,

etc

then the 2nd Set


Temp Forecast - PSP_Integrated,10/07/11 1:00,64,
Temp Forecast - PSP_Integrated,10/07/11 2:00,63,

etc
0
 
Bill PrewCommented:
Okay, trying to understand enough to propose an approach.

For the first set, you indicated:

Load Forecast - PSP_Integrated,10/07/11,1:00,4458,
Load Forecast - PSP_Integrated,10/07/11,1:00,4238,

(1) Where did the "1:00" on each line come from, the neader seemed to indicate 9:12?

(2) The first line of data was:

 1, 4458, 4472, 4437, 4054, 3973, 4177, 4193, 4165

are the numbers after the 4458 ignored, or will you also want tose output, with the correct day from the header?

For the second set, you indicated:

Temp Forecast - PSP_Integrated,10/07/11 1:00,64,
Temp Forecast - PSP_Integrated,10/07/11 2:00,63,

(1) Where did the "1:00" and "2:00" come from?

~bp
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
JCS_UnlimitedAuthor Commented:
Your right BP,

I just relized that I was not specific enough

If you look in the code above you will see the first line is un needed. It specifies that "Load Forecast - PSP_Integrated" which I want each line to begin with.

The next line is the date specified, you can see it is columns. Below that is rows with times.

What I need is:

Load Forecast - PSP_Integrated ((firstdate)) ((firsttime)) number

Is that better?

Sorry
0
 
Bill PrewCommented:
Okay, see if this gets close to what you want.  Save as a VBS and run it passing two command line parms, the input file and the output file.

' Define needed constants
Const ForReading = 1
Const ForWriting = 2
Const TriStateUseDefault = -2
 
' Get input file name from command line parm
If (WScript.Arguments.Count > 0) Then
  strInFile = WScript.Arguments(0)
Else
  WScript.Echo "No input filename specified."
  WScript.Quit
End If

' Get input file name from command line parm
If (WScript.Arguments.Count > 1) Then
  strOutFile = WScript.Arguments(1)
Else
  WScript.Echo "No output filename specified."
  WScript.Quit
End If

' Read file into an array
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile(strInFile, ForReading, False, TriStateUseDefault)
arrLines = Split(objFile.ReadAll, VbCrLf)
objFile.Close

' Open output file
Set objFile = objFSO.OpenTextFile(strOutFile, ForWriting, True)

' Loop through all lines of the file
For Each strLine in arrLines
   If strLine <> "" Then
      strBegin = Left(strLine, 3)
      Select Case strBegin
         Case ",, "
            strTitle = Trim(Mid(strLine, 4, Instr(Instr(1, strLine, "-", 1) + 1, strLine, "-", 1) -4))
         Case "Hou"
            arrDate = Split(strLine, ",")
            strDate = arrDate(2)
         Case " 1,", " 2,", " 3,", " 4,", " 5,", " 6,", " 7,", " 8,", " 9,", "10,", "11,", "12,", "13,", "14,", "15,", "16,", "17,", "18,", "19,", "20,", "21,", "22,", "23,", "24,"
            arrValue = Split(strLine, ",")
            strTime = Trim(arrValue(0)) & ":00"
            strData = Trim(arrValue(1))
            objFile.WriteLine strTitle & "," & strDate & "," & strTime & "," & strData & ","
      End Select
   End If
Next
    objFile.WriteLine()

' Close output file
objFile.Close

Open in new window

~bp
0
 
JCS_UnlimitedAuthor Commented:
BP,

That worked for the first column,

If you see the days are broken up in the coulums I was talking about:


Hour,  Yesterday Actual,   10/07/11,  10/08/11,  10/09/11,  10/10/11,  10/11/11,  10/12/11,  10/13/11

Open in new window


Id love to skip yesterdays actual and start with the first date and pull its column of data like you are showing me, then next column/date etc



0
 
Bill PrewCommented:
Can you please provide a full and complete output file that you want generated from your test input file.

~bp
0
 
Bill PrewCommented:
Okay, rereading your reply, and "guessing" a little bit, see if this is closer to what you want.  It skips yesterday, and processes all the dates.  The output is grouped in time order though, not date order, since we are processing one line (a single hour for multiple dates) at a time. If that doesn't work then we will have to save all 24 hours of data first as we read them, and then dump them at the end.

' Define needed constants
Const ForReading = 1
Const ForWriting = 2
Const TriStateUseDefault = -2
 
' Get input file name from command line parm
If (WScript.Arguments.Count > 0) Then
  strInFile = WScript.Arguments(0)
Else
  WScript.Echo "No input filename specified."
  WScript.Quit
End If

' Get input file name from command line parm
If (WScript.Arguments.Count > 1) Then
  strOutFile = WScript.Arguments(1)
Else
  WScript.Echo "No output filename specified."
  WScript.Quit
End If

' Read file into an array
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile(strInFile, ForReading, False, TriStateUseDefault)
arrLines = Split(objFile.ReadAll, VbCrLf)
objFile.Close

' Open output file
Set objFile = objFSO.OpenTextFile(strOutFile, ForWriting, True)

' Loop through all lines of the file
For Each strLine in arrLines
   If strLine <> "" Then
      arrFields = Split(strLine, ",")
      Select Case Trim(arrFields(0))
         Case ""
            strTitle = Left(Trim(arrFields(2)), Instr(Instr(1, strLine, "-", 1) + 1, strLine, "-", 1) -5)
         Case "Hour"
            arrDate = Split(strLine, ",")
         Case "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24"
            strTime = Trim(arrFields(0)) & ":00"
            For i = 2 to UBound(arrDate)
               objFile.WriteLine strTitle & "," & Trim(arrDate(i)) & "," & strTime & "," & Trim(arrFields(i)) & ","
            Next
      End Select
   End If
Next
    objFile.WriteLine()

' Close output file
objFile.Close

Open in new window

I got this output from this version from your test data:
Load Forecast - PSP_Integrated,10/07/11,1:00,4472,
Load Forecast - PSP_Integrated,10/08/11,1:00,4437,
Load Forecast - PSP_Integrated,10/09/11,1:00,4054,
Load Forecast - PSP_Integrated,10/10/11,1:00,3973,
Load Forecast - PSP_Integrated,10/11/11,1:00,4177,
Load Forecast - PSP_Integrated,10/12/11,1:00,4193,
Load Forecast - PSP_Integrated,10/13/11,1:00,4165,
Load Forecast - PSP_Integrated,10/07/11,2:00,4295,
Load Forecast - PSP_Integrated,10/08/11,2:00,4231,
Load Forecast - PSP_Integrated,10/09/11,2:00,3888,
Load Forecast - PSP_Integrated,10/10/11,2:00,3851,
Load Forecast - PSP_Integrated,10/11/11,2:00,3998,
Load Forecast - PSP_Integrated,10/12/11,2:00,4014,
Load Forecast - PSP_Integrated,10/13/11,2:00,3991,
Load Forecast - PSP_Integrated,10/07/11,3:00,4108,
Load Forecast - PSP_Integrated,10/08/11,3:00,4065,
Load Forecast - PSP_Integrated,10/09/11,3:00,3761,
Load Forecast - PSP_Integrated,10/10/11,3:00,3768,
Load Forecast - PSP_Integrated,10/11/11,3:00,3868,
Load Forecast - PSP_Integrated,10/12/11,3:00,3880,
Load Forecast - PSP_Integrated,10/13/11,3:00,3860,
Load Forecast - PSP_Integrated,10/07/11,4:00,4124,
Load Forecast - PSP_Integrated,10/08/11,4:00,3990,
Load Forecast - PSP_Integrated,10/09/11,4:00,3713,
Load Forecast - PSP_Integrated,10/10/11,4:00,3777,
Load Forecast - PSP_Integrated,10/11/11,4:00,3855,
Load Forecast - PSP_Integrated,10/12/11,4:00,3863,
Load Forecast - PSP_Integrated,10/13/11,4:00,3844,
Load Forecast - PSP_Integrated,10/07/11,5:00,4224,
Load Forecast - PSP_Integrated,10/08/11,5:00,3985,
Load Forecast - PSP_Integrated,10/09/11,5:00,3699,
Load Forecast - PSP_Integrated,10/10/11,5:00,3885,
Load Forecast - PSP_Integrated,10/11/11,5:00,3937,
Load Forecast - PSP_Integrated,10/12/11,5:00,3944,
Load Forecast - PSP_Integrated,10/13/11,5:00,3926,
Load Forecast - PSP_Integrated,10/07/11,6:00,4550,
Load Forecast - PSP_Integrated,10/08/11,6:00,4082,
Load Forecast - PSP_Integrated,10/09/11,6:00,3746,
Load Forecast - PSP_Integrated,10/10/11,6:00,4241,
Load Forecast - PSP_Integrated,10/11/11,6:00,4273,
Load Forecast - PSP_Integrated,10/12/11,6:00,4267,
Load Forecast - PSP_Integrated,10/13/11,6:00,4250,
Load Forecast - PSP_Integrated,10/07/11,7:00,5217,
Load Forecast - PSP_Integrated,10/08/11,7:00,4319,
Load Forecast - PSP_Integrated,10/09/11,7:00,3877,
Load Forecast - PSP_Integrated,10/10/11,7:00,4890,
Load Forecast - PSP_Integrated,10/11/11,7:00,4902,
Load Forecast - PSP_Integrated,10/12/11,7:00,4883,
Load Forecast - PSP_Integrated,10/13/11,7:00,4881,
Load Forecast - PSP_Integrated,10/07/11,8:00,5611,
Load Forecast - PSP_Integrated,10/08/11,8:00,4498,
Load Forecast - PSP_Integrated,10/09/11,8:00,3989,
Load Forecast - PSP_Integrated,10/10/11,8:00,5273,
Load Forecast - PSP_Integrated,10/11/11,8:00,5288,
Load Forecast - PSP_Integrated,10/12/11,8:00,5283,
Load Forecast - PSP_Integrated,10/13/11,8:00,5278,
Load Forecast - PSP_Integrated,10/07/11,9:00,5756,
Load Forecast - PSP_Integrated,10/08/11,9:00,4725,
Load Forecast - PSP_Integrated,10/09/11,9:00,4174,
Load Forecast - PSP_Integrated,10/10/11,9:00,5421,
Load Forecast - PSP_Integrated,10/11/11,9:00,5418,
Load Forecast - PSP_Integrated,10/12/11,9:00,5432,
Load Forecast - PSP_Integrated,10/13/11,9:00,5411,
Load Forecast - PSP_Integrated,10/07/11,10:00,5944,
Load Forecast - PSP_Integrated,10/08/11,10:00,4949,
Load Forecast - PSP_Integrated,10/09/11,10:00,4353,
Load Forecast - PSP_Integrated,10/10/11,10:00,5549,
Load Forecast - PSP_Integrated,10/11/11,10:00,5505,
Load Forecast - PSP_Integrated,10/12/11,10:00,5533,
Load Forecast - PSP_Integrated,10/13/11,10:00,5522,
Load Forecast - PSP_Integrated,10/07/11,11:00,6116,
Load Forecast - PSP_Integrated,10/08/11,11:00,5099,
Load Forecast - PSP_Integrated,10/09/11,11:00,4487,
Load Forecast - PSP_Integrated,10/10/11,11:00,5706,
Load Forecast - PSP_Integrated,10/11/11,11:00,5622,
Load Forecast - PSP_Integrated,10/12/11,11:00,5655,
Load Forecast - PSP_Integrated,10/13/11,11:00,5632,
Load Forecast - PSP_Integrated,10/07/11,12:00,6229,
Load Forecast - PSP_Integrated,10/08/11,12:00,5214,
Load Forecast - PSP_Integrated,10/09/11,12:00,4629,
Load Forecast - PSP_Integrated,10/10/11,12:00,5817,
Load Forecast - PSP_Integrated,10/11/11,12:00,5709,
Load Forecast - PSP_Integrated,10/12/11,12:00,5751,
Load Forecast - PSP_Integrated,10/13/11,12:00,5711,
Load Forecast - PSP_Integrated,10/07/11,13:00,6327,
Load Forecast - PSP_Integrated,10/08/11,13:00,5275,
Load Forecast - PSP_Integrated,10/09/11,13:00,4718,
Load Forecast - PSP_Integrated,10/10/11,13:00,5903,
Load Forecast - PSP_Integrated,10/11/11,13:00,5773,
Load Forecast - PSP_Integrated,10/12/11,13:00,5814,
Load Forecast - PSP_Integrated,10/13/11,13:00,5751,
Load Forecast - PSP_Integrated,10/07/11,14:00,6403,
Load Forecast - PSP_Integrated,10/08/11,14:00,5273,
Load Forecast - PSP_Integrated,10/09/11,14:00,4744,
Load Forecast - PSP_Integrated,10/10/11,14:00,5963,
Load Forecast - PSP_Integrated,10/11/11,14:00,5813,
Load Forecast - PSP_Integrated,10/12/11,14:00,5847,
Load Forecast - PSP_Integrated,10/13/11,14:00,5762,
Load Forecast - PSP_Integrated,10/07/11,15:00,6439,
Load Forecast - PSP_Integrated,10/08/11,15:00,5282,
Load Forecast - PSP_Integrated,10/09/11,15:00,4772,
Load Forecast - PSP_Integrated,10/10/11,15:00,5962,
Load Forecast - PSP_Integrated,10/11/11,15:00,5823,
Load Forecast - PSP_Integrated,10/12/11,15:00,5853,
Load Forecast - PSP_Integrated,10/13/11,15:00,5751,
Load Forecast - PSP_Integrated,10/07/11,16:00,6410,
Load Forecast - PSP_Integrated,10/08/11,16:00,5275,
Load Forecast - PSP_Integrated,10/09/11,16:00,4800,
Load Forecast - PSP_Integrated,10/10/11,16:00,5922,
Load Forecast - PSP_Integrated,10/11/11,16:00,5796,
Load Forecast - PSP_Integrated,10/12/11,16:00,5814,
Load Forecast - PSP_Integrated,10/13/11,16:00,5688,
Load Forecast - PSP_Integrated,10/07/11,17:00,6364,
Load Forecast - PSP_Integrated,10/08/11,17:00,5299,
Load Forecast - PSP_Integrated,10/09/11,17:00,4877,
Load Forecast - PSP_Integrated,10/10/11,17:00,5868,
Load Forecast - PSP_Integrated,10/11/11,17:00,5767,
Load Forecast - PSP_Integrated,10/12/11,17:00,5774,
Load Forecast - PSP_Integrated,10/13/11,17:00,5631,
Load Forecast - PSP_Integrated,10/07/11,18:00,6208,
Load Forecast - PSP_Integrated,10/08/11,18:00,5288,
Load Forecast - PSP_Integrated,10/09/11,18:00,4961,
Load Forecast - PSP_Integrated,10/10/11,18:00,5787,
Load Forecast - PSP_Integrated,10/11/11,18:00,5708,
Load Forecast - PSP_Integrated,10/12/11,18:00,5703,
Load Forecast - PSP_Integrated,10/13/11,18:00,5541,
Load Forecast - PSP_Integrated,10/07/11,19:00,6017,
Load Forecast - PSP_Integrated,10/08/11,19:00,5256,
Load Forecast - PSP_Integrated,10/09/11,19:00,5029,
Load Forecast - PSP_Integrated,10/10/11,19:00,5713,
Load Forecast - PSP_Integrated,10/11/11,19:00,5647,
Load Forecast - PSP_Integrated,10/12/11,19:00,5609,
Load Forecast - PSP_Integrated,10/13/11,19:00,5453,
Load Forecast - PSP_Integrated,10/07/11,20:00,6074,
Load Forecast - PSP_Integrated,10/08/11,20:00,5380,
Load Forecast - PSP_Integrated,10/09/11,20:00,5170,
Load Forecast - PSP_Integrated,10/10/11,20:00,5793,
Load Forecast - PSP_Integrated,10/11/11,20:00,5756,
Load Forecast - PSP_Integrated,10/12/11,20:00,5711,
Load Forecast - PSP_Integrated,10/13/11,20:00,5589,
Load Forecast - PSP_Integrated,10/07/11,21:00,5912,
Load Forecast - PSP_Integrated,10/08/11,21:00,5232,
Load Forecast - PSP_Integrated,10/09/11,21:00,5063,
Load Forecast - PSP_Integrated,10/10/11,21:00,5647,
Load Forecast - PSP_Integrated,10/11/11,21:00,5629,
Load Forecast - PSP_Integrated,10/12/11,21:00,5581,
Load Forecast - PSP_Integrated,10/13/11,21:00,5460,
Load Forecast - PSP_Integrated,10/07/11,22:00,5543,
Load Forecast - PSP_Integrated,10/08/11,22:00,4922,
Load Forecast - PSP_Integrated,10/09/11,22:00,4783,
Load Forecast - PSP_Integrated,10/10/11,22:00,5280,
Load Forecast - PSP_Integrated,10/11/11,22:00,5297,
Load Forecast - PSP_Integrated,10/12/11,22:00,5261,
Load Forecast - PSP_Integrated,10/13/11,22:00,5140,
Load Forecast - PSP_Integrated,10/07/11,23:00,5116,
Load Forecast - PSP_Integrated,10/08/11,23:00,4609,
Load Forecast - PSP_Integrated,10/09/11,23:00,4467,
Load Forecast - PSP_Integrated,10/10/11,23:00,4817,
Load Forecast - PSP_Integrated,10/11/11,23:00,4851,
Load Forecast - PSP_Integrated,10/12/11,23:00,4824,
Load Forecast - PSP_Integrated,10/13/11,23:00,4740,
Load Forecast - PSP_Integrated,10/07/11,24:00,4709,
Load Forecast - PSP_Integrated,10/08/11,24:00,4304,
Load Forecast - PSP_Integrated,10/09/11,24:00,4143,
Load Forecast - PSP_Integrated,10/10/11,24:00,4412,
Load Forecast - PSP_Integrated,10/11/11,24:00,4447,
Load Forecast - PSP_Integrated,10/12/11,24:00,4422,
Load Forecast - PSP_Integrated,10/13/11,24:00,4356,
Temp Forecast - PSP_Integrated,10/07/11,1:00,66,
Temp Forecast - PSP_Integrated,10/08/11,1:00,71,
Temp Forecast - PSP_Integrated,10/09/11,1:00,62,
Temp Forecast - PSP_Integrated,10/10/11,1:00,57,
Temp Forecast - PSP_Integrated,10/11/11,1:00,61,
Temp Forecast - PSP_Integrated,10/12/11,1:00,60,
Temp Forecast - PSP_Integrated,10/13/11,1:00,58,
Temp Forecast - PSP_Integrated,10/07/11,2:00,69,
Temp Forecast - PSP_Integrated,10/08/11,2:00,70,
Temp Forecast - PSP_Integrated,10/09/11,2:00,62,
Temp Forecast - PSP_Integrated,10/10/11,2:00,56,
Temp Forecast - PSP_Integrated,10/11/11,2:00,59,
Temp Forecast - PSP_Integrated,10/12/11,2:00,59,
Temp Forecast - PSP_Integrated,10/13/11,2:00,57,
Temp Forecast - PSP_Integrated,10/07/11,3:00,69,
Temp Forecast - PSP_Integrated,10/08/11,3:00,69,
Temp Forecast - PSP_Integrated,10/09/11,3:00,60,
Temp Forecast - PSP_Integrated,10/10/11,3:00,55,
Temp Forecast - PSP_Integrated,10/11/11,3:00,56,
Temp Forecast - PSP_Integrated,10/12/11,3:00,58,
Temp Forecast - PSP_Integrated,10/13/11,3:00,56,
Temp Forecast - PSP_Integrated,10/07/11,4:00,70,
Temp Forecast - PSP_Integrated,10/08/11,4:00,68,
Temp Forecast - PSP_Integrated,10/09/11,4:00,60,
Temp Forecast - PSP_Integrated,10/10/11,4:00,55,
Temp Forecast - PSP_Integrated,10/11/11,4:00,54,
Temp Forecast - PSP_Integrated,10/12/11,4:00,56,
Temp Forecast - PSP_Integrated,10/13/11,4:00,55,
Temp Forecast - PSP_Integrated,10/07/11,5:00,67,
Temp Forecast - PSP_Integrated,10/08/11,5:00,68,
Temp Forecast - PSP_Integrated,10/09/11,5:00,59,
Temp Forecast - PSP_Integrated,10/10/11,5:00,55,
Temp Forecast - PSP_Integrated,10/11/11,5:00,53,
Temp Forecast - PSP_Integrated,10/12/11,5:00,55,
Temp Forecast - PSP_Integrated,10/13/11,5:00,54,
Temp Forecast - PSP_Integrated,10/07/11,6:00,64,
Temp Forecast - PSP_Integrated,10/08/11,6:00,67,
Temp Forecast - PSP_Integrated,10/09/11,6:00,58,
Temp Forecast - PSP_Integrated,10/10/11,6:00,55,
Temp Forecast - PSP_Integrated,10/11/11,6:00,52,
Temp Forecast - PSP_Integrated,10/12/11,6:00,55,
Temp Forecast - PSP_Integrated,10/13/11,6:00,54,
Temp Forecast - PSP_Integrated,10/07/11,7:00,64,
Temp Forecast - PSP_Integrated,10/08/11,7:00,67,
Temp Forecast - PSP_Integrated,10/09/11,7:00,58,
Temp Forecast - PSP_Integrated,10/10/11,7:00,55,
Temp Forecast - PSP_Integrated,10/11/11,7:00,52,
Temp Forecast - PSP_Integrated,10/12/11,7:00,55,
Temp Forecast - PSP_Integrated,10/13/11,7:00,54,
Temp Forecast - PSP_Integrated,10/07/11,8:00,65,
Temp Forecast - PSP_Integrated,10/08/11,8:00,67,
Temp Forecast - PSP_Integrated,10/09/11,8:00,58,
Temp Forecast - PSP_Integrated,10/10/11,8:00,57,
Temp Forecast - PSP_Integrated,10/11/11,8:00,53,
Temp Forecast - PSP_Integrated,10/12/11,8:00,57,
Temp Forecast - PSP_Integrated,10/13/11,8:00,55,
Temp Forecast - PSP_Integrated,10/07/11,9:00,68,
Temp Forecast - PSP_Integrated,10/08/11,9:00,67,
Temp Forecast - PSP_Integrated,10/09/11,9:00,58,
Temp Forecast - PSP_Integrated,10/10/11,9:00,59,
Temp Forecast - PSP_Integrated,10/11/11,9:00,55,
Temp Forecast - PSP_Integrated,10/12/11,9:00,59,
Temp Forecast - PSP_Integrated,10/13/11,9:00,57,
Temp Forecast - PSP_Integrated,10/07/11,10:00,70,
Temp Forecast - PSP_Integrated,10/08/11,10:00,68,
Temp Forecast - PSP_Integrated,10/09/11,10:00,59,
Temp Forecast - PSP_Integrated,10/10/11,10:00,61,
Temp Forecast - PSP_Integrated,10/11/11,10:00,58,
Temp Forecast - PSP_Integrated,10/12/11,10:00,61,
Temp Forecast - PSP_Integrated,10/13/11,10:00,60,
Temp Forecast - PSP_Integrated,10/07/11,11:00,73,
Temp Forecast - PSP_Integrated,10/08/11,11:00,70,
Temp Forecast - PSP_Integrated,10/09/11,11:00,61,
Temp Forecast - PSP_Integrated,10/10/11,11:00,65,
Temp Forecast - PSP_Integrated,10/11/11,11:00,61,
Temp Forecast - PSP_Integrated,10/12/11,11:00,64,
Temp Forecast - PSP_Integrated,10/13/11,11:00,62,
Temp Forecast - PSP_Integrated,10/07/11,12:00,76,
Temp Forecast - PSP_Integrated,10/08/11,12:00,73,
Temp Forecast - PSP_Integrated,10/09/11,12:00,64,
Temp Forecast - PSP_Integrated,10/10/11,12:00,68,
Temp Forecast - PSP_Integrated,10/11/11,12:00,64,
Temp Forecast - PSP_Integrated,10/12/11,12:00,66,
Temp Forecast - PSP_Integrated,10/13/11,12:00,63,
Temp Forecast - PSP_Integrated,10/07/11,13:00,79,
Temp Forecast - PSP_Integrated,10/08/11,13:00,74,
Temp Forecast - PSP_Integrated,10/09/11,13:00,65,
Temp Forecast - PSP_Integrated,10/10/11,13:00,72,
Temp Forecast - PSP_Integrated,10/11/11,13:00,67,
Temp Forecast - PSP_Integrated,10/12/11,13:00,68,
Temp Forecast - PSP_Integrated,10/13/11,13:00,64,
Temp Forecast - PSP_Integrated,10/07/11,14:00,81,
Temp Forecast - PSP_Integrated,10/08/11,14:00,74,
Temp Forecast - PSP_Integrated,10/09/11,14:00,67,
Temp Forecast - PSP_Integrated,10/10/11,14:00,72,
Temp Forecast - PSP_Integrated,10/11/11,14:00,68,
Temp Forecast - PSP_Integrated,10/12/11,14:00,70,
Temp Forecast - PSP_Integrated,10/13/11,14:00,65,
Temp Forecast - PSP_Integrated,10/07/11,15:00,82,
Temp Forecast - PSP_Integrated,10/08/11,15:00,76,
Temp Forecast - PSP_Integrated,10/09/11,15:00,67,
Temp Forecast - PSP_Integrated,10/10/11,15:00,72,
Temp Forecast - PSP_Integrated,10/11/11,15:00,69,
Temp Forecast - PSP_Integrated,10/12/11,15:00,70,
Temp Forecast - PSP_Integrated,10/13/11,15:00,65,
Temp Forecast - PSP_Integrated,10/07/11,16:00,82,
Temp Forecast - PSP_Integrated,10/08/11,16:00,76,
Temp Forecast - PSP_Integrated,10/09/11,16:00,67,
Temp Forecast - PSP_Integrated,10/10/11,16:00,72,
Temp Forecast - PSP_Integrated,10/11/11,16:00,69,
Temp Forecast - PSP_Integrated,10/12/11,16:00,70,
Temp Forecast - PSP_Integrated,10/13/11,16:00,64,
Temp Forecast - PSP_Integrated,10/07/11,17:00,83,
Temp Forecast - PSP_Integrated,10/08/11,17:00,74,
Temp Forecast - PSP_Integrated,10/09/11,17:00,67,
Temp Forecast - PSP_Integrated,10/10/11,17:00,69,
Temp Forecast - PSP_Integrated,10/11/11,17:00,69,
Temp Forecast - PSP_Integrated,10/12/11,17:00,69,
Temp Forecast - PSP_Integrated,10/13/11,17:00,63,
Temp Forecast - PSP_Integrated,10/07/11,18:00,80,
Temp Forecast - PSP_Integrated,10/08/11,18:00,73,
Temp Forecast - PSP_Integrated,10/09/11,18:00,66,
Temp Forecast - PSP_Integrated,10/10/11,18:00,69,
Temp Forecast - PSP_Integrated,10/11/11,18:00,68,
Temp Forecast - PSP_Integrated,10/12/11,18:00,68,
Temp Forecast - PSP_Integrated,10/13/11,18:00,61,
Temp Forecast - PSP_Integrated,10/07/11,19:00,78,
Temp Forecast - PSP_Integrated,10/08/11,19:00,71,
Temp Forecast - PSP_Integrated,10/09/11,19:00,65,
Temp Forecast - PSP_Integrated,10/10/11,19:00,67,
Temp Forecast - PSP_Integrated,10/11/11,19:00,67,
Temp Forecast - PSP_Integrated,10/12/11,19:00,66,
Temp Forecast - PSP_Integrated,10/13/11,19:00,59,
Temp Forecast - PSP_Integrated,10/07/11,20:00,76,
Temp Forecast - PSP_Integrated,10/08/11,20:00,70,
Temp Forecast - PSP_Integrated,10/09/11,20:00,64,
Temp Forecast - PSP_Integrated,10/10/11,20:00,64,
Temp Forecast - PSP_Integrated,10/11/11,20:00,65,
Temp Forecast - PSP_Integrated,10/12/11,20:00,64,
Temp Forecast - PSP_Integrated,10/13/11,20:00,57,
Temp Forecast - PSP_Integrated,10/07/11,21:00,75,
Temp Forecast - PSP_Integrated,10/08/11,21:00,69,
Temp Forecast - PSP_Integrated,10/09/11,21:00,62,
Temp Forecast - PSP_Integrated,10/10/11,21:00,62,
Temp Forecast - PSP_Integrated,10/11/11,21:00,64,
Temp Forecast - PSP_Integrated,10/12/11,21:00,62,
Temp Forecast - PSP_Integrated,10/13/11,21:00,55,
Temp Forecast - PSP_Integrated,10/07/11,22:00,74,
Temp Forecast - PSP_Integrated,10/08/11,22:00,68,
Temp Forecast - PSP_Integrated,10/09/11,22:00,61,
Temp Forecast - PSP_Integrated,10/10/11,22:00,60,
Temp Forecast - PSP_Integrated,10/11/11,22:00,64,
Temp Forecast - PSP_Integrated,10/12/11,22:00,60,
Temp Forecast - PSP_Integrated,10/13/11,22:00,52,
Temp Forecast - PSP_Integrated,10/07/11,23:00,72,
Temp Forecast - PSP_Integrated,10/08/11,23:00,66,
Temp Forecast - PSP_Integrated,10/09/11,23:00,61,
Temp Forecast - PSP_Integrated,10/10/11,23:00,59,
Temp Forecast - PSP_Integrated,10/11/11,23:00,63,
Temp Forecast - PSP_Integrated,10/12/11,23:00,58,
Temp Forecast - PSP_Integrated,10/13/11,23:00,51,
Temp Forecast - PSP_Integrated,10/07/11,24:00,71,
Temp Forecast - PSP_Integrated,10/08/11,24:00,65,
Temp Forecast - PSP_Integrated,10/09/11,24:00,60,
Temp Forecast - PSP_Integrated,10/10/11,24:00,56,
Temp Forecast - PSP_Integrated,10/11/11,24:00,61,
Temp Forecast - PSP_Integrated,10/12/11,24:00,58,
Temp Forecast - PSP_Integrated,10/13/11,24:00,51,

Open in new window

~bp
0
 
JCS_UnlimitedAuthor Commented:
BP,

That worked perfectly. I was able to change it a little bit and work with a few other files as well.

Thanks a lot.
0
 
Bill PrewCommented:
Great, glad we got to something useful.

~bp
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now