Hi Mike,
I opted to go with the ReplaceList() function and replace all the words I
needed removed with an empty space!
#ReplaceList("Yellow Gold Single Matte Eye Shadow", "Single, Eye, Shadow,
Matte, Superfrosted, Frosted, Trio, shadow, Quad", ",,,,,,,,,")#
would return "Yello Gold"
Thanks for the push in the right direction.
Al
-----Original Message-----
From: Michael Traher [mailto:[EMAIL PROTECTED]
Sent: Monday, September 26, 2005 10:59 AM
To: CF-Talk
Subject: Re: String Search!!!!
sorry should be replace(oldstring,"Similar","","ALL")
On 9/26/05, Michael Traher <[EMAIL PROTECTED]> wrote:
>
> Hi Al,
>
> You could use the replace function to replace the words you do not require
> with an empty string.
>
> <cfset newstring = replace(oldstring,"Similar","ALL")>
>
> you may need to drop this into a loop and repeat for all the words to be
> removed.
>
> can use trim(newstring) to remove any trailing spaces.
>
> MikeT
>
> On 9/26/05, Aldon <[EMAIL PROTECTED]> wrote:
> >
> > Ok to be a bit more specific I have a of titles that have one similarity
> > they contain similar words like "Similar Words Found, Or Words Found".
> > The
> > names are written out in the following format:
> >
> > John Doe Similar Words Found
> > Jane Similar Words Found
> > Alex Words Found
> >
> > I would like to search through the text for any of the words matching
> > "Similar" or "Words" or "Found" and return only the name for example:
> >
> > John Doe Similar Words Found = John Doe (the search would stop at
> > "Similar"
> > since it is the first word matching the criteria)
> > Jane Similar Words Found = Jane (the search would stop at "Similar"
> > since it
> > is the first word matching the criteria)
> > Alex Words Found = Alex (the search would stop at "Words" since it is
> > the
> > first word matching the criteria)
> >
> >
> > Thanks
> >
> > Al
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219412
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
