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 is this a fixed value for the names or based on some logic?
- ashmitp8691 year ago
Responsive Resident
No its not fixed.
Is can be CourseXXX.csv
XXX can be any three digit (random)