Hey.
I have output a CSV file using Coldfusion but the file has a blank line at he end.
I'm not including a carriage return and I can't find a way to stop it.
Anyone out there got an idea?
This is the code I'm using:
CODE
<cfset variables.out = "" />
<cfset variables.path = getDirectoryFromPath(getCurrentTemplatePath()) & 'Extracts\' />
<cfset CSVFileName="MyFife_#application.URLDecrypt(school)#_Myriad_#DateFormat(Now(),'ddmmyyyy')##LSTimeFormat(Now(),'HHMMSS')#.csv">
<cfset variables.path = variables.path & CSVFileName />
<cfset variables.out = variables.out & '"#myriadDetails[Count][1]#","#myriadDetails[Count][2]#","#myriadDetails[Count][3]#","#myriadDetails[Count][4]#","#myriadDetails[Count][5]#","#myriadDetails[Count][6]#","#myriadDetails[Count][7]#","#myriadDetails[Count][8]#","#myriadDetails[Count][9]#","#myriadDetails[Count][10]#","#myriadDetails[Count][11]#","#myriadDetails[Count][12]#"'>
Thanks for looking folks.
9 Jul, 2008 - 06:02 AM
|