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))))
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
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))))
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That seems to have done it.  Thanks for the assist!