AnsweredAssumed Answered

Add multiple spaces between fields in a concatenationg calculation

Question asked by dinoapolito on Mar 21, 2015
Latest reply on Mar 22, 2015 by philmodjunk

Title

Add multiple spaces between fields in a concatenationg calculation

Post

Hi,

I thought this should be easy but ...

I have a calculation that concats multiple fields

eg 

orders::OrderKey &" " & orders::cOrderDate & " " & subjectdetails::Name 

You can see I have added a space between the fields - enclosed by quotes.

But how do I add multiple spaces? I want more than one space between the fields in my result. I I simply add more into the calculation they are stripped back to a single space in the result. 

Can I add multiple spaces or a tab ?

Thanks

Dino

 

 

 

 

Outcomes