Loading number and text formats

[#1]

Hi,

I have an issue when loading items into QV.

Some items load as text and some load as numbers. Some have '-' and some have letters in the string. View the image below.

My issue with the item numbers that load as numbers. Instead of loading as item # 15430, it loads as item # 15430.0000.

I have tried using TRIM but that doesn't work. I tried NUM but then it drops all of the item #'s formatted with a '-' or letter in them. I tried TEXT but that just aligns everything on the left.

I need to do this in the load script rather than on the object for example.

Any help would be great!

[sunny_talwar]

From the looks of things, it seems that the second half of the expression isn't taken into the variable you have created. Would you be able to share the definition of vConcatKey variable? You might need to add $2 in addition to $1

[#3]

Sunny,

ConcatKey = if(trim($1)='' or IsNull($1), '*NONE', trim($1)) & '%' & if(trim($2)='' or IsNull($2), '*NONE', trim($2));