Power query extract values begin with number

Question

Hi,

I am trying to extract values from a coulum which start with a number. I have been using this to extract the vlaues strating with specific number and it works (my first ever query i wrote ( if Text.StartsWith([Our Ref_1],"5") then [Our Ref_1] else null)))

But now my range it 0-9, it could be any number I want to extract whole value starting with number and I am struggling with the range.

I can't use modulo as my column has no pattern.

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--