Leonard,

Here's something that was posted a few days ago:

/quote/

Thisted, Kristian" <[log in to unmask]> asks for Hilfe on
as "... some fields contains caracters like TAB and CTRL.
   How can I clean my Image fields? Supertool? "

Suprtool would be an excellent choice:

To find and clean up TABs in Suprtool:

  >base    mydb,1,<password>
  >get     mydataset
  >define  a,myfield,1,byte
  >if      a = ^9       {caret 9 = decimal 9 = tab}
  >update
  >extract a = " "
  >xeq

Above I've used the caret "^" to find 'Character constants'.
Usually the corruption occurs in the first byte of the field, so
I defined as a single byte. Then Suprtool can update the subfield 'a'
with a space.

You could also change the selection command to "if  a < ^32" to get
all the 'unprintables' below spaces.

/paul

-----------------------------------------
Paul Gobes, Technical Support Mgr.
Robelle Solutions Technology Inc.
888 ROBELLE (762-3553)  or 1-604-582-1700
[log in to unmask]   fax: 1-604-582-1799

/endquote/


>>> "Leonard S. Berkowitz" <[log in to unmask]> 05/02/01 02:21PM >>>
I am pretty certain that there was a discussion recently about how to find
embedded special characters within a field in a TurboImage dataset, but I cannot
find it in the archives.

I did find a couple of notes about displaying an X(10) field in HEX, but that is
not what I need.

Can someone either send me the relevant posting or suggest a technique to weed
out TurboImage entries with (unwanted) special characters embedded in fields.

Thanks.
===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax:   617-509-3737
pager: 781-226-2431

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

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