Carriage Return and Line Feed

[djeanveau]

Greetings,

Anyone ever try to replace a CR or LF from a variable before? This does not work for me, anyone have an idea?


ASSIGN
cROW = REPLACE(cROW,CHR(13)," ") /* CR */
cROW = REPLACE(cROW,CHR(10)," "). /* LF */


Regards

 

[djeanveau]

Another thing I tried,

DO i = 1 TO LENGTH(cROW):
IF SUBSTRING(cROW, i, 1) = CHR(13) THEN ASSIGN SUBSTRING(cROW, i, 1) = " ".
END.

 

[djeanveau]

Also tried

DO i = 1 TO LENGTH(cROW):
IF ASC(SUBSTRING(cROW, i, 1)) = 13
THEN ASSIGN SUBSTRING(cROW, i, 1) = "*".
IF ASC(SUBSTRING(cROW, i, 1)) = 10
THEN ASSIGN SUBSTRING(cROW, i, 1) = "*".
END.

Still not working.

 

[Simon Sweetman]

Here is a test program I tried and it works as I would expect:

def var cLINE as char no-undo.
cLINE = "ABC" + chr(10) + "DEF" + chr(10) + chr(13).
cLINE = replace(cLINE, chr(10), "!").
cLINE = replace(cLINE, chr(13), "#").
message cLINE view-as alert-box.

Output is "ABC!DEF!#". are you sure cROW has these characters in it?