Strange characters in data

Cheek Bob cheek@visibility.com
Tue, 15 Jun 1999 14:01:00 -0400


Terry,

I mentioned Hex only so I could determine the actual value of the data.  Hex
20 is spaces so that will truncate.  The problem is the HEX 00 which is
NULL.  I hate NULLs  so I try to avoid them.  Can you do an index on NULL
(ie. Index(desc, NULL))? If not, maybe you will have to do something with
MATCHPATTERN.  Try the index function (since you have the test data already
available).  If it does not work, let me know.

Bob Cheek

	-----Original Message-----
	From:	Terry Pickering [SMTP:pickering@myself.com]
	Sent:	Tuesday, June 15, 1999 1:51 PM
	To:	powerh-l@lists.swau.edu
	Subject:	RE: Strange characters in data

	I tried the suggestion about using an item statement with the value
saved - didn't work. 

	The original file is a VARIABLE length record and the field is 34
characters (as defined in the dictionary). I was truncating it down from 34
to 15 because that's all we use. When I "dumped" the record. It appears some
of the characters following the last good ones are HEX 20 and HEX 00.  

	So how do I go about trying to find these with an index function? I
know how to use it normally, but how do you search for HEX values? 



	~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
	Terry Pickering        Consultant Extraordinare 
	Monday and Friday        Tuesday - Thursday 
	Portland                 Eugene 
	(503) 245-7178           (541) 687-3416 
	~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ = = = = =
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Subscribe:
"subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l This
list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.