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
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