Forum Discussion
ashmitp869
Responsive Resident
1 year agofilter from a sharepoint folder - power query
Hi, How can filter from a sharepoint folder with file name Course439.csv Course196.csv Course111.csv Courseany3digit.csv Thanks
- 1 year ago
HI,
use the following filter
= Table.SelectRows(#"Changed Type", each Text.StartsWith([Name], "Course") and Text.EndsWith([Name], ".csv") and Text.Length([Name]) >= 8 and List.Contains({"0".."9"}, Text.Middle([Name], 6, 1)))Before Filter
after filter
parry2k
Super User
1 year agoashmitp869 click the filter (down arrow) and use text filter -> begins wtih
k on the filter and then use start withs
ashmitp869
Responsive Resident
1 year agoThat's not possible as I have a file name CourseList which I don't want to pick