Re: Finding non-printing characters in data
On Tue, 29 Jul 2003 11:23:01 -0400, Laurie Gustin wrote:
The best way is to use a host language (like ESQL/C) and fetch the
strings into FIXCHAR type host variable and scan for non-printables in
the host language.
Art S. Kagel
> HP-UX 11.0
> IDS 9.21.HC4
>
>
> Just wondering if there is a simple way to find non-printing characters
> embedded in char fields.
> I have tried to match on the hex characters but it is actually a
> substring that I am looking for.
> Is there a function to convert HEX back to character???
>
> What I need is something like this (except this doesn't work...)
>
> table1
> ( field1 char(10),
> field2 char(100)
> );
>
>
> Select field1, field2
> from table1
> where field2 like (some Hex value);>
>
> I know I am way off. Any help would be appreciated.
>
> THANKS!
>
>
>
> Laurie Gustin
> Utah Department of Public Safety
> 801-965-4410
> lgustin@utah.gov
> sending to informix-list