ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivan Ivanov <rambiusparkisan...@yahoo.com>
Subject Re: Output of SQL-task
Date Mon, 02 May 2005 10:10:01 GMT
Hello,

--- duvelbier-tsmets@yahoo.com wrote:
> My only problem is that the ouptu is as follows :
> <snip>
> 9002
> 9003
> 9005
> 9006
> 9000
> 9001
> 
> 0 rows affected
> </snip>
> 
> How can I remove the last line... indicating the nbr
> of lines impacted ... ?

It does not come to my mind how to configure sql task
to not ouptput its last line; anyway you can copy the
output file with tail filter skiping the last line:

<project>
  <copy file="outputfile" tofile="outputfile1">
    <filterchain>
      <tailfilter skip="1"/>
    </filterchain>
  </copy>
</project>

Another way is to replace the string "O rows affected"
with the empty string:
<project>
  <replaceregexp file="output">
    <regexp pattern="0 rows affected"/>
    <substitution expression=""/>
  </replaceregexp>
</project>

HTH Ivan

> 
> Tia,
> 
> \T,


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Sports - Sign up for Fantasy Baseball. 
http://baseball.fantasysports.yahoo.com/

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


Mime
View raw message