Hey Ryan... One thing that's helped me is to purchase Ben Forta's book on Regular Expressions. It's fairly inexpensive and it's very helpful.
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 3:54 PM To: CF-Talk Subject: regex help hey guys, need some more regex help I am wanting to match the word and, for instance in the following query: SELECT brbrch, brname, brst||char(brbrch) FROM tn9997/sybr where brregn=5 and bract='Y' with regex. How could I make it where it will match any whitespace (linefeed, carrage return or a space) right before the word and and then surround just the word and with <strong> tags ? or even better yet, also, if the word and is lowercase, I would like it capitolized as well, but thats not as importaint yet. Any takers? -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219017 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
