Man newbie was kickin today...you have an extranious " infront of dateformat.
Adam H
On Thu, 24 Feb 2005 11:55:37 -0400, Scot VanAlstine <[EMAIL PROTECTED]> wrote:
> I have a logfile with a date at the begining of each record.
> The record ends with a carriage return.
> I want to read the dates and delete from the file all records that are over
> 30 calendar days old.
> I have gotten stalled and need help. Any assistance will be appreciated.
>
> Here is an example of my log file:
>
> 09/30/2004 08:43:34 AM ale -- File: blah.txt upload complete.
> 09/30/2004 08:43:46 AM ale -- rm -rf '/train9/upload'
> 09/30/2004 08:43:48 AM ale -- File: upload delete complete.
> 10/07/2004 10:37:49 AM ale -- mkdir -m 775 '/train9/blah'
> 10/07/2004 10:37:51 AM ale -- Successfully made directory '/train9/blah'.
> 10/07/2004 10:39:32 AM ale -- Send File 'U:\projects
> 10/07/2004 10:39:38 AM ale -- File: cfdir_err.doc upload
>
> I am comparing dates but am getting an Invalid CFML construct found on the
> following line at column 58:
>
> 24 : <cfif (DateDiff("d",now(),"DateFormat(Content_array[1],"mm-dd-yyyy"")
> GTE 31)>
>
> Here is an example of all my documented code so far:
>
> <cffile action="Read" file="http://www.wirez.com/testserver/TRAIN09.log";
> variable="str_Content">
> <cfset bln_FirstLine = true>
>
> <!--- default var --->
>
> <cfset New_File = "">
>
> <!--- Loop through the lines--->
>
> <cfloop
> list="#str_Content#"
> delimiters="#chr(13)##chr(10)#"
> index="str_Line">
> <!--- Set line as an array--->
> <cfset Content_array = #ListtoArray(str_Line)#>
>
> <!--- Need to do something with the date - may need to set the date as -7 or
> something like that might want to use DateDiff()
> DateDiff("y: Day of year ", "DateFormat(Content_array[1],"mm-dd-yyyy")",
> "#DateFormat(Now()")
> DateFormat(Content_array[1],"mm-dd-yyyy") GT #DateFormat(Now() - 7,
> "mm-dd-yyyy"--->
>
> <cfif (DateDiff("d",now(),"DateFormat(Content_array[1],"mm-dd-yyyy"") GTE 31)>
>
> <!--- if the line is a keeper, drop it into a new var - may have to
> play with the set commmand, you want to append the line to the existing var,
> may need to use & signs for the set
> New_File & ArraytoList(Content_array) & chr(13) & chr(10) - or
> something like that --->
>
> <cfset New_File =
> "#New_File##ArraytoList(Content_array)##chr(13)##chr(10)#">
> </cfif>
> </cfloop>
>
> <!--- Write the file back - destination D:/vars/wirez... --->
> <!--- <cfset comparison = DateCompare(FORM.date1, FORM.date2,
> FORM.precision)>--->
>
> <cffile action="write" nameconflict="overwrite"
> destination="D:\Inetpub\Var\wirez\www.wirez.com\website\testserver\"
> output="#New_File#">
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:644
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
