How would I filter out text columns that do not start with a number?

[Anonymous]

I'm trying to filter rows using power query editor. Any suggestions?

[Vijay_A_Verma · Accepted solution]

If you want to show text column that do not start with a number

= Table.SelectRows(Source, each Text.Length(Text.Select(Text.Start([Data],1),{"0".."9"}))<>1)

If you want to show text column that start with a number

= Table.SelectRows(Source, each Text.Length(Text.Select(Text.Start([Data],1),{"0".."9"}))=1)