Menu

find/replace regular expression issues

undrline
2008-09-08
2012-11-13
  • undrline

    undrline - 2008-09-08

    Okay, so MS Access loves to erase my table joins and then rewrite my queries to have all my SQL SELECT items be " AS Expr99," where 99 represents consective !@#$% replacements of my code.  I paste my SQL statement into NPP, and try to do a find/replace:
    AS Expr*,
    with
    ,
    and NPP constantly tells me that no instances are found.  (Yes, I have the Regular Expressions checkbox checked.)
    AS Expr*
    does have items found, but I want the wildcard to stop when it gets to the comma.  What the hell am I doing wrong?

    Thanks.

     
    • Fool4UAnyway

      Fool4UAnyway - 2008-09-08

      Please, PLEASE, use the search functionality first before asking the same question again... Unfortunately, the search functionality currently is hidden in the Forums drop down menu.

      But, if you can't search, you CAN take a look at the current threads (on the very first page of this forum).

      You MAY see some title that has something like RegExp in it.

      DID you look there?

      Let's make life easy for you, so you can't MISS it:

      "RegExp Search" (Help forum)
      http://sourceforge.net/forum/forum.php?thread_id=2208527&forum_id=331754

      It was just 7 threads below yours when I wrote this.
      So I guess you could hardly overlook this one, if you had just scanned the thread's titles.