>>How would I go about doing this? Hi, This is really a job for CF_REextract. See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm Then try it with your sample on line: http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm - Enter [^(]*\(mid:[[:space:]] in field RE1 - enter \),? in RE2 - enter your sample John Smith (mid: 1000), Peter Pan (mid: 87), Harry Harrison (mid: 173), in the sample text area, - click the Test button,... et voilĂ !
You get a query with the names in column string1 and your numbers in string2. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4