topic Replace text between two delimiters in New SAS User

Replace text between two delimiters

mu6110283 — Fri, 06 May 2022 07:17:52 GMT

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 — Fri, 06 May 2022 08:53:06 GMT

Wouldn't you want string be

want: "amazing | amazing2|"

then?

Ksharp — Fri, 06 May 2022 11:54:39 GMT

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