How do I test for the length of a field in new documents

Follow

Rob Symonds

24 June 2011 08:31

I need to see if a field contains non space characters and only put it into the document if it does.

5

• 

  Rob Symonds 24 June 2011 08:32

  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], "") ##

  0

  Comment actions Permalink

Please sign in to leave a comment.