Need to query for a variable value that only contains a single word

[Elliott]

I need to query a name variable and the user wants to know if the name is only a single word.  The variable contains business names so should have multiple words. How do I do that.. for the specific words I am using index(lowercase(name), "Corp")>0 but I do not know how to query for a singer word, no matter what it is.  The name field is Char 26.

Any assistance you can offer will be greatly appreciated.

Thanks,

Elliott

[Haris]

Are you looking for COUNTW function?

[Elliott]

no, I need to identify if the business name is only a single word, no matter how many characters.  The user feels this may be an invalid name and wants to review the information.  They feel a single name with no spaces is an invalid business name and should be flagged.

Thanks, 

[Haris · Accepted solution]

COUNTW counts words, not characters. CountW(VarName)=1 sounds like the condition you're looking for.

[Reeza]

COUNTW() is correct, please try it and let us know. If it's not, post the code you've tried and show an example of a case it doesn't find.

---

@Elliott wrote:

no, I need to identify if the business name is only a single word, no matter how many characters.  The user feels this may be an invalid name and wants to review the information.  They feel a single name with no spaces is an invalid business name and should be flagged.

Thanks, 

---