Re: LEFT Error (Or PICNIC Error...) REFORMATTED

Larry, 

Maybe you could try using the %TRIM BIFF, it removes extra spaces in a
string (not sure what it does with nulls, though).

Best Regards,

Luis Rodriguez


> 
> 
> ------------------------------
> 
> message: 6
> date: Mon, 24 Oct 2005 09:22:46 -0400
> from: Larry Bolhuis <lbolhuis@xxxxxxxxxx>
> subject: Re: LEFT Error (Or PICNIC Error...) REFORMATTED
> 
<SNIP>  
> >
> Yes, thaey ARE related in that @IFC is the IP Interface that I'm 
> interested in while IPAddress is the current Interface being retrieved 
> from a user space supplied by an API. Problem is the IPAddress is null 
> padded by the API to 15 bytes while @IFC is space padded. So I want to 
> compare only the number of non-space characters in @IFC to the same 
> number of characters of IPAddress.  Technically this compare could 
> result in a false positive (i.e. @IFC of '172.16.1.1     ' would match 
> IPAddress of '172.16.1.10nnnn' (where 'n' = null))  I still need to 
> resolve that but at least I get some positive matches now!!

</SNIP>
----------------
  Luis Rodriguez