Need a regular expression that I can use with TextPad's "find in files" to identify instances of the & ampersand character between opening and closing <CFQUERY></CFQUERY> tags in a ColdFusion application. The opening tag does take several attributes; there can be more than one set of CFQUERY tags in a single file.
The context is, I'm converting an app from Access to SQL Server; Access supports + or & as a concatenation operator but SQL Server only takes + so I need to hunt down those ampersands.
Some notes I found on the web about TextPad's regular expressions implementation are below. Thank you!
--
According to the TextPad manual (distributed with TextPad v4.7.3), TextPad mostly supports POSIX Extended Regular Expression syntax, with the following changes:
The ERE ( ) grouping operator is spelled \( \) in TextPad
The ERE { } quantifier operator is spelled \{ \} in TextPad
The ERE | alternation operator is spelled \| in TextPad
TextPad also supports \< and \> to match the start and end of a word; \t, \f, and \n to match tab, form feed, and newline; \xHH to match a character via its code point specified in hexadecimal; and an additional character class [[:token:]] which matches a token character according to the current Syntax definition. See the TextPad manual for more information.
Start Free Trial
