On the action-page:
<cfif left(FORM.string, 4) IS "the ">
<cfset FORM.string = RemoveChars(FORM.string,5,len(FORM.string))>
<cfelseif left(FORM.string, 2) IS "a ">
<cfset FORM.string = RemoveChars(FORM.string,3,len(FORM.string))>
</cfif>
* Holger Lockertsen, Solutions Developer, Horisont Information Systems AS
* Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway
* 23 31 03 04 / 91 83 20 51
* [EMAIL PROTECTED] http://www.horisont.no/
> -----Original Message-----
> From: Howell, Katie [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 10, 2000 4:23 PM
> To: [EMAIL PROTECTED]
> Subject: Stripping characters from the beginning of a string...
>
>
> Thanks for all the help on the textarea problem...now see if you
> can help me
> with this:
> My client has a database of books. The book titles are stored as
> "Big Book
> of Lists, The" or "Big Book of Lists, A" with the The or the A at the end
> of the string. So, if a person enters "The Big...." or "A Big...." it
> doesn't find the book. Do I need to have him change the entries in the
> database? or is there a way to strip off the The or A when it
> occurs at the
> beginning of a string?
>
> Katie
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.