If Text.Contains Help

[Anonymous]

Hi folks.

I'm trying to verify if a text contais "#<number>." (Hashtag, number and a dot) and this number can be anyone (from 0 to infinity)

Can anyone help me with powerquery formula?

TY!

[Anonymous · Accepted solution]

@Anonymous 

1.  Create custom function 'fnRegExpExtract':

let fx=(txt as text)=>
    Web.Page(
        "<script>
            var x = '"& txt & "';
            var delim = '-';
            var pattern= /" & "\#\d*\." & "/gi;
            var result=x.match(pattern).join(delim);
            document.write(result);
          </script>")[Data]{0}[Children]{0}[Children]{1}[Text]{0}
in
    fx

2. Add new column by 'Invoke custom function', choose function and column with data or add this code; 

Table.AddColumn(prev_step, "fnRegExpExtract", each try fnRegExpExtract([column_with_data]) otherwise null)