Newbie Questions

Re: Removing a comma from Concat Function

Anson Hidajat — Mon, 06 Aug 2012 16:28:54 GMT

Awesome, glad I could help!

Re: Removing a comma from Concat Function

macbeth — Mon, 06 Aug 2012 13:56:17 GMT

That works perfectly - thanks so much!

Re: Removing a comma from Concat Function

Anson Hidajat — Fri, 03 Aug 2012 22:28:12 GMT

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

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

Removing a comma from Concat Function

macbeth — Tue, 31 Jul 2012 18:54:00 GMT

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.