How to add new line as delimiter in join

[Soumiya15]

Hi all,

Please help me out with how to add a new line delimiter in the join function

join(createArray('Apple', 'Orange', 'Pear'),'s\n ')

this returns  

'Apples\n Oranges\n Pears'

But the required output is 

apples

oranges

pears

Could anyone help me out how to achieve it.

Thanks in adavanced 

[Expiscornovus]

Hi @Soumiya15,

Can you try this expression instead:

join(createArray('Apple', 'Orange', 'Pear'), concat('s',decodeUriComponent('%0A')))

[Expiscornovus]

Hi @Soumiya15,

I just realised that the last item will not have the join character. So, in both our examples Pear will stay Pear and not become Pears because it is the last item of the array 😁

In that case probably the setup below is a better suggestion.

In here I use a Select to apply a concat with an s character at the end of the item (in text mode of the Map field). After that I use a join function again to add the line feed character.

[Soumiya15]

Adding s is not need i want to split all three in new line 

[Expiscornovus · Accepted solution]

Hi @Soumiya15,

In that case just use this:

join(createArray('Apple', 'Orange', 'Pear'), decodeUriComponent('%0A'))

[Soumiya15]

Hey thanks for help it worked😊