Syntax question Directory.GetFiles

[lynnsong986]

Hello,

this line worked fine till today, I started to get the error message “Where is not a member of string”…I need to loop through all excel files not starting with ~ at the beginning of the file

Directory.GetFiles("C:\Users\lynn.song\Desktop\Attachments","*.xlsx",SearchOption.AllDirectories).Where(Function(s) not System.IO.Path.GetFileName(s).StartsWith("~"))

thanks

[Gbenga_Odelade]

Hi,
Try this
Directory.GetFiles(“C:\Users\lynn.song\Desktop\Attachments”,“*.xlsx”,SearchOption.AllDirectories).Where (Function(s) not System.IO.Path.GetFileName(s).StartsWith(“~”))

[lynnsong986]

@Gbenga_Odelade

Directory.GetFiles(“C:\Users\lynn.song\Desktop\Attachments”,“*.xlsx”,SearchOption.AllDirectories).Where Not(Function(s) System.IO.Path.GetFileName(s).StartsWith(“~”))

that is not working either

[ushu (Usha kiranmai)]

Hi @lynnsong986 - I’ve tried your expression but it’s not throwing any error. Can you please retype/copy the same expression, save it , wait a minute

[lynnsong986]

Yes it works now! weird… thanks so much!

[fernando_zuluaga]

Hi @lynnsong986

Give a try with

System.IO.Directory.GetFiles("C:\Users\lynn.song\Desktop\Attachments","*.xlsx",SearchOption.AllDirectories).Where(Function(s) not System.IO.Path.GetFileName(s).StartsWith("~"))

Make sure that your variable is IEnumerable

Regards!