String Compare?
Is it possible to do primitive string compares at all? I seem to be drawing a blank.
Really, I'm looking for the logical equivalent of:
if Parent.Text5.Text == "" then
Parent.Temp = Parent.Input5.Text
else Parent.Temp = Parent.Text5.Text
Based on some things I've seen, I'm fumbling around with
Parent.Temp = Parent.Text5.Text eq '' ? Parent.Input5.Text : Parent.Text5.Text
Doesn't work of course, but that's what I'm aiming for. If one box has text in it, use that text. If not, use a different box....
Elsewhere, I'd love a 'Begins' type text compare. So I can compare the beginning of the string, but not the entire string (as the tail end changes) - but I suspect that's impossible with the tools at hand...
Thanks,
-Ken
|