I'm using some 'if' and/or 'case' functions in calc fields where if the value is a number/calc it gets evaluated, if there is a missing value (".") I can detect it easily and provide a standard answer. However, where the text is a variety of text, I want to detect it as text (but not ".") and provide an answer.
How do you detect text (or a blank, ie. "") value? I've tried giving a range of numeric values to capture text by deduction, but it doesn't work and I'm not sure how FM 'values' text.