From: noJimspam@omitThisHarganonline.com   
      
   On Thu, 28 Jun 2007 10:15:37 -0700, Ike wrote:   
      
   > We have a Paradox database. It contains information about products we   
   > copy off the 'Net. We have a custom utility that cleans text in   
   > Windows clipboard of any forbidden characters like carriage   
   > return/line feeds (CRLF). I have told the employees time and again to   
   > NEVER paste text directly from a web page into a Paradox field. But   
   > they sometimes do and when the field contains a CRLF it signifies to   
   > Paradox that it is the end of the record when we export the data to a   
   > flat ASCII file. Any data after the CRLF is gone. Is there any   
   > mechanism in Paradox that will filter out forbidden characters so this   
   > no longer happens?   
      
   Two possibles:   
   1. CR/LF is legal in a memo field.   
   2. Write OPAL code that intercepts the ctrl-v, and instead of doing the   
   default paste event, substitutes your own custom method. This method would   
   paste the text into a string variable and then, perhaps, step through it   
   looking for illegal characters. If you only want to scrub CR/LF, a   
   breakApart will do it in a single whack. Personally, I step through the   
   entire string and expunge *all* low and high ascii, including tabs (each of   
   which gets replaced with three spaces).   
      
      
   Jim Hargan   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)