REGex Replace

Question

I'm trying to extract the following

SourceResultRIS T/F FROM 42956200004295620000RES TF FROM 8233040415-PC8233040415-PC228880217-01 residual t/f228880217-014214690617 REFUND RESIDUAL MOV4214690617Resid Trf- 16-01355416-0135544273700000-ST.Thomas GGG42737000004273700000-PC-ST.Thomas GGG4273700000-PC

Thableaus · Accepted Answer

This also works

REGEX_Replace([Source], ".*?(\d+)(-(?:\d+|PC))?.*", "$1$2")

Cheers,

BretCarr · Accepted Answer

This thread has gotten very very stale. Looks like I came up with nearly up the same @JeffF:

(?<REF>\d+(?:\-PC|\-\d+)?)

As a way to parse out what I am calling "REF". Other than that, @JeffS and I have close to the same answer. I am allowing for an OR with the pipe (" | ") under the guise that you would not have -##s AND -PC in your desired outcome. If you want to be able to have both, his allows that and mine is a bit stricter. Without a full set of data to look for other situations.

Advantage of mine would be a slight increase in speed if the data was big enough for that to make a difference.

Maybe someone could put this discussion to bed by marking a solution?!?

Cheers!