AnsweredAssumed Answered

"Detecting" text

Question asked by tays01s on Jul 31, 2015
Latest reply on Aug 7, 2015 by philmodjunk

Title

"Detecting" text

Post

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.

Outcomes