How can I add a line feed inside the Value XPath

Erik van der Vlugt · 2025-02-06T18:19:01+00:00

There was an error rendering this rich post.

Hi, I added a new field inside a cell. When available I want this to print on a new line but want to avoid a new line when empty.

Tried with several variations of this:

concat(/M3OutDocument/DataArea/Document/ZZXMLD,''
'')

or perhaps someone has a trick to otherwise avoid a new line.

Find more posts tagged with

Accepted answers

All comments

Jacek Selega

You can hide value when field is empty.

Erik van der Vlugt

Hi Jacek, that is for the new field inserted, got that. But when I want this field to show on the next line it creates an empty line I do not want when the field is empty. Basically I want to either suppress a Linefeed or insert one in this new field.

Thanks, Erik

Jacek Selega

Not sure if i got you correct but i used also this formula to concat when fields are not empty concat(ZZTEXT[. != ''][1],' ',ZZTEXT[. != ''][2],' ',)

Erik van der Vlugt

Hi Jacek, nice one, did not know this variation, could come in handy. But what I meant is how to concat a linefeed in there, let's say where you insert a space.