cutting: aabbcc0000
Hi list I have a value in a db-field like aabbcc 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 ~| 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:220641 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
RE: cutting: aabbcc0000
From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Hi list I have a value in a db-field like aabbcc 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 Left(string, count) so... Left(yourField,6) ~| 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:220642 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
RE: cutting: aabbcc0000
You mean trailing zeros? Would they always be trailing? And would there always be 4? -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: 11 October 2005 13:25 To: CF-Talk Subject: cutting: aabbcc Hi list I have a value in a db-field like aabbcc 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 ~| 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:220643 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
Re[2]: cutting: aabbcc0000
Hello Michael, Tuesday, October 11, 2005, 2:33:09 PM, you wrote: From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Hi list I have a value in a db-field like aabbcc 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 MTT Left(string, count) MTT so... MTT Left(yourField,6) MTT ~| 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:220646 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
RE: cutting: aabbcc0000
str = aabbcc #reverse(right(reverse(str),len(str)-(ReFind(0[^0],reverse(str)# This will remove all nulls from the right. Perhaps there's a more elegant way, but I don't know it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 8:25 AM To: CF-Talk Subject: cutting: aabbcc Hi list I have a value in a db-field like aabbcc 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220657 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
RE: cutting: aabbcc0000
Also, one caveat - if the string itself has a length of 0, it will throw an error. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 9:52 AM To: CF-Talk Subject: RE: cutting: aabbcc str = aabbcc #reverse(right(reverse(str),len(str)-(ReFind(0[^0],reverse(str)# This will remove all nulls from the right. Perhaps there's a more elegant way, but I don't know it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 8:25 AM To: CF-Talk Subject: cutting: aabbcc Hi list I have a value in a db-field like aabbcc 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 ~| 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:220662 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
RE: cutting: aabbcc0000
Won't Rtrim() work? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 10:00 AM To: CF-Talk Subject: RE: cutting: aabbcc Also, one caveat - if the string itself has a length of 0, it will throw an error. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 9:52 AM To: CF-Talk Subject: RE: cutting: aabbcc str = aabbcc #reverse(right(reverse(str),len(str)-(ReFind(0[^0],reverse(str)# This will remove all nulls from the right. Perhaps there's a more elegant way, but I don't know it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 8:25 AM To: CF-Talk Subject: cutting: aabbcc Hi list I have a value in a db-field like aabbcc 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 ~| 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:220682 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
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: aabbcc Hi list I have a value in a db-field like aabbcc 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
RE: cutting: aabbcc0000
Rtrim only applies to spaces. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 10:39 AM To: CF-Talk Subject: RE: cutting: aabbcc Won't Rtrim() work? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 10:00 AM To: CF-Talk Subject: RE: cutting: aabbcc Also, one caveat - if the string itself has a length of 0, it will throw an error. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 9:52 AM To: CF-Talk Subject: RE: cutting: aabbcc str = aabbcc #reverse(right(reverse(str),len(str)-(ReFind(0[^0],reverse(str)# This will remove all nulls from the right. Perhaps there's a more elegant way, but I don't know it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 8:25 AM To: CF-Talk Subject: cutting: aabbcc Hi list I have a value in a db-field like aabbcc 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 ~| 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:220697 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
RE: cutting: aabbcc0000
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: aabbcc 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: aabbcc Hi list I have a value in a db-field like aabbcc 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
RE: cutting: aabbcc0000
Yeah, the '+' means look for 1 or more, and the '$' means match at the end of the string. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 11, 2005 10:53 AM To: CF-Talk Subject: RE: cutting: aabbcc 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: aabbcc 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 [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:220728 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