Forum Discussion
Colin_McCrae
12 years agoCommunity Hero
Pretty simple ....
They are totally different file types/formats. As far as I'm aware, you can't directly compare them.
You'll need to extract the data from each and compare the two sets of data. You can extract text from a PDF - assuming it's not protected. You might need to do some clever manipulation of the extracted text in order to compare it to the same data extracted from an Excel sheet (which should be much easier to work with).
I'm also not sure why you have this in the RIA section of the forum? Seems like a general functional question to me ....
They are totally different file types/formats. As far as I'm aware, you can't directly compare them.
You'll need to extract the data from each and compare the two sets of data. You can extract text from a PDF - assuming it's not protected. You might need to do some clever manipulation of the extracted text in order to compare it to the same data extracted from an Excel sheet (which should be much easier to work with).
I'm also not sure why you have this in the RIA section of the forum? Seems like a general functional question to me ....