Re: Scrubbing Bad Hex Data from a String

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Hi man

There's probably an SQL solution using the SET operation and the REPLACE 
function - with a list of characters that all get replaced with nothing, 
perhaps - it's been spoke of here in the list.

You don't actually need to read anything in a file to use the SET operation.

Vern

On 3/10/2011 8:24 AM, Richard Schoen wrote:
> Hello All,
>
> We have a data string that is getting random bad data in it from an inbound fax gateway product.
>
> We need to scrub out any characters that fall outside of the a-Z, 0-9 range.
>
> Is there a quick algorithm that comes to mind for anyone for doing this ?
>
> I actually have a scan/replace routine in place.  I just need something that says: Does this char position contain a value outside of a-z, 0-9.
>
> I'm sure it's simple, but my brain is aching this morning :-)
>
> Thanks in advance.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT