Problems with Newline from Notes to winword

HCL Domino Domino Forum
1

I write the content of a notes field to Winword and replace there a special replacement tag with the field value.

If these strings contain Newlines (Chr(13) & Chr(10)) I replace them with Chr$(13), otherwise they will not correctly tranferred (2 rectangles instead of newline…)

Chr(13) works fine, but if the replacement tag in winword is at the end of a table cell, it doesn’t work and the Chr(13) is written as rectangle. :-((

I tried to put a space after the tag, but this has no effect. Only after putting another linefeed after the replacement tag in the cell works correct.

Is there any solution against this strange effect?

Many thanks in advance!

Isa

I use this code in notes:

Set varFind = varRange.Find

varFind.ClearFormatting

varFind.Replacement.ClearFormatting

varFind.MatchWholeWord = True

Call varFind.Execute(“<” & sItemName & “>”, False, False, False, False, False, 1, False, False, sTmp, 2)

2

Subject: Problems with Newline from Notes to winword

Have you tried using chr(10) only as linefeed instead of chr(13) ?

3

Subject: RE: Problems with Newline from Notes to winword

Really forgotten to post: Yes, I’ve tried this also, but unfortunately again rectangles instead of linefeed.

Any other idea…?

4

Subject: Solution

In Lotusscript one has to replace Chr$(13) & Chr$(10) with ^l (Small L). Then it works. :slight_smile: