Hello,
I am doing a replace on a field so I can strip out various CHR such as carriage returns which I do not need.
Using the following code at present:
STRING(REPLACE(REPLACE(ACCESS-INFO,CHR(13),"[CR]"),CHR(10),"[LF]"))
Does anybody know a better way of running multiple replaces on a string field. Think the way I have it may be a tad slow as some of my programs have this code in over 100 times. Not sure a double replace like this is the best way to acheive the same outcome.
Cheers
Stuart
I am doing a replace on a field so I can strip out various CHR such as carriage returns which I do not need.
Using the following code at present:
STRING(REPLACE(REPLACE(ACCESS-INFO,CHR(13),"[CR]"),CHR(10),"[LF]"))
Does anybody know a better way of running multiple replaces on a string field. Think the way I have it may be a tad slow as some of my programs have this code in over 100 times. Not sure a double replace like this is the best way to acheive the same outcome.
Cheers
Stuart