Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if anyone knows how i can distinguish values in the same column that start with a letter.
For example i got orders that when are generated from source A they are just numbers, but when generated from source B they have 4 letters in the start. What i really want to do is a button that would only select the ones that are only numbers. I thought i could try to create a flag in the load script that could differenciate between a number and a string, but im not sure how to do this.
thanks for your help guys,
KR
hi
you can use this function in the script
isnumber(OrderID) As Flag
it will return -1 for numbers and 0 to stirngs
hi
you can use this function in the script
isnumber(OrderID) As Flag
it will return -1 for numbers and 0 to stirngs
thanks i didnt know that function existed, thanks alot.
Just if anyone read this, the actual function is isNum(), but yeah thanks.