Answers/SchemeServe Answers
Answered
How do I test for the length of a field in new documents
Rob Symonds
asked this on June 24, 2011 09:31
I need to see if a field contains non space characters and only put it into the document if it does.
Comments
To test the length of the answer to a question:
## IF([QuestionName_Value].Length > 0, [QuestionName_Value], "") ##
This will remove blanks and then test the length of the answer:
## IF([QuestionName_Value].Replace(" ", "").Length > 0, [QuestionName_Value], "") ##