In the code below... there is always a comma at the end of it... I am not sure how to suppress the last comma... it would say: emails, no contact, supervised, letter, phone call, unsupervised visits,

Although it might not show all but it tends to show a comma at the end. Advise? Thanks


TRIMLEFT({@Visit Type - Email}+' '+{@Visit Type - No Contact}+' '+{@Visit Type - Supervised}+' '+{@Visit Type - Letter}+' '+{@Visit Type - Phone Call}+' '+{@Visit Type - Unsupervised Visits})

Yes they are like this

emails, no contact, supervised, letter, phone call,

The problem is I only like to remove the last comma which is after the phone call.... there can be more after phone call, like unsupervised visits as well or even be just 2 like emails[comma] and supervised[comma]. This is on a text box field from the database from sql.


TRIMLEFT({@Visit Type - Email}+' '+{@Visit Type - No Contact}+' '+{@Visit Type - Supervised}+' '+{@Visit Type - Letter}+' '+{@Visit Type - Phone Call}+' '+{@Visit Type - Unsupervised Visits})