How do I ignore columns?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MatthewH
    New User
    • Feb 2012
    • 1

    How do I ignore columns?

    I'm attempting to ignore the contents of a few columns in a text compare. I'm sure instructions are out here somewhere for this, but I can't seem to find them. Here's the file structure and a blurb on what I want to do...

    File header:Address;ResultStatus1;ResultStatus2;ResultStatus3

    File1: 100 Main St;606000606;60F000606;606000606
    File2: 110 Main St;604000606;60E000606;605000606

    I want to ignore any differences in the last three fields.

    Thanks,

    Matt
  • Aaron
    Team Scooter
    • Oct 2007
    • 16026

    #2
    Hello,

    Do your files open in our Data Compare session type and correctly, automatically detect ; as the delimiter? If so, you can then mark any specific column as unimportant by right clicking the column header, or by marking it as unimportant in the Session Settings, Columns tab.

    If you need to use the Text Compare, you can define a grammar to match on it. Instructions are here:
    http://www.scootersoftware.com/suppo..._unimportantv3

    The grammar element would probably be something similar to a Basic type, Regular Expression:
    ;.*;.*;.*$
    Aaron P Scooter Software

    Comment

    Working...