Chip:

You're correct - there's a variety of non-printing characters so it will be
a QbF that does a Find in array.

I'm just wondering is there's a way to fix this that's not so time
consuming.

And, just to deke me, there's a filter called "Text_Filter" that's empty.
:-)

--
Douglas von Roeder
949-336-2902

On Wed, Sep 21, 2016 at 2:36 PM, Chip Scheide <4d_o...@pghrepository.org>
wrote:

> Doug,
> this might be more then you think...
> as I recall there are a number of non-printing characters in unicode
> char(0) through char(31) except Char(10), char(13)
>
> so it may not be a "simple"
> Query by formula([table];position(char(0);[table]field)>0)
>
> It may actually be a case of
> do any of the characters in any text field in my database match any of
> these prohibited characters in this list.
>
> I had some old code to locate and exterminate gremlins (same idea,
> older systems) but it does not seem to be handy. That code may have
> come from the nug, you could check the archives...
>
> If i find it - I'll forward it to you.
>
> Chip
> On Wed, 21 Sep 2016 14:19:14 -0700, Douglas von Roeder 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
> **********************************************************************
**********************************************************************
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