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
www.SAMARIS.NET
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]
<javascript:top.opencompose('[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]
<javascript:top.opencompose('[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]
<javascript:top.opencompose('[EMAIL PROTECTED]','','','')>
> W: 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
-~----------~----~----~----~------~----~------~--~---
