Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Text.StartsWith with wildcards?

Hey folks.  I have a list with a bunch of values in it.  Using Power Query / M, I would like to search for all fields that start with "Q#", with # being a wildcard for a single numeric value.  Everyt...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    = List.Select( #"Get List of Column Names", each Text.StartsWith( _, "Q") and List.Contains({48..57}, Character.ToNumber(Text.Range(_,1,1))))