https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/41006#M27280 <P>what do you want to achieve with the curly brace?&nbsp; It is a regex character so you can't just add it.<BR />If you want to match on it, you should escape it and perhaps even put it within the quotes.<BR />You can always test your regex in online tools like regex101 or regexr or ... very handy</P> Tue, 22 Aug 2023 14:23:01 GMT -werners- 2023-08-22T14:23:01Z https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/40983#M27274 <P>HI guys,</P><P>I tried to use the regex_extract but when I put <STRONG><EM>{</EM></STRONG> in pattern I received error</P><LI-CODE lang="python">display( df_containerlog.withColumn('reg', regexp_extract(col('LogEntry'), "((^.*))({'data':)", 1)) )</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="error-regex.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3233i681222211699F04B/image-size/large?v=v2&amp;px=999" role="button" title="error-regex.png" alt="error-regex.png" /></span></P><P>have any idea</P><P>Thank you</P> Tue, 22 Aug 2023 13:33:52 GMT https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/40983#M27274 William_Scardua 2023-08-22T13:33:52Z https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/41006#M27280 <P>what do you want to achieve with the curly brace?&nbsp; It is a regex character so you can't just add it.<BR />If you want to match on it, you should escape it and perhaps even put it within the quotes.<BR />You can always test your regex in online tools like regex101 or regexr or ... very handy</P> Tue, 22 Aug 2023 14:23:01 GMT https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/41006#M27280 -werners- 2023-08-22T14:23:01Z https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/41013#M27281 <P>Hello William,</P><P>You have to escape the <STRONG>{ </STRONG>as it is a special char in case of regex.</P><LI-CODE lang="markup">"((^.*))(\{'data':)"</LI-CODE> Tue, 22 Aug 2023 14:37:49 GMT https://community.databricks.com/t5/data-engineering/regexp-extract-error-when-put-in-pattern/m-p/41013#M27281 Amine 2023-08-22T14:37:49Z