I'm quite new to regex. Not sure how to do the follow:
Replace ":p_id" with a specific value.
For example when I simply want to replace ":p_id1" with a value, it also replaced ":p_id10" with the same value which is not what I want.
It's also possible for the ":p_id"'s to have punctuation before or after them e.g. "=:p_id1)"
Thanks in advance!