Before try a third party product, I would try these:
(one by one; maybe any of them could work)
Replace all (mymemo) with "" for empty(mymemo)
PACK
Pack Memo
Copy to (mynewfile) && Then check mynewfile and if correct, rename it.
>I have a memo field where there is corruption. A pointer exists, because a browse window shows "Memo" instead of "memo".
>
>However, opening that field shows an empty window. I've tried all the obvious routes, including things like EMPTY(), MEMLINES(), MLINE(<
>,1), <>="", LEN(), ATC()
>
>however they all return a result indicating the field is truly empty.
>
>I need to identify the corrupted rows so that we can take remedial action.
>
>Is there another way of doing this without having to resort to using a third party tool such as Foxfix?
>
>TIA,
>Simon
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.