Concat Function is creating a space on some records, why?

Hi @jorgep17, you can use the Replace function in GI like this: =Concat(Replace([BAccount.AcctCD],’ ‘,’’) , [Location.LocationCD]).

They may be fixed width in the database, and such having the space.

You could either Trim, or replace a space with a blank.

 

=Concat(Trim([BAccount.AcctCD]),Trim([Location.LocationCD]))

or 
 

=Replace(Concat([BAccount.AcctCD],[Location.LocationCD]),’ ‘,’’)

@jorgep17  The reason might be that in the database, these values might be saved with the extra space.

You can use the TRIM() function to remove the space for those texts. like below.

=Concat(Trim([BAccount.AcctCD]),[Location.LocationCD])

Great guys,

The =Concat(Trim([BAccount.AcctCD]),Trim([Location.LocationCD])) got rid of the spaces. 

One more thing, how can I use the Replace fuction in this same formula? I need to also replace the text MAIN with 000. See below.

Where should I insert the Replace command?

=Concat(Trim([BAccount.AcctCD]),Trim([Location.LocationCD]))
=Replace([Location.LocationCD], 'MAIN', '000')

This one seemed to have done the trick.

Thank you all!!

=Concat(trim([BAccount.AcctCD]),Replace([Location.LocationCD], 'MAIN', '000'))

This is not going to trim the LocationCD.

I see, maybe in my case, it didn’t need to be, as the data showed correctly after without the spaces. So I would assumed the AcctCD was the one needing Trimming. 

Thank you!