Uew, One of these removes all zeros from the string, the other removes all zeros at the end of a string:
<cfset myString = "aa0bbb0ccc000"> <cfdump var="#myString#"><br> <cfset removeTrailingZeros = ReReplace(myString,"0+$","","all")> <cfset removeAllZeros = Replace(myString,"0","","all")> <cfoutput>#removeTrailingZeros#<br>#removeAllZeros#</cfoutput> > -----Original Message----- > From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 11, 2005 6:25 AM > To: CF-Talk > Subject: cutting: aabbcc0000 > > Hi list I > have a value in a db-field like > "aabbcc0000" > and I always want > to cut the leading nulls > on the right to get: "aabbcc", but only the > four nulls, how can I do this ? > There must be a regular expression > for this, but I can't remember. > Uwe [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:220683 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54