I am loading some data, not clean and not from another SQL source. So there are all kinds of things mixed in the data.
At the very end of each row in the table, in the very last column, I have a blank space followed by two pipes ( ||). I need to delete the blank space and the two pipe, but none of the data in front of that in the same column. Each row is different for that particular column. But this odd charachter mix is always at the very end.
How can I most efficiently delete the blank space and the two pipes
Thank you in advance for you help