Assuming that the control characters are in the body of the record and not
in the key, the following may be helpful. When users attempt to use the
arrow keys on their PCs during data entry it can put control chars in unless
the app screens the input....
EQU ASCII.CHARS LIT
"'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890
[EMAIL PROTECTED]&*()_+~-=`[]{};:,./\<>?|':CHAR(34):CHAR(39)"
READ RECORD FROM ...
TEMP.RECORD = RECORD
CONVERT ASCII.CHARS:@FM:@VM:@SM TO '' IN TEMP.RECORD
IF TEMP.RECORD # '' THEN
CONVERT TEMP.RECORD TO '' IN RECORD
WRITE RECORD ON ...
END
Hope this helps,
Jeff Fitzgerald
Fitzgerald & Long, Inc.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carl Sadlier
Sent: Tuesday, December 13, 2005 9:49 AM
To: [email protected]
Subject: [U2] records with unprintable characters
Does anyone have a program or suggestions on how to clean up a file that has
control characters and unprintable characters that are not Subvalue,Value or
Field markers?
Thanks,
Carl
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
