Trying to get a column to display Yes if there are two words seperated by a comma, and No if there is only one word and no comma
This method does not work:
text = "word1, word2";
text = InStr(text, ",") ? "Yes" : "No"
return text;
Nor does this (display second word if exists or dashes if not)
text = "word1, word2";
if (InStr(text, ","))
{
text = RegEx(text, "(.*),\s(.*)", "\2");
}
else
{
text = "---";
}
return text;
