Remove comma from the name of a column if it's the last text in that column

[cowannbell]

I have column names that have comma's but I need to remove the comma if it's the last character in that column name.

Smith, John,   To     Smith, John

I have tried using the multifield formula with these and neither work.

TrimRight([_CurrentFieldName_],',')

if EndsWith([_CurrentFieldName_], ",") then trimright([_CurrentFieldName_],",")
else [_CurrentFieldName_]
endif

[cowannbell · Accepted solution]

Never mind,  I had to use the rename tool and that worked.