I’ve been using the Data Compare session type for a while now, and loving the way BC automatically parses my delimited files and allows me to easily define key columns and mark others as unimportant. Now I’m ready to automate some of my comparisons using the scripting language. Unfortunately it appears that BC doesn’t support loading Data Compare sessions (with predefined key and unimportant definitions) from within a script.
I’ve been researching alternatives, and stumbled across the “regular expressions” capability. Would it be possible for me to use regular expressions to specify unimportant columns by saying something like “the fields after the 5th and 11th tab characters are unimportant”? Or is there some easier way to do this I’m missing?
Thanks
I’ve been researching alternatives, and stumbled across the “regular expressions” capability. Would it be possible for me to use regular expressions to specify unimportant columns by saying something like “the fields after the 5th and 11th tab characters are unimportant”? Or is there some easier way to do this I’m missing?
Thanks
Comment