regex pattern

[Guest]

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

 

[Luc E. Mistiaen]

Well, your construct [\w|\W] is a bit awkward: anything between the square
bracket will cause a match; because you have \w (word characters) and \W
(non-word characters), you match everything (the | is not needed between
square brackets: it will be matched...)

try something like \\\w+\.xlsx?

 

[Kevin Spencer]

\\[^?\[\]\/\\=+\<\>:;",*\r\n]+\.xlsx?

The regular expression above does the following for a match:

1. Begins with a backslash
2. Followed by any character not in the list \?[]/\=+<>:;",*\r\n (illegal
Windows file name characters), one or more
3. Followed by ".xls"
4. Followed by 'x' (Zero or 1 time)

--
HTH,

Kevin Spencer
Microsoft MVP

DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net