Replace text between two delimiters

[mu6110283]

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!

[PeterClemmensen]

Wouldn't you want string be 

want: "amazing | amazing2|"

then?

[Ksharp · Accepted solution]

data have;
have="amazing,123 cruise|amazing2,123 cruise2|";
want=prxchange('s/\,[^\,\|]+\|/|/',-1,have);
run;
proc print;run;