Now... how about dealing with 2 first names? Ann Maree Smith Marc Anthony Muniz
Now how about: Mary Jane Mac Guinness? :D On Feb 4, 2008 3:57 PM, Dale Fraser <[EMAIL PROTECTED]> wrote: > Steve is correct assuming they have a two + word name. > > > > But just in case > > > > <cfset myName = 'Dale Fraser' /> > > <cfset firstName = listFirst(myName, ' ') /> > > <cfif listLen(myName) gt 1> > > <cfset lastName = listLast(myName, ' ') /> > > <cfelse> > > <cfset lastName = '' /> > > </cfif> > > > > Otherwise if their name is 'Madonna' > > > > You would end up with Madonna Madonna > > > > > > Regards > > Dale Fraser > > > > http://learncf.com > > > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Steve Onnis > *Sent:* Monday, 4 February 2008 4:43 PM > *To:* [email protected] > *Subject:* [cfaussie] Re: String Manipulation > > > > #listFirst(members_name, " ")# gets first name > > #listRest(members_name, " ")# gets everything after the first name incase > they have a middle name > > #listLast(members_name, " ")# gets the last value in the string > > > > ------------------------------ > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Claude Raiola > *Sent:* Monday, 4 February 2008 4:40 PM > *To:* [email protected] > *Subject:* [cfaussie] String Manipulation > > Hi, > > Yes its a very basic question however i have forgotten the correct syntax > > I have a field called members_name containing the first and last name of > each member eg "tom smith" i am wanting to separate the first and last name > into 2 columns, first_name, last_name > > I cannot recall the correct syntax in order to separate the string into 2 > parts > > Regards > > Claude Raiola > B.Econ (Acc), B.Hot.Mngt. > > Websites: > www.AustralianAccommodation.com <http://www.australianaccommodation.com/> > www.SAMARIS.NET <http://www.samaris.net/> > www.WebSiteSolutions.com.au <http://www.websitesolutions.com.au/> > Mobile: 0414 228 948 > > *On Mon Feb 4 12:56 , 'Barry Beattie' sent:* > > > yeah, and not winning the prizes. we've heard the sob stories. > > Imagine! people using the lure of prizes to encourage them to a CFUG > meeting ... what is the world coming to? > > > > > On Feb 4, 2008 2:50 PM, Toby Tremayne <[EMAIL PROTECTED]> wrote: > > I'm in your CFUG, eating your pizza. > > > > > > > > On 04/02/2008, at 12:16 , Mark Mandel wrote: > > Sorry.. who are you again? ;o) > > > > Mark > > > > On Feb 4, 2008 11:53 AM, Toby Tremayne <[EMAIL PROTECTED]> wrote: > > > > > > Yup I'll be there - will be speaking too. > > > > > > > > > Toby > > > > > > > > > > > > > > > On 02/02/2008, at 20:07 , MrBuzzy wrote: > > > > > > > > > > > > > > > Hi folks... I'm in the midst of organising a trip to the UK in June. > > > I'll be attending scotch on the rocks in Edinburgh and was wondering > > > if any other (cf)Aussies will be going? > > > Cheers. > > > > > > > > > > > > > > > > > > > > > > > > ----------------------------------- > > > > > > > > > Life is poetry, write it in your own words > > > > > > > > > ----------------------------------- > > > > > > > > > Toby Tremayne > > > Director > > > Code Poet and Zen Master of the Heavy Sleep > > > Lyricist Software > > > 0416 048 090 > > > ICQ: 13107913 > > > > > > > > > > > > > > > > > > > > > > > -- > > E: [EMAIL PROTECTED] > > W: > > www.compoundtheory.com<http://parse.pl/?redirect=http://www.compoundtheory.com> > > > > > > > > > > ----------------------------------- > > > > Life is poetry, write it in your own words > > > > ----------------------------------- > > > > Toby Tremayne > > Director > > Code Poet and Zen Master of the Heavy Sleep > > Lyricist Software > > 0416 048 090 > > ICQ: 13107913 > > > > > > > > > > > ) > > > <BR > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
