Remove CTRLF char in a string

I am trying to remove a carriage control carriage in a varchar string that I am retrieving fron a db2 table. I used the bytval function to determine the dec character value '13', and then I tried to replace it using CTRAN with a dec char value of a space which is '32'. I then used the CTRAN function as follows:

LOAN_PROD_DESC_A/A255=
CTRAN(255,LOAN_PROD_A, 13, 32, 'LOAN_PROD_DESC_A);

This seems to work, but when I run the report that outputs in COM format, the record breaks in the middle of a record to a new line.

I also tried the STRREP function, using the characters that display in db2, which is '..', but again the record breaks in the middle.

LOAN_PROD_DESC_A/A255=
STRREP(255,LOAN_PROD_A,2,'..',1,' ',255,LOAN_PROD_DESC_A);
I can not change the output format either case

Varchar field on the table looks like this
N 4 ..Th in hex it looks like this
50 LOAN_PROD_A VARCHAR(255) N 4
X'0D25E388'

I need to get this to work ASAP, any assistance would be great

Posts: 6 | Location: 2401 International Lane | Registered: June 09, 2003

smiths

Platinum Member

posted

Hide Post

Jan,

I believe that you should also need to CTRAN character 10 to 32 (in addition to character 13). You need to replace the carriage return (13) AND the line feed character (10) with spaces.

Sean

------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode

Posts: 210 | Location: Ottawa | Registered: November 03, 2005

Ignored post by smiths posted

Show Post

mgrackin

Virtuoso

posted

Hide Post

I agree with smiths. You need to replace both characters (CR and LF).

Thanks!

Mickey