I have different phases with similar structure within Column A, that I would like to explore if a wild card replace or if REGexp_replace is avaiable to use.
i don't not want to use individual replace as the list can get super long. I tried both and none of them working.
Please see my attachment. "Column A finish" is my goal. Please suggest a effective function for wild card replacement.