Assuming you mean that "safdgas6asdfaf8adfasdf0adfads0ada" would return 680 then how about:
rereplace(st, "[^[:digit:]]*([[:digit:]])[^[:digit:]]*([[:digit:]])[^[:digit:]]*([[:digit: ]]).*", "\1\2\3") Does that work?? ----- Original Message ----- From: "Adrian Cesana" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 6:10 AM Subject: pulling 3 numerics from an alphanumeric string > I need to pull the left most 3 numeric digits from an alphanumeric string, > anyone have a good method of doing this?. The string could also have other > character in it like "#$,' etc... > > I was thinking this possibly could be done with LEFT() and REREPLACE()... > > Thanks,Adrian > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
