Well after all that, it looks like it's not as standard as I first thought. Only half of the entries will have the spaces, dots, commas etc in the right places; the rest are all mixed up and will be a regex nightmare. Thanks though for your help.
Will >#TRIM(sText)# should do the trick > >Or <cfset newText = TRIM(sText)> > >E > >----- Original Message ----- >From: <[EMAIL PROTECTED]> > > >Hi, thanks for both your replies. Matthew, I've not tried yours yet >but will do later, esp as you're a kiwi :) > >CF Dude, yours nearly works - except there *will* always be text >after the country name. But we know there'll be a >space and 3 stops, i.e. " ..." So how can I tell it to "stop" when >grabbing the country name (i.e. exclude " ..." and >anything after that point. > >Thanks > >Will > >>This works. >> >> <cfset sText = "Green Acres USA"> >> <cfset sNewText = Replace(sText, " ", "|")> >> <cfset vText = ListToArray(sNewText , "|")> >> #ArrayLen(vText)#<br> >> #vText[1]#<br> >> #vText[2]#<br> >> >>----- Original Message ----- >>From: "Matthew Walker" <[EMAIL PROTECTED]> >> >> >>ListToArray(sText , " ") would make "&", "n", "b", "s", "p", and ";" >>all delimiters. >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
