I must be missing something as this sounds like a very simple request and I couldn't find an answer in the forums etc.
Lets say I have "products" csv that gets updated with new products, price changes etc. This file is generated on a daily basis from a db and I simply wanted to compare yesterdays version of the file with todays, with the resulting differences output to a file in the exact format for further processing (i.e. a one way, left to right or right to left comparison).
I know I can output a differences file/report, but the formats of those report files don't maintain the original files format (e.g. side-by-side, interleaved, patch etc) - how can I simply dump out a "differences file" - nothing fancy, just the rows that have changed from the previous version of the csv...
Any ideas?
One last request along the lines of the above, is there an option to dump out a differences report as I listed above but with a simple character key "difference column" added to the output file outling the difference (i.e. "A" = Row Added, "C" = Row Changed, "D" = Row Deleted)?
Thanks, TJ
Lets say I have "products" csv that gets updated with new products, price changes etc. This file is generated on a daily basis from a db and I simply wanted to compare yesterdays version of the file with todays, with the resulting differences output to a file in the exact format for further processing (i.e. a one way, left to right or right to left comparison).
I know I can output a differences file/report, but the formats of those report files don't maintain the original files format (e.g. side-by-side, interleaved, patch etc) - how can I simply dump out a "differences file" - nothing fancy, just the rows that have changed from the previous version of the csv...
Any ideas?
One last request along the lines of the above, is there an option to dump out a differences report as I listed above but with a simple character key "difference column" added to the output file outling the difference (i.e. "A" = Row Added, "C" = Row Changed, "D" = Row Deleted)?
Thanks, TJ
Comment