Did you try using ReFind reg expressions or MID function to find a substring?
Thanks. -Sandeep Singh Vohra >>> Seth Kovanic <[EMAIL PROTECTED]> 7/31/2007 5:17 PM >>> Hi All, I have the following in a field in a DB 12_0,13_1,14_4,34_5 etc. I want to be able to search that field and store for example on the first set of numbers both the 12 and the 0 in two unique variables. I know I need to setup a loop to accomplish this, but I am uncertain how to setup a search within the string. I basically need to filter out the two numbers and setup them up in two unique variables to then insert them into another db. Any ideas ? Thanks ! p.s. I may have created a thread similar to this, and if I did I apologize. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2968 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
