theName = "Smith, Jim" <cfoutput>#listFirst(theName) & left(listLast(theName), 1)#</cfoutput>
you could wrap that into a UDF. And might (?) need a trim() in there to deal with the space between the list elements. On Mon, Nov 16, 2009 at 8:18 AM, Keith McGee <[email protected]>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:328417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
