Mysterious extra space with Concatenate

[Matthew_Maslank]

HI!

I’m concatenating a few name fields and have been running into what seems like a bug. An errant space shows up before the first field insert in some, but not all instances.

Code:

CONCATENATE("Set (",{Score Name}," + ",{Part Set Name},")")

Output:

Thoughts?

Thanks –

[JonathanBowen · Accepted solution]

I’d say this is almost certainly a leading space before “Ink” in the {Score Name} field.

Not easy to spot but there is a space in front of the word Three in my example:

JB

---

If this solves your problem, please consider marking this answer as the solution. If it doesn't please post again. Thanks!

[Matthew_Maslank]

So!

It was in fact a leading space, but it was cleverly buried in the middle of a formula several tables away. The system seemed to strip out the leading space when displaying the formula output, making it harder to track down.

Thanks for reminding me that the clear issue is sometimes the actual problem.

Cheers,

Matthew

[Justin_Barrett]

While having clean data is preferred, of course, this could also be addressed in the formula by wrapping TRIM() around the field reference. That will nix any errant spaces, front or back.