oops, Charlie is right about the trim(): <cfset str = "Smith, Jim"> <cfoutput>#lcase(left(trim(listlast(str)), 1) & listfirst(str))#</cfoutput>
Azadi Saryev On 17/11/2009 00:35, Azadi Saryev wrote: > <cfset str = "Smith, Jim"> > <cfoutput>#lcase(left(listlast(str), 1) & listfirst(str))#</cfoutput> > > it's also possible to do it in SQL, if that's what you meant, but syntax > will depend on your db... > > Azadi Saryev > > > > On 17/11/2009 00:18, Keith McGee wrote: > >> Is it possible to separate data from a single field separated by a comma? >> >> Here is the format of the cell: Smith, Jim >> >> I want to end with jsmith >> >> Thank >> Keith >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
