This works and is tested:
<cfscript>
yourString = "set primary_assign_id = 123";
</cfscript>
<cfoutput>
#REReplaceNoCase(yourString,"set primary_assign_id =
[[:digit:]]{3}","","ALL")#
</cfoutput>
Good luck.
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
-----Original Message-----
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 01, 2005 2:43 PM
To: CF-Talk
Subject: Re: Replacing variable text in a string
Hey Scott,
This is not working for me. I corrected the typo from Palace to place
but
it is not working. Any Ideas?
Thanks
Mike
----- Original Message -----
From: "Scott Stroz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Tuesday, February 01, 2005 2:04 PM
Subject: Re: Replacing variable text in a string
> RERepalce(yourString,"set primary_assign_id = [:digit:]{3}","","all")
>
> Should work, but has not been tested.
>
>
> On Tue, 1 Feb 2005 12:57:51 -0500, Mickael <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I would like replace a portion of a string that is a SQL statement
generated by my users via an interface that I have created. I have
never
used Regular Expressions but from what I have heard about this task
sounds
like a candidate.
> >
> > I would like to update a SQL statement that is generated by my users
there is a portion of the string that says "set primary_assign_id = 123"
that I would like to remove the problem is that I am not sure what the
number is but I know that it always three numbers.
> >
> > How can I do this?
> >
> > Regards,
> >
> > Mike
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:192655
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
