Spacing issue in concatenation of objects

building semantic layer
1

I have created a new variable by adding together to objects, first name, and last name. =[BRC First Name]+""+[BRC Last Name]. However, when it shows up on my report there is a large gap of space between the first and last name. Not sure what I’m doing wrong I have the “” between the two for no spacing.

thanks,

Eric2 (BOB member since 2019-11-07)

2

There are probably spaces within the first or last name fields themselves. Most databases have a trim() function that you can use to remove these. Something like:

=trim([BRC First Name])+""+trim([BRC Last Name])

However, if you do that, you will see the first name and last name smacked together without any spaces at all, like this:

JohnDoe

You may want to put one space back:

=trim([BRC First Name])+" "+trim([BRC Last Name])

Dave Rathbun :us: (BOB member since 2002-06-06)