I have a requirement to remove the trailing semicolons in a column.
The ";" characters have no fixed location and they may occur once or multiple times or may not be present at the end of the text at all.
TEST 02;;;;ADDRESS STREET;
How do I remove the trailing ";" characters?
The result I'm after are:
TEST 02;;;;ADDRESS STREET
I have tried using combinations of LEFT, FIND, and some SUBSTITUTE but it also removed the ";" in between the texts.