> Hello, > I'm outputing a query and have a part number value. The > part number > value is syntacically the same, (SSS444BBB) The first > part of the part > number is three letters, then three numbers. I want to > extract the > three numbers from this part number. Any suggestions?
> Thanks <cfset myvar = REReplace(myquery.partnumber,"...([0-9]+).*","\1")> Fortunately, this should work the same on cf5 and cfmx in spite of the change in regex engines. For more information about Regex at large check out the houseoffusion cf-regex list. :) s. isaac dealey 972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi team macromedia volunteer http://www.macromedia.com/go/team certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
