https://keroseneheaterreview.blogspot.com/2024/02/remove-substring-from-column-based-on.html