11 Replies Latest reply: Aug 8, 2016 9:18 AM by Matthew Berry RSS

    Loading number and text formats

    Matthew Berry

      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!

      item num.PNG