<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:328419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
