>Opening the fpt in a text editor doesn't give me a format that I can work with. I opened the the dbf in foxpro and doubleclicked, but that opens a separate screen for each record. Here is what I'm trying to accomplish. I have a dbf file that has duplicate entries. Now the only way to find these duplicates is by looking at the field that is displayed as memo. What I wanted to do is generate a file with just this field. Put it in Access (where I know what's going on) and run a query to find all the duplicates. Print out the list and hand it to my assistant to take care of the deletion of the dupes.
Let me pharapraise your problem for better understanding, and correct me, if I'm wrong:
1) You have a dbf file with Memo field, which may contain duplicates (in Memo field, say, Notes).
2) Let's assume, what these notes could not be more than 200 char (for simplicity)
Select padr(notes,200) as CheckNotes, *, count(*) from yourDBF group by 1, having count(*)>1 into cursor curDups
Now you can print the content of this file (list, if it's relatively small). The second task would be to determine relation between your file and curDups...
You can also try this trick: open your table exclusive, modify structure, add character field, say, Notes2 char 200. Replace all Notes2 with trim(notes). (If original notes>200, it would be truncated). Now you have your notes in Character field.
If it's not broken, fix it until it is.
My Blog