You want this data to format as text, not numeric. Excel will
automatically format what it thinks are numerics without any leading
zeros. Check the file in notepad or some other straight-up text
editor. When saving a csv file from Excel, make sure you format the
columns as text prior to saving (and always keep an original file in
excel format).
Cheers,
Kris
> I have a query returning employee, jobcode:
>
> <cfquery name="GetHR" datasource="MyHRDB">
> select employee, jobcode
> from hrdb
> </cfquery>
>
> The query returns:
>
> 023598 1332
> 028977 2908
> 032409 0180
> 037325 3350
> 042242 6220
> 048140 3121
> 051482 0430
> 056176 3110
> ......
>
> <cfset expandpath = "D:\HR\">
> <cfset HEADER= "employee,jobcode"
> <cffile action="Write" file="#expandpath("HRData.csv")#"
> output="#HEADER#" addnewline="Yes">
>
> <cfoutput query="GetHR">
> <cfset CONTENT="#employee#, #jobcode#>
>
> <cffile action="APPEND" file="#expandpath("HRData.csv")#"
> addnewline="Yes" output="#CONTENT#">
> </cfoutput>
>
> However, the .csv file shows the data wihout leading zero(s) like below:
>
> 23598 1332
> 28977 2908
> 32409 180
> 37325 3350
> 42242 6220
> 48140 3121
> 51482 430
> 56176 3110
>
> I tried NumberFormat with:
>
> <cfset CONTENT="#NumberFormat(employee, "000000")#,
> #NumberFormat(jobcode,"0000")#>
>
> but, the result still shows data without leading zero(s).
> How do you put leading zero(s) on the .csv file?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303129
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
