Brian,

I've been enjoying using the command line interface of the Compare tool and it has been very helpful thus far, but I am having a little difficulty in the granularity of selecting objects to compare (or not to in this case).

Here is the argfile:
<?xml version="1.0"?>
<commandline>
    <include objecttype="Table"/>
    <exclude objecttype="Table" matches="t_rpt_rcn_"/>
    <exclude objecttype="Table" matches="t_temp_"/>
    <force/>
    <outputwidth>140</outputwidth>
    <snapshot1>\\server1\snapshot1.SNP</snapshot1>
    <snapshot2>\\server2\snapshot2.SNP</snapshot2>
    <out>\\server3\output.txt</out>
    <report>\\server3\report.html</report>
</commandline>

What I would like to do is now exclude all tables that start with "t_str_" with the exception of "t_str_dimension" and t_str_levels". I really don't want to have to explicitly exclude all 49 remaining tables.

Any ideas?

Peace,
Gary Hampson
GaryHampson
0

Comments

2 comments

  • Brian Donahue
    Hi Gary,

    Thanks for posting here. You should be able to get away with this rather easily. You can make a regular expression that matches the first part of the table but not the endings that you specify and put that in an exclude tag:
        <exclude objecttype="Table" matches="\[t_str_(?!dimension\]|levels\])"/>
    
    Brian Donahue
    0
  • GaryHampson
    That is wonderful!! Thanks again Brian.. You are the best!!
    GaryHampson
    0

Add comment

Please sign in to leave a comment.