Hi 

Only a similar vain I am trying to remove some Tab characters from a couple
of fields on a sql/2000 database, I would be able to do this very easily on
the hp, but being relatively new to sql does anyone have a neat way of doing
this using sql server. 

Thanks in advance for any help.

Regards

Peter

-----Original Message-----
From: Ted Ashton [mailto:[log in to unmask]]
Sent: 17 May 2002 13:20
To: [log in to unmask]
Subject: Re: Crap chars


Thus it was written in the epistle of Richard Barker,
> Hi
> 
> Does anyone know a simple way in Qedit or programmatically in Quiz/Qtp
that
> I can remove non US alphabetic characters.  I can do it in Quiz, but it's
> very crap and slow, testing each char, is there a better faster way.  
> 
> I'm talking to another computer system and the other system can't handle
> French/Greek/etc character sets, for example 'í'.

So far as I can tell, this should explain to Qedit what you want:

  cq "[^ -~]"(r) "" @

In case it doesn't make sense, let me take it apart for you

  cq       -- change quiet (don't show me the lines as they are changed)
  "[^ -~]" -- A regular expression consisting of a negated character class.
              It will match every character which is outside the " " to "~"
              range (adjust as appropriate :-).
  (r)      -- this is a regular expression, not a string to match
  ""       -- replace it with nothing.  You could put "." or " " here
instead
              if you want to maintain line lengths.
  @        -- on all lines.

HTH,
Ted
-- 
Ted Ashton ([log in to unmask]) | From the Tom Swifty collection:
Southern Adventist University    | "It's a bad hobbit", said Tom, not at all
Deep thought to be found at      | keenly.
http://www.southern.edu/~ashted  |

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

****************************************************************************
****************** 
This e-mail (including any attachments) is intended only for the
recipient(s)
named above. It may contain confidential or privileged information and
should 
not be read, copied or otherwise used by any other person. If you are not a 
named recipient, please contact the sender by telephone (+44-20-8327-5000) 
and destroy the original message.
Any statement and/or opinion not related to this company's business and 
expressed in this message is that of the author and does not necessarily 
reflect those of Micro Warehouse Limited. This company does not take any
responsibility for the views of the author in any matter not related to the 
company's object. 
We reserve the right to monitor all e-mail messages passing through our 
network.
****************************************************************************
******************

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *