Ok, hello to all again, it’s been a while since I have posted here. I have come to a point that is making me hit my head onto the desk repeatedly. I am parsing a file with “the offset of” function. I get all the data and put it into a variable. The data is as follows:
(0,0,0,0,0),(1,1,1,1,1),(-1,-1,-1,-1,-1),(2,2,2,2,2),(-1,0,1,2,1),(2,1,0,-1,0),(0,-1,0,1,0),(1,2,1,0,1),(0,1,2,2,2),(1,0,-1,-1,-1),(0,1,1,2,2),(1,0,0,-1,-1),(0,0,-1,0,0),(1,1,2,1,1),(-1,0,0,0,-1),(2,1,1,1,2),(0,-1,-1,-1,0),(1,2,2,2,1),(-1,-1,0,-1,-1),(2,2,1,2,2),(-1,-1,0,1,2),(2,2,1,0,-1),(0,1,0,1,0),(1,0,1,0,1),(-1,0,-1,0,-1),(2,1,2,1,2),(0,-1,0,-1,0),(1,2,1,2,1),(-1,-1,-1,0,0),(2,2,2,1,1),(0,0,0,1,2),(1,1,1,0,-1),(0,1,2,1,0),(1,0,-1,0,1),(-1,0,1,0,-1),(2,1,0,1,2),(0,0,1,1,2),(1,1,0,0,-1),(0,0,-1,-1,0),(1,1,2,2,1),(-1,0,-1,-1,0),(2,1,2,2,1),(0,1,1,1,0),(1,0,0,0,1),(0,-1,-1,0,-1),(1,2,2,1,2),(-1,0,0,-1,0),(2,1,1,2,1),(0,1,0,-1,-1),(1,0,1,2,2)
I then am trying to use the “min” function on this data to find well the minumum value. It is failing with the following:
Selection Failed in 0:00:09 Invalid Numeric Operation Value passed to Minimum() function is not a number ((0)
So I decided to copy that data and just put it into a variable and try it like that. It works just fine and finds “-1”. So, now, I’m dumbfounded at what is the difference. The data posted above is the variable I put it into “logged” out. So when I copy and past this data and put it into another variable it works, but when I take the variable I created from the parsing and put it into “min” it fails. What gives?
So I made a “compare” if statement and of course it fails, but when I remedy the difference and it passes, the “min” still fails.
Why is it allowing me to copy the same data that is logged out from the variable I dumped it in from the parsing, but when I just use the parsing variable it fails? I don’t get it and would like to shed some light on this. Please help!