Distinguish from values in the same column

[#1]

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

[lironbaram · Accepted solution]

hi

you can use this function in the script

isnumber(OrderID) As Flag

it will return -1 for numbers and 0 to stirngs

[#3]

thanks i didnt know that function existed, thanks alot.

Just if anyone read this, the actual function is isNum(), but yeah thanks.