Return-Path: 
 <user-return-63847-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 4238 invoked from network); 12 Feb 2008 18:09:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 Feb 2008 18:09:18 -0000
Received: (qmail 27107 invoked by uid 500); 12 Feb 2008 18:09:08 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 27083 invoked by uid 500); 12 Feb 2008 18:09:08 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 27072 invoked by uid 99); 12 Feb 2008 18:09:08 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Feb 2008 10:09:08 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of gigado@gmail.com designates
 72.14.204.227 as permitted sender)
Received: from [72.14.204.227] (HELO qb-out-0506.google.com) (72.14.204.227)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Feb 2008 18:08:37 +0000
Received: by qb-out-0506.google.com with SMTP id z1so8586227qbc.10
        for <user@ant.apache.org>; Tue, 12 Feb 2008 10:08:45 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        bh=v1dPIRsIH2CtJ4RYvaEV9S32J11FJ3fJZwVSDkbKGXA=;
        b=qrx8WOW65g67uLypngIQjnqFGiK0r6SaVFoWKGXBkqOHQxS5/3PCTyOVXuGfZZCc6M3ENwyNEh3A9FFZ31ONF/hrAzt8IPgzIVIVuja3ZYgfOFGXo4KVpTYzodg/AuNTJmlWbcNZYNa36CY/Qlas3ayRLs6bNaRi1m2nxVFYzzk=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=LqwU1B3cnUL0I92OSIHdgZv6r9S6kLN3Yk1P6tFDh+kbrkl2y++pofsUkg7NueJKLuXeN/QM8ZC1lsGaVJjr8nu1nsausN9xDAFWwoQOzv/RcHpRo1N/eVye6AuWxSaXo6htP74+E/UjLX5CdsvJjE9lOvxr11tt0Wws97/cKEY=
Received: by 10.115.47.1 with SMTP id z1mr1781439waj.117.1202839724012;
        Tue, 12 Feb 2008 10:08:44 -0800 (PST)
Received: by 10.114.103.12 with HTTP; Tue, 12 Feb 2008 10:08:43 -0800 (PST)
Message-ID: <265537f80802121008n4def62f0w2d91c058a22ccdd1@mail.gmail.com>
Date: Tue, 12 Feb 2008 13:08:43 -0500
From: jonese <gigado@gmail.com>
To: "Ant Users List" <user@ant.apache.org>, floess@mindspring.com
Subject: Re: Am i doing this right RE: ReplaceRegExp
In-Reply-To: <47B1DF6A.2080600@mindspring.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <265537f80802120950w3e44d33co748d6f83d63eb761@mail.gmail.com>
	 <47B1DF6A.2080600@mindspring.com>
X-Virus-Checked: Checked by ClamAV on apache.org

I used Regex Coach to debug the expression and it shows it working.

HOWEVER when run my target using -debug i get the following

sql-gen-schema-file:
[replaceregexp] Replacing pattern '\[[a-zA-Z0-1]{1,}\]' with
'[healthinteractionsbs]' in 'C:\working\healthinteractions.com\DB\MS
SQL 2005\boomsocket_MSSQL_2005.sql' with flags: 'i'.
[replaceregexp] No change made

the .sql file looks like so

USE [dacsdce]
/****** Object:  Default [DF_formEnvironment_adminonly]    Script
Date: 01/29/2008 20:15:03 ******/
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id =
OBJECT_ID(N'[dbo].[DF_formEnvironment_adminonly]') AND
parent_object_id = OBJECT_ID(N'[dbo].[formEnvironment]'))
<<SNIP>>

it should change USE [dacsdce] to USE [healthinteractionsbs]

anyone see anything wrong with my regex or the file data?

thanks in advance
eric


On Feb 12, 2008 1:03 PM, Scot P. Floess <floess@mindspring.com> wrote:
> Are you sure the reg ex is working?  If not, nothing will be changed in
> the file...
>
> Can you send the sql file or some snippet of it?
>
>
>
> jonese wrote:
> > I have a simple build file and i'm trying to change some text in a .SQL file.
> >
> > in my build file i have the following target
> > <target name="sql-gen-schema-file" description="generates the file
> > which creates tables, views etc">
> > <replaceregexp file="DB/MS SQL
> > ${db.server.version}/boomsocket_MSSQL_${db.server.version}.sql"
> >       match="\[[a-zA-Z0-1]{1,}\]"
> >       replace="[${db.name}]"
> >       flags="i" />
> > </target>
> >
> > I know the regex is good but every time i run it nothing happens to my
> > .SQL file.
> >
> > am i missing something?
> >
> > Running ant 1.7.x on Windows XP Pro
> >
> > eric
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> > For additional commands, e-mail: user-help@ant.apache.org
> >
> >
> >
>
> --
> Scot P. Floess
> 27 Lake Royale
> Louisburg, NC  27549
>
> 252-478-8087 (Home)
> 919-754-4592 (Work)
>
> Chief Architect JPlate   http://sourceforge.net/projects/jplate
> Chief Architect JavaPIM  http://sourceforge.net/projects/javapim
>
> Architect Keros          http://sourceforge.net/projects/keros
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org