Comparing delmited text files?
Posted: Tue Nov 03, 2009 8:25 pm
Does Compare It have the ability to compare two flat, delmited files?
Similar to a comma delmited files, we have files delimited by "\" characters. These do not compare well because records may not be the same length if only one field is different. We do not need to compare some fields and could care less if they are different. Therefore, we cannot use specific characters to ignore differences on since each record is a different length. For example, field 7 may start at postion 21 on one record and postion 30 on the next. But fields 7 is always the 7th delimited field.
Similar to a comma delmited files, we have files delimited by "\" characters. These do not compare well because records may not be the same length if only one field is different. We do not need to compare some fields and could care less if they are different. Therefore, we cannot use specific characters to ignore differences on since each record is a different length. For example, field 7 may start at postion 21 on one record and postion 30 on the next. But fields 7 is always the 7th delimited field.