https://community.qlik.com/t5/Talend-Data-Catalog/tExtractRegexFields-syntax-to-extract-string-between-two-other/m-p/2342827#M2156 <P>Couldnt have been easier.... </P><P>&nbsp;</P><P>"dp/(.*)/ref"</P> Thu, 18 Nov 2021 04:35:10 GMT 1636848613 2021-11-18T04:35:10Z https://community.qlik.com/t5/Talend-Data-Catalog/tExtractRegexFields-syntax-to-extract-string-between-two-other/m-p/2342826#M2155 <P>Hi,</P><P>Novice here so please help if you can.</P><P>I am trying to extract a string from a url that is enclosed with two other strings.</P><P>eg, </P><P><A href="http://www.lotsofirrelevantdata.com/nothingofinterest/dp/thestringIwant/refandmorestuffIdontwant" alt="http://www.lotsofirrelevantdata.com/nothingofinterest/dp/thestringIwant/refandmorestuffIdontwant" target="_blank">www.lotsofirrelevantdata.com/nothingofinterest/dp/thestringIwant/refandmorestuffIdontwant</A></P><P>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.</P><P>Luke</P> Fri, 15 Nov 2024 23:30:34 GMT https://community.qlik.com/t5/Talend-Data-Catalog/tExtractRegexFields-syntax-to-extract-string-between-two-other/m-p/2342826#M2155 1636848613 2024-11-15T23:30:34Z https://community.qlik.com/t5/Talend-Data-Catalog/tExtractRegexFields-syntax-to-extract-string-between-two-other/m-p/2342827#M2156 <P>Couldnt have been easier.... </P><P>&nbsp;</P><P>"dp/(.*)/ref"</P> Thu, 18 Nov 2021 04:35:10 GMT https://community.qlik.com/t5/Talend-Data-Catalog/tExtractRegexFields-syntax-to-extract-string-between-two-other/m-p/2342827#M2156 1636848613 2021-11-18T04:35:10Z