Regex Question

  • Thread starter Thread starter Joerg Battermann
  • Start date Start date
J

Joerg Battermann

Hello there,

I am a little bit confused by a regex I need to run on some strings...
basically I want to match it all "file:// .... .xls" occurrences, but
only the ones that do NOT start or end with a " (quote). The reason
for that is basically I want to find pure text occurrences of a file://-link
within a html file, and not the ones that are <a href="file:\
\....xls">abc</a> ones...


Does anyone maybe know from the top of his/her head what the correct
regex would be in this situation?


Cheers and thanks,
-Jörg
 
Hello there,

I am a little bit confused by a regex I need to run on some strings...
basically I want to match it all "file:// .... .xls" occurrences, but
only the ones that do NOT start or end with a " (quote). The reason
for that is basically I want to find pure text occurrences of a file://-link
within a html file, and not the ones that are <a href="file:\
\....xls">abc</a> ones...

Does anyone maybe know from the top of his/her head what the correct
regex would be in this situation?

Cheers and thanks,
-Jörg
Click to expand...

I think something like [^"](file://.+\.xls)[^"] should do the trick.
Beware, though -- XML and XHTML (and maybe HTML?) allow the use of
single-quoted attributes, too. So you might have to change the regex
to [^'"](file://.+\.xls)[^'"] or something similar.
 
Hello there,
Click to expand...
I am a little bit confused by a regex I need to run on some strings...
basically I want to match it all "file:// .... .xls" occurrences, but
only the ones that do NOT start or end with a " (quote). The reason
for that is basically I want to find pure text occurrences of a file://-link
within a html file, and not the ones that are <a href="file:\
\....xls">abc</a> ones...
Click to expand...
Does anyone maybe know from the top of his/her head what the correct
regex would be in this situation?
Click to expand...
Cheers and thanks,
-Jörg
Click to expand...

I think something like [^"](file://.+\.xls)[^"] should do the trick.
Beware, though -- XML and XHTML (and maybe HTML?) allow the use of
single-quoted attributes, too.  So you might have to change the regex
to [^'"](file://.+\.xls)[^'"] or something similar.
Click to expand...

May need to use .+? instead of .+, as .+ does greedy matching and .+?
does not. With .+, if you have multiple occurrences of
"file://.......xsl" on a single line, it'll include the first file://
and the last .xls and everything between as a single match.

~Dathan
May need to change this to [^'"](file://.+?\.xls)[^'"] to turn off
greedy matching. (I think that's the correct syntax
 
I think something like [^"](file://.+\.xls)[^"] should do the trick.
Beware, though -- XML and XHTML (and maybe HTML?) allow the use of
single-quoted attributes, too. So you might have to change the regex
to [^'"](file://.+\.xls)[^'"] or something similar.
Click to expand...
Click to expand...
May need to use .+? instead of .+, as .+ does greedy matching and .+?
does not. With .+, if you have multiple occurrences of
"file://.......xsl" on a single line, it'll include the first file://
and the last .xls and everything between as a single match.
Click to expand...

You should probably also use a backreference so that whatever type of
quotation mark you match the first time, you match the second time. Don't
ask me for the syntax, I don't remember; I just know it exists.

The other thing that came to my mind when I saw this question was maybe it
will require lookahead/lookbehind. But maybe that's overkill in this
situation.
 
Back
Top