I am downloading a csv and then parsing through it, then inserting into a SQL 2005 DB. Here is the problem. ...
A number of fields that are passed are strings representing dates.
E.G. 20080324
( which I read as 2008/03/24)
Sometimes they are there sometimes they are not.
When I perform a DateFormat on them to set them in my VAR, this is what I am getting back for the same data:
01/20/56878
Now I may be missing something but those are not even the same numbers.
Here is a sample of my code:
Expand|Select|Wrap|Line Numbers
- <CFIF FileExists("#csvTSSavePath#\#cvsTSFilename#.CSV")>
- <cffile action="read" file="#csvTSSavePath#\#cvsTSFilename#.CSV" variable="csvFile">
- <cfset csvFile = Replace(csvFile, chr(34), "", "all")>
- <!--- Convert the lines to an array using the carriage return/line feed characters as delimiters --->
- <cfset FileLines = listtoarray(ListFix(csvFile),"#chr(13)##chr(10)#")>
- <!--- Loop through the array of lines Use the number from="2" to eliminate the first row of data--->
- <cfloop from="2" to="#arrayLen(FileLines)#" index="i">
- <cfset AUCTDATE = "#listgetat(FileLines[i],11)#">
- <cfset DEFLTDAT = "#listgetat(FileLines[i],10)#">
- <cfset PUBDATE = "#listgetat(FileLines[i],126)#">
- <cfset RECDATE = "#listgetat(FileLines[i],125)#">
- <cfset LOAN_DATE = "#listgetat(FileLines[i],3)#">
- <cfset DATE_SOLD = "#listgetat(FileLines[i],72)#">
- <CFIF AUCTDATE EQ "NULL"><cfset AUCTDATE = "NULL"><CFELSE><cfset AUCTDATE = "#DateFormat(listgetat(FileLines[i],11), "mm/dd/yyyy")#"></CFIF>
- <CFIF DEFLTDAT EQ "NULL"><cfset DEFLTDAT = "NULL"><CFELSE><cfset DEFLTDAT = "#DateFormat(listgetat(FileLines[i],10), "mm/dd/yyyy")#"></CFIF>
- <!--- <CFIF PUBDATE EQ "NULL"><cfset PUBDATE = "NULL"><CFELSE><cfset PUBDATE = "#DateFormat(listgetat(FileLines[i],126), "mm/dd/yyyy")#"></CFIF> --->
- <CFIF RECDATE EQ "NULL"><cfset RECDATE = "NULL"><CFELSE><cfset RECDATE = "#DateFormat(listgetat(FileLines[i],125), "mm/dd/yyyy")#"></CFIF>
- <CFIF LOAN_DATE EQ "NULL"><cfset LOAN_DATE = "NULL"><CFELSE><cfset LOAN_DATE = "#DateFormat(listgetat(FileLines[i],3), "mm/dd/yyyy")#"></CFIF>
- <CFIF DATE_SOLD EQ "NULL"><cfset DATE_SOLD = "NULL"><CFELSE><cfset DATE_SOLD = "#DateFormat(listgetat(FileLines[i],72), "mm/dd/yyyy")#"></CFIF>
- <cfoutput>
- #AUCTDATE#<BR />
- #DEFLTDAT#<BR />
- #PUBDATE#<BR />
- #AUCTDATE#<BR />
- #RECDATE#<BR />
- #LOAN_DATE#<BR />
- #DATE_SOLD#<BR />
- </cfoutput>
Any help would be much apreciated. Thanks in advance.