problem with File.Delete

[Ben]

Hi,

i want to delete all excel files together in a specific directory. I tried
this but the syntax is wrong: File.Delete(Server.MapPath("~/excel/" &
"*.xls"))

Can somebody tell me the right syntax?
Thanks
Ben

[BooGhost]

Ben,
If you were to look at the documentation for System.IO.File.Delete()
you'd see that it takes a path to the file you want gone. Path's can
not include wildcards.

You want to do something like:
Dim tFilePath As String = String.Empty

For Each tFilePath In Directory.GetFiles(Server.MapPath("whatever"),
"*.xls")
File.Delete(tFilePath)
Next

You should be aware of a small (I think) bug in the file matching
algorithm Directory.GetFiles() uses. "*.xls" will match all files
who's extension begins with xls. This includes xls, xlsx, xlsa,
xlsux, etc.

-Boo

On Jul 15, 2:24*pm, "Ben" <[e-mail]:

Hi,

i want to delete all excel files together in a specific directory. I tried
this but the syntax is wrong: File.Delete(Server.MapPath("~/excel/" &
"*.xls"))

Can somebody tell me the right syntax?
Thanks
Ben

[Mark Rae [MVP]]

"Ben" <be*@sdf.sfswrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...

I want to delete all Excel files together in a specific directory. I tried
this but the syntax is wrong: File.Delete(Server.MapPath("~/excel/" &
"*.xls"))

Can somebody tell me the right syntax?

The File.Delete method does not support wildcards. Therefore, you need to
instantiate a collection of files that you want to delete, and then iterate
through them and delete them individually...

http://msdn.microsoft.com/en-us/library/cc148994.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Ben]

Thanks
(one explanation, in this case, those of Booghost, was enough ... Redundant
information must be avoided, no?)

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netschreef in bericht
news:uu**************@TK2MSFTNGP02.phx.gbl...

"Ben" <be*@sdf.sfswrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...

>I want to delete all Excel files together in a specific directory. I
tried this but the syntax is wrong: File.Delete(Server.MapPath("~/excel/"
& "*.xls"))

Can somebody tell me the right syntax?

The File.Delete method does not support wildcards. Therefore, you need to
instantiate a collection of files that you want to delete, and then
iterate through them and delete them individually...

http://msdn.microsoft.com/en-us/library/cc148994.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Ben" <kn*@shdv.sdwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

[top-posting corrected]

>>I want to delete all Excel files together in a specific directory. I
tried this but the syntax is wrong:
File.Delete(Server.MapPath("~/excel/" & "*.xls"))

Can somebody tell me the right syntax?

The File.Delete method does not support wildcards. Therefore, you need to
instantiate a collection of files that you want to delete, and then
iterate through them and delete them individually...

http://msdn.microsoft.com/en-us/library/cc148994.aspx

(one explanation, in this case, those of Booghost, was enough ...
Redundant information must be avoided, no?)

BooGhost's reply hadn't appeared on the newsserver when I posted my reply -
there is often a time-lag in these things...

How about you don't top-post next time...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Ben]

ok!

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netschreef in bericht
news:uQ**************@TK2MSFTNGP02.phx.gbl...

"Ben" <kn*@shdv.sdwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

[top-posting corrected]

>>>I want to delete all Excel files together in a specific directory. I
tried this but the syntax is wrong:
File.Delete(Server.MapPath("~/excel/" & "*.xls"))

Can somebody tell me the right syntax?

The File.Delete method does not support wildcards. Therefore, you need
to instantiate a collection of files that you want to delete, and then
iterate through them and delete them individually...

http://msdn.microsoft.com/en-us/library/cc148994.aspx

(one explanation, in this case, those of Booghost, was enough ...
Redundant information must be avoided, no?)

BooGhost's reply hadn't appeared on the newsserver when I posted my
reply - there is often a time-lag in these things...

How about you don't top-post next time...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Marc]

I too detest top posting, but not as much as self appointed internet police
;)

Marc