I use this :
Bit of a sledgehammer but it works and it's quick too
FOR CHARACTER = 127 TO 249
CONVERT CHAR(CHARACTER) TO '' IN THIS.MESSAGE
NEXT CHARACTER
Gets rid of all sorts of nasty webby characters :-)
Bob
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: 26 April 2012 14:16
To: U2 Users List
Subject: Re: [U2] ASCII ^010^013 Removal (LF CR)
Thanks all!
I was trying to remove both CR and LF with a CONVERT and it did not appear to
be working... but when remove one item (CR or LF) at a time it does indeed
work. Tony and Will - Thanks!
Greg
From: "Tony Gravagno" <3xk547...@sneakemail.com>
To: u2-users@listserver.u2ug.org
Date: 04/25/2012 08:07 PM
Subject: Re: [U2] ASCII ^010^013 Removal (LF CR)
Sent by: u2-users-boun...@listserver.u2ug.org
I don't recall about which platforms this applies, but CONVERT is used to
change a single character. CHANGE or SWAP (depending on platform) changes
multiple chars:
CONVERT SINGLE1 TO SINGLE2 IN VAR
VAR = CHANGE(VAR,MULTI1,MULTI2)
VAR = SWAP(VAR,MULTI1,MULTI2)
> From: Wjhonson
> Doesn't
> CONVERT CHAR(10):CHAR(13) TO "" IN X.ID work?
> From: Greg Coelho
> Any suggestions how I can use CONVERT to strip ASCII control
> characters EC 010 and 013 (LFCR) from a variable?
> CONVERT '?' TO '' IN X.ID
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
Confidentiality Notice: This e-mail and any attachments are intended solely
for the addressee and may contain confidential or privileged information. If
you are not the named addressee, or the person responsible for delivering the
message to the named addressee, please notify the sender as soon as possible
and delete the material from your computer. This message will be protected by
copyright. If it has come to you in error, you must not take any action based
on its contents nor must you copy or show the message to any person other than
the intended recipient.
_____________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
