This content has been marked as final. Show 11 replies
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!