_IIF limits two questions

[doppler]

1.
Is the new _IIF limited to only numerics ?  Or can I play with strings too ?

2. Can this statement be on one line:     p=_iff(p=instr(thing$,"\"): p <= 10, p, p=0)
  re: position of "\" must be less than 11 else make it zero

Question two in my mind very iffy.  If question #1 is true.
Don't need an code answer for question 2.  I could do that in my sleep.
Just thought sub-coding might be possible in a coded line.

[Petr]

Hi,

In the last two parameters of the function you set its output values. The first for true, the second for false.

Code: (Select All)

a$ = "YES"



result = _IIf(a$ = "YES", 100, 0)



Select Case result

    Case 0: Print "a$ is not YES"

    Case 100: Print "a$ is YES"

End Select

[bplus]

2. Can this statement be on one line:     p=_iff(p=instr(thing$,"\"): p <= 10, p, p=0)
  re: position of "\" must be less than 11 else make it zero

How about:
p=_iff(instr(thing$,"\") <= 10, instr(thing$,"\"), 0)

[Pete]

If iff works with strings why didn't they just name it _stiff?

Pete

- We missed _hitkey by that much!

[Pete]

Petr's example as a string I think would be...

Code: (Select All)

Dim result as String

a$ = "Yes"

result = _IIf(a$ = "YES", "a$ is YES", "a$ is not YES" )

Print result

I say think because I haven't downloaded and installed the new version yet.

Someone please correct Steve if I am wrong.

Pete