Yeah, I answered my own question! Once I found the right page in the
documentation.
This worked exactly as it needed to.
FIND:
(session.cps.dbStruct.)(CPSDB)([\s\S]{0,20})(INSERT)
REPLACE:
$1CPS_ORADB$3$4
Heehe. I knew there had to be a way to do this programmatically. Of course I
could have done it manually in 1/2 the time I spent figuring this out. But I
am justifying it by saying it was a learning experience that can only help me
in the future, right?
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
...-----Original Message-----
...From: Ian Skinner
...Sent: Tuesday, January 11, 2005 11:44 AM
...To: RegEx
...Subject: RE: Any character, any character at all.
...
...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/
......
......
......
......
...
...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the mailserver that powers this list at
http://www.houseoffusion.com/banners/view.cfm?bannerid=17
Message: http://www.houseoffusion.com/lists.cfm/link=i:21:811
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
