That's cool, I didn't know regex enough to know the 0+$ means trailing 0s. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED]
-----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 9:55 AM To: CF-Talk Subject: RE: cutting: aabbcc0000 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:220724 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