compare two memo fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables with same structure. ID, data . I do a one to one
relationship on ID. I want to do a line to line compare (unix diff, or
windows Comp) on the data field and create a new field where I can display
the results of the compare.

let me know if this is doable

thanks

mehul
 
Hi Mehul,

Depending on the circumstances, I'd either:

1) search the web for a VB module, control or DLL that implements a
suitable diff or COMP. I tried this, and the results looked hopeful:
"diff algorithm" implementation "visual basic"

2) write the data to temporary files and shell out to diff or COMP,
capturing the output to store in the new field.
 
John,

Thanks for your help. I ended up doing this in a very very messy way.
First I did a StrComp of the two fields, things that didn't match I exported
to txt file. ran a diff using cygwin, ran perl on diff results to parse into
a readable xml file. I now have what I wanted.

I did find the diff for VB.net from code project, sounds very interesting I
will give this a shot.

Mehul
 
Back
Top