tExtractRegexFields - syntax to extract string between two other strings

[1636848613]

Hi,

Novice here so please help if you can.

I am trying to extract a string from a url that is enclosed with two other strings.

eg,

www.lotsofirrelevantdata.com/nothingofinterest/dp/thestringIwant/refandmorestuffIdontwant

In the above scenario I want the string between dp/ and /ref but cant get the syntax right for the tExtractRegexField component. Any help would be greatly appreciated.

Luke

[1636848613]

Couldnt have been easier....

"dp/(.*)/ref"