Nick Burns
Member
- Joined
- May 24, 2017
- Messages
- 162
- Reaction score
- 0
- Points
- 16
- Excel Version(s)
- Office 365
I'd like to select only the columns that contain an underscore (_).
Here's what I came up with, is there a better way of doing it?
Here's what I came up with, is there a better way of doing it?
Code:
= Table.SelectColumns(RenameColumns,List.Select(Table.ColumnNames(RenameColumns), each Text.Contains(_,"_")))