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 –
Best answer by JonathanBowen
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
+18I’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
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
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
+21So!
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
