Hi, I have a column in a table having string values like:   have: "amazing,123 cruise|amazing2,123 cruise2|" want: "amazing | amazing2"   summary: need to delete substrings occurring between "," and "|" and then delete ","   The column has lots of such values and I want to replace wherever such instance occurs.   Urgent help required, thanks! ... View more