Re: LEFT Command question

>>Here is the format of the cell: Smith, Jim >>I want to end with jsmith How about this: #LCase (left(trim(listLast(cell)), 1) & listFirst(cell))# provided that cell is always a list of at least two names. ~| Want to reach

Re: LEFT Command question

Thank You, works perfect ~| 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:328423

Re: LEFT Command question

oops, Charlie is right about the trim(): #lcase(left(trim(listlast(str)), 1) & listfirst(str))# Azadi Saryev On 17/11/2009 00:35, Azadi Saryev wrote: > > #lcase(left(listlast(str), 1) & listfirst(str))# > > it's also possible to do it in SQL, if that's what you meant, but syntax > will depe

Re: LEFT Command question

#lcase(left(listlast(str), 1) & listfirst(str))# 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

Re: LEFT Command question

#lcase(left(trim(listlast(thecell)), 1))##lcase(trim(listfirst(thecell)))# On Mon, Nov 16, 2009 at 10:18 AM, 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 > K

Re: LEFT Command question

theName = "Smith, Jim" #listFirst(theName) & left(listLast(theName), 1)# 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 wrote: > > Is it possible to separate data from a single

LEFT Command question

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? Le