Forum Discussion
How would I filter out text columns that do not start with a number?
I'm trying to filter rows using power query editor. Any suggestions?
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)
1 Reply
- Vijay_A_Verma
Most Valuable Professional
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)