• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

how to compare 2 delimited text files?

Is there a way to compare the formatting structure of 2  comma delimited text files?
  • 2
2 Solutions
What do you mean by "check the formatting structure"?

You can definitely use CSV (comma separated value) files as data sources... you'd need to be able to link the two files together by a common key, which would need to match exactly, and then you could use formulas to test the equality of each field in both files (text match, numerical equality, even length of field or such).

If this isn't what you mean, let me know, and we'll work on it!
zachvaldezAuthor Commented:
The files have.txt extensions and data are separated by ",". for example, "Y',"N","123 N.Apple st",
with no data, it places (quotes) like " ", " ", etc.

If you just want to see if the layout of the two files is the same, not caring about the contained data, I'd suggest opening them up in Excel and taking a look at them. That's probably your best bet for confirming the "structure" is the same. You can even open up both files at the same time, each in it's own window, and check the columns one by one.

Crystal will tell you if you try to link two different data types together (numeric with string, etc), so you COULD open both files in Crystal and link each and every field together, first with first, second with second, etc. If they don't go together, you'll get a type mismatch error.

I think it's easier to eyeball them in Excel, though.
Another way would be to use them as te source for an Access database table.

What are you trying to accomplish?


Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now