Dreamweaver Find & Replace

[alexjamesbrown]

Hi,
im currently scaling up an asp application from access to SQL Server...

one of the things i need to do is convert things like:

IsDate(CertSignSentDate)

to sql server compliant:

IsDate(CertSignSentDate) = 1

I need to run a regular expression search and replace on the IsDate([]) and make it so it replaces it with IsDate([]) = 1

obviously, the bracketed value must remain the same.

any ideas?

 

[ChrisHirst]

Use a regex "lookahead"

search pattern [COLOR=red yellow]\)(?!isdate\()[/color]

will match a ")" that follows "isdate("

then a replace pattern of [COLOR=red yellow]) = 1[/color]

or you can use the DW XML, which is

<?xml version="1.0"?>
<dwquery>
  <queryparams matchcase="false" ignorewhitespace="false" useregexp="true"/>
  <find>
    <qtext qname="\)(?!isdate\()" qraw="true"></qtext>
  </find>
  <replace action="replaceText" param1=") = 1" param2=""/>
</dwquery>

Save as a .dwr then open it with the DW Find & Replace

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.