Treat it as a space-separated list - <cfset col1 = ListFirst( var, " " )> <Cfset col2 = ListLast( var, " " )>
HTH Alistair Davidson Senior Developer Rocom New Media www.rocomx.net "There is no spoon" -----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 14:08 To: CF-Talk Subject: Split Variable I have a variable that is passed such as Lonwood Leesburg. Sometimes Central Orlando. I need to know how to split it at the space then insert one half into one column of a db and the other half to another column of the db. Joshua Tipton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
