Eliminating duplicate memo fields must be done !!!
I have to code a method to find and delete all but one of any
duplicate memo fields found in a very large dB.
After an extensive search, I've come to the conclusion that I must
first truncate all of the Memo fields into text fields of 255 or
less, the do the compare and delete based on the total record of all
of the text fields.
I would then have to concatenate the final unique record text fields
back into a memo field.
This is probably easy to some of you, but I don't have a clue how to
do several parts of this.
1. Using the "Left" to parse, I can set the criteria to 255 caracters.
How do I then cause those caracters to become "Text Field 0001" in the
same record?
2. When I get that done, I can use the "Mid" to parse the second 255
caracters. Then I have the same problem. How do I cause those
caracters to become "Text Field 0002" in the same record?
3. When the final caracters remaining are say, only 143 caracters, how
do I cause just those last caracters to become Text Field 0107, (or
what ever), and then start the comparison process with however many
text fields I ended up with?
This is WAY over my head, but I would love to learn how to do it.
Does anyone know of any existing code that would accomplish
eliminating duplicate memo fields?
TIA
Tim Bankerd
