Remove empty line from a string

[kinjal1645]

Hello,

I have below expression displaying required data BUT with empty line at the beginning.

How do I remove empty line from the output string of below expression?

concat(distinct if(len([column1])<>0,[column1]&' * '&[column2])&' ' & chr(10))

Kindly help!

Thanks

[sunny_talwar]

Try this

Concat(DISTINCT If(Len([column1]) <> 0, [column1] & ' * ' & [column2]) & ' '), Chr(10))

[vishsaggi]

Can you share an example of whats your expected output?

[kinjal1645]

Hello Tanay,

I tried this: Concat(DISTINCT If(Len([column1]) <> 0, [column1] & ' * ' & [column2]) & ' ', Chr(10))

But it did not work, still giving empty line at the beginning.

[vishsaggi]

Did you try exactly the expression suggested by Sunny? You are missing a bracket after & ' ')

[kinjal1645]

That seems to be an extra bracket. Hence I mentioned my expression while replying to him

[vishsaggi · Accepted solution]

try this?

= Concat(DISTINCT If(Len([column1]) <> 0, [column1] & ' * ' & [column2] & ' '), Chr(10))

[wdchristensen]

You expression is causing the empty line with the "new line" character. 

concat(distinct if(len([column1])<>0,[column1]&' * '&[column2])&' ' & chr(10))

Try:

concat(distinct if(len([column1])<>0,[column1]&' * '&[column2]), '')

[kinjal1645]

This works! It was the bracket.
Thank you