Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

filter 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  
Need Help
  • kushanNa's avatar
    kushanNa
    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

     

     

     

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
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

 

 

 

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi ashmitp869 ,

Thank you for reaching out to the Microsoft Community Forum.

 

If kushanNa , response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found this response helpful.

Thank you

 

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi @ashmitp869 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    If @kushanNa , response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found this response helpful.

    Thank you