InfoPath Dev

I have a concat function in one of my fields that displays two items - com name and com title (e.g., Social Committee, Chair). However, if the "Title" is blank it doesn't display the title (e.g., Social Committee,). How can I make it so that the comma (", ") doesn't appear if the "Title" is blank so that it looks like this when the "Title" is blank (e.g., Social Committee)?

concat(comName, ", ", comTitle[. != ""])

Any help would be appreciated.

You want to only display the comma if comName is not blank.  Try using this formula:

concat(comName, substring(",", 1, (comName != "") * 1), comTitle[. != ""])

That works perfectly - thanks so much!