topic Weird alarm for Concat function. in Discussions

Weird alarm for Concat function.

Sean_ShCn0 — Sun, 27 Apr 2025 16:12:58 GMT

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 ?

Sean

Re: Weird alarm for Concat function.

txnelson — Sun, 27 Apr 2025 16:33:47 GMT

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

Re: Weird alarm for Concat function.

Sean_ShCn0 — Sun, 27 Apr 2025 19:40:59 GMT

Hi Jim,

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

Thanks!

Sean

Re: Weird alarm for Concat function.

txnelson — Sun, 27 Apr 2025 20:16:23 GMT

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