Weird alarm for Concat function.

[#1]

Hi 

Recently I found a very wierd alarm. previously it works, but now seems there is some problems. details as following.

in my table there are three column named as "LSL" "TSL" "USL", both are set as nominal data. 

when I use concat function to have a new script LSL-TSL-USL. I try with two method as following:

Method 1: use JSL to edit the formula

concat(:LSL,"-",:TSL,"-",:USL)

Method 2: use the formula box drag the LSL,TSL, USL column name in the formula edit window, and type the strip like "-". 

I tried this before, actually it was work perfrectly.  but now i used the same way, seems there is something went wrong. I am not sure this is a bug or some logic changes. 
any one has the similare experience like me ?

KR

Sean

[#2 · Accepted solution]

The columns you are concatenating need either be Character, not numeric, or you need to use the Char() function to convert he data in the formula

[#3]

Hi Jim, 

it works, although my data formate are already nominal. but after i use Char, it works. 

Thanks!

KR 

Sean

[#4]

Your data are nominal, but not character, they are numeric values.  concatenation into a string requires character values.