Replace ENTER SQL/Peoplecode

Posted on by

Replace ENTER SQL/Peoplecode

PeopleCode: How to Replace ENTER in Peoplecode for write file in csv for report and other.

&NEW = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(&COMMENTS_2000, CHAR(13), ” “),CHAR(10),” “),”,”,” “);

 

SQL: How to Replace ENTER in SQL

REPLACE(REPLACE(REPLACE(TEXT, CHR(10), ”), CHR(13), ”) , CHR(09), ”)

/* Character
CHR(9) — Horizontal tab
CHR(10) — Line feed
CHR(13) — Carriage return.
*/

 

Posted in Peoplecode.