Thanks Tom and Ben. That got me in the right direction. My actual regEx is
session.cps.dbStruct.CPSDB([\s\S]{0,10})INSERT. This is finding what I want it
to find, all queries in my site that have "session.cps.dbStruct.CPSDB" as the
data source and is an insert query. Yippie-yi-eee.
Now, I realize I have a problem, of sort. How can I change
"session.cps.dbStruct.CPSDB" to "session.cps.dbStruct.CPS_ODBCDB"? Is there a
way to do this with the regex function of the find and replace in DW, or am I
doomed to doing it manually in all instances I have found.
The latter is not too bad, only 23 instances and at least I can open them by
with the results window of the search, but you know it is just so much more
satisfying to do it programmatically. Even when it takes 5 times longer to
figure out how then it would probably take doing it by hand.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
...-----Original Message-----
...From: Tom Muck [mailto:[EMAIL PROTECTED]
...Sent: Tuesday, January 11, 2005 11:27 AM
...To: RegEx
...Subject: Re: Any character, any character at all.
...
...> What is the proper way to say I will accept any kind of character,
...letter,
...digit, white space, special or anything else? I'm trying to create this
...basic idea of a regex.
...(aSpecificString)(anyPosibleCharacter)(aSecondSpecificString)
...>
...> Does that make sense, I guess a fairly real world example would be to
...search for a set of tags, <P> lets say that could have anything between
...them.
...> (<p>)(What goes here?)(</p>)
...
...Something like this would work:
...
...<p[^>]*>([\s\S]*?)<\/p>
...
...However, it is not going to work on nested tags, like divs:
...
...<div[^>]*>([\s\S]*?)<\/div>
...
...would not be accurate here:
...
...<div>
... <div>blah</div>
...</div>
...
...In this case, it is going to find the first opening div along with the
...inner
...closing div.
...
...-------------------------------------------
...Tom Muck
...co-author Dreamweaver MX 2004: The Complete Reference
...http://www.tom-muck.com/
...
...Extending Knowledge, Daily
...http://www.CommunityMX.com/
...
...
...
...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:21:808
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/21
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:21
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.21
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
