Re: Reveral of a field
trim(listLast(field)) & " " & trim(listFirst(field)) At 12:47 PM 4/12/2001, you wrote: >Hi, >I have a field with Smith, John as the contents. > >I want to display John Smith... > >I'm think I get the total length(a), then the charlength of the comma(b). > >Take contents b + 1 and subtract that from a equals (c) >Then display the difference of c to a (d) >and then output c after d to the total of the field > >Any other ideas? > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Reveral of a field
Cool. Thanks. - Original Message - From: "Christopher Olive, CIO" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 4:55 AM Subject: RE: Reveral of a field > you could use the listfirst and listlast functions. assuming that your > names are alwas Last, First: > > > > > #listlast(thename)# #listfirst(thename)# > > > make sense? > > chris olive, cio > cresco technologies > [EMAIL PROTECTED] > http://www.crescotech.com > > > > -Original Message- > From: Brian Thornton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 12, 2001 7:48 AM > To: CF-Talk > Subject: Reveral of a field > > > Hi, > I have a field with Smith, John as the contents. > > I want to display John Smith... > > I'm think I get the total length(a), then the charlength of the comma(b). > > Take contents b + 1 and subtract that from a equals (c) > Then display the difference of c to a (d) > and then output c after d to the total of the field > > Any other ideas? > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reveral of a field
you could use the listfirst and listlast functions. assuming that your names are alwas Last, First: #listlast(thename)# #listfirst(thename)# make sense? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 7:48 AM To: CF-Talk Subject: Reveral of a field Hi, I have a field with Smith, John as the contents. I want to display John Smith... I'm think I get the total length(a), then the charlength of the comma(b). Take contents b + 1 and subtract that from a equals (c) Then display the difference of c to a (d) and then output c after d to the total of the field Any other ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists