Concat one string to a table field

Dynamics 365 Business Central/NAV Developers Forum
1

I would like to Know how can I join in a table field one fixed string?

Ex: Field value = 2110

Strring = A

Result 2110A

Note: I Am using this C/AL :

Account_Code := (Account_Code+‘A’);

But like this the result is:

2110 A

How can I avoid this space?

Thanks

2

I cannot but assume that these spaces are part of the field (Account_Code) value, so you need to remove these from the field.

Just tested the following code:

String := ‘2110’;
String := String+‘A’;
MESSAGE(’%1’,String);

with result showing: 2110A

3

Hy Luc

Yes the result in my message is 2110 A .

So, how can I avoid this space??

4

Either make sure users enter data without spaces or remove trailing spaces through code. For the latter have a look at the DELCHR string function.

The stange thing is that NAV, when entering data in a field, will remove trailing spaces automatically, so I wonder where they come from.

5

probably from the original import. I notice we had a ton of ending spaces when we first start nav especially in address & city fields.

delchr(yourstring,’>’,’ ');