Multiline Variable Value

[Phillip]

Does anyone have a recommendation on how to create a multiline variable? I believe I've done this before I just can't seem to remember right now. I have multiple entries in a table that match up to a value that I need to create a variable from. For example, if I were to output this to a text document to format it the way I want it I would do so as follows:

FOR EACH notes WHERE NOTES.KEY = JOB.KEY NO-LOCK:

PUT NOTES.TXT SKIP.

END.

I want this to go into a variable "notestxt" with skips in between so when I put it into an editor module in app builder it will display as such

Line 1
Line 2
Line 3

I tried notestxt = notestxt + skip(1) + notes.txt. But it didn't work

Thank you in advance. I've never worked with the editor module so if you know a better way of doing this please feel free to give your recommendation.

 

[TheMadDBA]

Try this...

notestxt = notestxt + CHR(10) + notes.txt.

CHR(10) is a line feed, CHR(13) is a carriage return.

 

[tamhas]

"~n" will give you the platform appropriate new line, either line feed alone or carriage return + line feed, but you might have fun if you are building on one platform and viewing on another.

 

[Phillip]

Worked perfect TheMadDBA, thank you!