If statement won't read variable correctly

[Gerry]

I have rewritten this code several different ways but the if statement will not recognize the value in $RefStatus.  What am I missing?

Even though the Data Viewer shows that the value of $RefStatus = 1, the statement evaluates as false.

Edited August 11, 2016 by Gerry
uploaded images

[Agnes Riley]

Did you debug it and when it goes to that step it skips it or does your script bail before it gets there? 

 

Your script/script step may be corrupted, too.

Have you tried playing around and saying if 1 = 1? That's usually a good test. 

[Gerry]

When I debug it, it skips the step.  If I use a different test, no problem.

I also tried deleting the IF statement and recreating, still same result.

[comment]

32 minutes ago, Gerry said:

What am I missing?

We cannot answer that, because we don't know (a) what the function vLookup() does, and (b) what are the contents of the parameters supplied to the function.

Note that it's enough for the variable to contain a trailing space in order to be not equal to 1 (assuming it's defined as text).

 

Edited August 11, 2016 by comment

[Gerry]

Issue Resolved:  the vlookup function was causing a problem.  Vlookup was posted on the Brian Dunning site and works great with text results, but seems to have issues with numeric values.  Thanks for the feedback.

[Agnes Riley]

You could try wrapping it around with GetAsNumber.  

[bruceR]

Yes.

If [ getAsNumber( $refstatus) = 1 ]

[Gerry]

Thanks Agnes,  I passed the value as a parameter to the script and removed the vlookup function.  That resolved the issue.

[Agnes Riley]

There are a lot of great functions on that siege. Some of them have bitten me in the behind before. So test the hell out of them before putting them in production unless it's one you've used before.

Recommend getting Clip Manager to save the ones that work for you. I have an entire library of scripts and functions that Inreuse.


Sent from my iPad using Tapatalk HD