AnsweredAssumed Answered

odd behaviour with attribute - calculated string

Question asked by DaniPerez on Feb 15, 2013
Latest reply on Feb 15, 2013 by nick_darlington
I found an odd behaviour when using a calculated attribute, type string.
When the string1 is a number, the string not used as a char string but a numeric


For instance:
In task object:
Create a calculated attribute string with function concat (the only available)

Concat(prname,"222")

Create a task with name: 123456789
then the attribute display: 123,456,789,222

Create a task with name: 0123456789
then the attribute display: 123,456,789,222

of course if prname start with alphanumeric it is working fine but....



More examples

Concat("0123456789012345678901234567890123456789","")
in View/Field shows
123,456,789,012,345,678,901,234,567,890,123,456,789

Concat("0123456789012345678901234567890123456789")
in View/Field shows
123,456,789,012,345,678,901,234,567,890,123,456,789

Concat("0123456789012345678901234567890123456789","H")
in View/Field shows
0123456789012345678901234567890123456789H

is it a bug or there is any explanation?
I am using the default quotation marks and syntaxis

Outcomes