Just throw a list function around it. The list function will take care of the extra commas.
#listChangeDelims(score, ",", ",")# This basically replaces all commas with commas, but has the side effect of removing extra commas. If you want to do it within the loop, you can use a CFIF block .... <cfif query.currentRow lt query.recordCount>,</cfif> .... This snippet will check the position of the query loop. If you are on the last record, it will not add the comma. The CFIF may be a tad faster than the list function, however, it does have to execute for each iteration of the loop. The list functions, themselves, have been reported to be low in performance. Personally, I have never seen any difference. I would just use whatever makes the most sense to you. M!ke -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:43 PM To: CF-Talk Subject: removing trailing comma in CSV row I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): <cfquery .> select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location </cfquery> <cfloop from="1" to="#get_result.recordcount#" index="i" step="1"> <cfoutput query="get_result" group="spdinput_id"> #spdinput_id#, <cfoutput>#score#,</cfoutput> <p> </cfoutput> </cfloop> Any ideas appreciated. Rick. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223818 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
