I am trying to replace a single quote with a space. I have tried this

-SET &FFCCNMB = STRREP (25,&FFCCNMB, 1, "'", 1, ' ', 25, 'A25');

also this -SET &FFCCNMB = STRREP (25,&FFCCNMB, 1, ''''', 1, ' ', 25, 'A25');

Any suggestions?

This message has been edited. Last edited by: Jay Potter,

With these functions and a space, you need to add an extra non space but still only give a length of 1.

e.g.

SET &FFCCNMB = STRREP (25,&FFCCNMB, 1, '''', 1, ' X', 25, 'A25');

You can also use CTRAN:

-SET &FFCCNMB = CTRAN (25,&FFCCNMB, 39, 32, 'A25');

Or more generally, using BYTVAL to translate a character to its decimal value:

-SET &FFCCNMB = CTRAN (25,&FFCCNMB, BYTVAL('''', 'I3'), BYTVAL(' ', 'I3'), 'A25');

All quotes will become spaces.

All three worked!!! Thank You very much.

I had to make a small change to the first CTRAN. I failed to say that I am using an iSeries so I had to use EDCDIC values instead.

Consider: CTRAN: Translating One Character to Another.

I also like CTRAN in these situations.

And because Dialogue Manager does not necessarily have a "format" like a field, you may need to dynamically determine the length of your variable.
You could do something like this:
-SET &TLEN = &FFCCNMB.LENGTH ;
-SET &TFMT = 'A' | &TLEN ;
-SET &FFCCNMB = CTRAN(&TLEN, &FFCCNMB, 39, 32, '&TFMT') ;

Merge that into Daniel's second -SET and you then have a very interesting command ;-)

Twanette,

Very true.
You can also do away with your second DM command:

  
-SET &FFCCNMB = CTRAN(&TLEN, &FFCCNMB, 39, 32, 'A&TLEN.EVAL') ;

BTW, I see many times people using .EVAL when not in a DM command. It doesn't hurt, but then it doesn't help.

FYI,

You can do away with both lines with:
-SET &FFCCNMB = CTRAN(&FFCCNMB.LENGTH, &FFCCNMB, 39, 32, 'A&FFCCNMB.LENGTH') ;