Replacing carriage returns with spaces -?

HCL Domino Domino Forum
1

Hi everyone!

The following formula:

txt:=@Replace(txt;@Text(@Char(13)+@Char(10));" ");

must replace all carriage returns from DOS-text (return sequence is: 0D 0A (13 10)) with spaces. But it doesn’t.

What’s wrong?

Thanks in advance,

Dmitry.
2

Subject: Replacing carriage returns with spaces - ?

Try to use @replacesubstringinstead of @replace

cu axel

3

Subject: …no effect.

This doesn’t work.

4

Subject: Very strange :o))

txt:=@Replace(txt;@NewLine;" ");

This works great :wink: sorry.

5

Subject: Not so strange, since carriage returns are stored internally as null characters

Because Notes/Domino is used on various OS platforms besides Windows, and different systems use different carriage return combinations, the internal storage is a null character, Char(0), which is then converted to the appropriate sequence on an OS dependent basis.