If I'm reading this correctly, you've got sText and you want to get sPart1 and sPart2 where your delimiter will always be
If you will always have that same delimiter, you can split sText into an array using ListToArray(list [, delimiter ]) EX : <cfset sText = "Green Acres USA"> <cfset vStuff = ListToArray(sText , " ")> Then you've got yourself an array you can use. <cfset sPart1 = vStuff[1]> <cfset sPart1 = vStuff[2]> (Forgive me if my cf array syntax is wrong, I'm deep in ASP hell right now) Hope this helps! Eric PS to everyone : I consider RegEx to be like a super power. However, I also find great joy in simple suggestions like this that do cause my brain to melt when writing RegEx. ----- Original Message ----- From: "W Luke" <[EMAIL PROTECTED]> >I'm inserting into a DB a block of text such will always have ", " appended >after it. >What I'd like to do is take out Green Apples (or whatever it might be), and the country name (again, wherever it is), and dump them into a var. What function should I be looking at? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4