RE: is there a trim function to get rid of a space between names

2002-09-11 Thread Everett, Al
Errr...What's wrong with Replace(LastName, ,,ALL) -Original Message- From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 4:27 PM Is there a way to get CF to delete the space in between a name. ie... Mac Donald to just MacDonald?

Re: is there a trim function to get rid of a space between names

2002-09-11 Thread charlie griefer
Rebecca Joy Sherman writes: cfoutput#replace(Mac Donald, , , all)#/cfoutput will work... there's probably a regular expression to search for a space...i just don't know reg exps :( charlie Hi all, Is there a way to get CF to delete the space in between a name. ie... Mac Donald

Re: is there a trim function to get rid of a space between names

2002-09-11 Thread Howie Hamlin
replace( ,,ALL) HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** inFusion Mail Server (iMS) - The Award-winning,

RE: is there a trim function to get rid of a space between names

2002-09-11 Thread Mosh Teitelbaum
Err... CFSET Name = Mac Donald CFSET NewName = Replace(Name, , , ALL) This will remove all of the spaces in the string. Is that what you were looking for? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/

RE: is there a trim function to get rid of a space between names

2002-09-11 Thread Nick Varner
Try ReplaceNoCase(Mac Donald, , , ALL) -Original Message- From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 2:27 PM To: CF-Talk Subject:is there a trim function to get rid of a space between names Hi all, Is there a way to get

Re: is there a trim function to get rid of a space between names

2002-09-11 Thread Jerry Johnson
Maybe by getting rid of all spaces? cfset string=replace(string, ,,ALL) Jerry Johnson [EMAIL PROTECTED] 09/11/02 04:26PM Hi all, Is there a way to get CF to delete the space in between a name. ie... Mac Donald to just MacDonald? Thanks, Joy

Re: is there a trim function to get rid of a space between names

2002-09-11 Thread jon hall
cfset stringNoSpace = replace(stringWithSpace, ' ', '', 'ALL') -- jon mailto:[EMAIL PROTECTED] Wednesday, September 11, 2002, 4:26:31 PM, you wrote: RJS Hi all, RJS Is there a way to get CF to delete the space in between a name. ie... Mac RJS Donald to just MacDonald? RJS Thanks, RJS

Re: is there a trim function to get rid of a space between names

2002-09-11 Thread S . Isaac Dealey
Well, if you had a full name, i.e. Allan Mac Donald and you wanted to eliminate the 2nd space, you could use cfset newname = REReplace(trim(oldname),([[:alpha:]]+?) +?([[:alpha:]]*?) ([[:alpha:]]+?)$,\1 \2\3) Of course, this assumes that there aren't any numbers in the person's name... if you

Re: is there a trim function to get rid of a space between names

2002-09-11 Thread Dick Applebaum
I think you really need to ask for first name and last name separately, or just accept the full name the way they enter it. You run into problems in certain cultures where the surname is used first. Also, I remember one lady named [sp]: sue man joe How do handle that? HTH Dick

RE: is there a trim function to get rid of a space between names

2002-09-11 Thread Everett, Al
To add to Dick's point, some people's surnames actually are two words. One case in point is CF-Talk regular Jochem van Dieten. I wouldn't want anyone arbitrarily changing my name like that. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September