9 Replies Latest reply on Mar 22, 2015 8:26 PM by philmodjunk

    Add multiple spaces between fields in a concatenationg calculation

    dinoapolito

      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