How "legacy" are we talking? Because I plan to use DataCheck on my 4D 2004
database (before conversion to v15), to do exactly this.

Just wanted to make sure this old solution hadn't slipped your mind, if
it's relevant.

Doug

On Wed, Sep 21, 2016 at 4:19 PM, Douglas von Roeder <dvonroe...@gmail.com>
wrote:

> I've hit a situation in a legacy application that has records with alpha
> and text fields that contain numerous non-printing characters. The
> non-printing characters are causing non-printing.
>
> How do I go about finding the records the have invalid characters and
> deleting the Char(0)?
>
> One approach would be Query by formula checking to see if the position of
> Char(0)>0 but that seems to be a painfully resource intensive approach.
>
> Another tack would be to update the trigger code but that means I only get
> cleaned up data if the record is modified.
>
> Thoughts, comments, suggestions, etc. on this issue are welcome.
>
> --
> Douglas von Roeder
> 949-336-2902
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to