Yep,
That's a problem. I had to do this once in the real world, a pain. Makes you think next you design a DB though. Regards Dale Fraser From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Russon Sent: Monday, 4 February 2008 5:12 PM To: [email protected] Subject: [cfaussie] Re: String Manipulation 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 <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 <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 -~----------~----~----~----~------~----~------~--~---
