Re: regexp_count seems to not work as it should

PabloCSD · ‎01-08-2025

Try this way (it worked for me in a Databricks notebook and it returns 2):

SELECT regexp_count('nA*BsABreA*Bthe', 'A\\*B') str_cnt;