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

    Loading number and text formats



      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