Complex CSV export part 2 - the attack of the spurrious invisible characters

[James Rea]

> You could use the stripchar( function to 
> reduce the text to approved ranges. Something like
> 
>
stripchar(text,chr(9)+chr(9)+chr(13)+chr(13)+chr(32)+chr(126)+chr(128)+
> chr(255))

If you are using 5.0 or later you might want to use

stripprintable(text)

This is the same as the formula Dave suggested except that it also
strips out tabs. If you want to retain tabs in the output you would need
to use Dave's formula.

Jim Rea
President, ProVUE Development
---------------------------------------------------------------------
---   Celebrating 30 years of software excellence (1978-2008)     ---
---------------------------------------------------------------------
ProVUE Development          (714) 841-7779
18685-A Main Street PMB356  http://www.provue.com/
Huntington Beach, CA 92648  Panorama: Turn information into knowledge
---------------------------------------------------------------------