#lcase(left(trim(listlast(thecell)), 1))##lcase(trim(listfirst(thecell)))#
On Mon, Nov 16, 2009 at 10: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:328418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
