need help on regex

[=?Utf-8?B?QVZM?=]

hi,
i'm a new bie to regular expressions..
i'm trying to see if a string ends with teh below
pattern \filename.xls or \filename.xlsx...

I've used the @"\\[\w|\W]+\.xls" pattern but's it's
matching hte below string
d:\sample\.xls....

can someone help me out with teh correct pattern

[Juan T. Llibre]

([a-zA-Z]:(\\w+)*\\[a-zA-Z0_9]+)?.xls

....would match the complete path, as would :

([a-zA-Z]:(\\w+)*\\[a-zA-Z0_9]+)?.xlsx

I'm not sure if they can be combined like this :

([a-zA-Z]:(\\w+)*\\[a-zA-Z0_9]+)?.xls|.xlsx
^^^that's a pipe [ | ]^^^

....to catch them both with the same expression.

Maybe someone here can confirm ?


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"AVL" <AV*@discussions.microsoft.comwrote in message news:63**********************************@microsof t.com...

hi,
i'm a new bie to regular expressions..
i'm trying to see if a string ends with teh below
pattern \filename.xls or \filename.xlsx...

I've used the @"\\[\w|\W]+\.xls" pattern but's it's
matching hte below string
d:\sample\.xls....

can someone help me out with teh correct pattern

[Jesse Houwing]

Hello Juan,

([a-zA-Z]:(\\w+)*\\[a-zA-Z0_9]+)?.xls

...would match the complete path, as would :

([a-zA-Z]:(\\w+)*\\[a-zA-Z0_9]+)?.xlsx

I'm not sure if they can be combined like this :

([a-zA-Z]:(\\w+)*\\[a-zA-Z0_9]+)?.xls|.xlsx
^^^that's a pipe [ | ]^^^
...to catch them both with the same expression.

Maybe someone here can confirm ?

Yes you can combine them, but it is even easier to make the last x of xlsx
optional by adding a trailing ? like this:

\.xlsx?

Also make sure you escape the . as it has special meaning in regex (. equals
[^\n] by default). Also note that there are a lot more characters allowed
in a path other than [a-z0-9A-Z]. Therefore it's better to leave th epath
parsing to the professionals and use the FileInfo or System.IO.Path classes
to get the information.

Jesse

>
Juan T. Llibre, asp.net MVP

asp.net faq : http://asp.net.do/faq/

foros de asp.net, en español : http://asp.net.do/foros/

======================================

"AVL" <AV*@discussions.microsoft.comwrote in message
news:63**********************************@microsof t.com...

>hi,
i'm a new bie to regular expressions..
i'm trying to see if a string ends with teh below
pattern \filename.xls or \filename.xlsx...
I've used the @"\\[\w|\W]+\.xls" pattern but's it's
matching hte below string
d:\sample\.xls....
can someone help me out with teh correct pattern

--
Jesse Houwing
jesse.houwing at sogeti.nl