I have a reg exp pattern as below works fine for the string : <param name="url" value="contents/cf_intro.htm" valuetype="ref">
mObjRegExp.pattern="<param.+?value=""([^""]+)""
But the same is not working for
<param name="url" valuetype="ref" value="../fmmain/fmindex.htm"
note that, i want to capture the url that comes after value=". if the value=" comes in the second place in the html tag it works. but if it comes in the 3rd position, then it doesn't work.
While I know within visual studio express 2005 it's easy enough to test and connect to SQL Express 2005 database's I ask can standard ASP connect to this also? I will be attempting from localhost IIS as obviously visual stuido does not host ASP sites.
View Replies View RelatedI recently moved to Visual Web Developer Express. I need to create a simple page that connects to my Database.mdf and runs a stored procedure. I have tried a million times but i simply cannot create a connection. I need to create an ADODB connection as i need control over the CONNECTION TIMEOUT and the COMMANDTIMEOUT properties.
I'm using the following string:
Data Source=.SQLEXPRESS;AttachDbFileName=e:dataCusto mers.mdf;Integrated Security=True;User Instance=True
I am using the following to try to connect to the database, but it does not seem to be working.
Dim sConnString
sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MediaDB;Data Source=MEDIAMACHINESQLEXPRESS"
Connection.Open sConnString
Dim Recordset
Set Recordset=Server.CreateObject("ADODB.Recordset")
Can someone tell me the correct syntax? The original syntax (which worked) for an Access DB was as follows:
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
Server.MapPath("/Music/DB/MediaDB.mdb")
How may I make Visual Web Developer 2005 Express as editor/debugger in place
of Visual InterDEV for ASP and HTML pages?
I'm working on XP IIS5.1 in classic ASP 3.0. After the installation of the 2005 Express Suite and the beta .net2 framework that ships with it(http://lab.msdn.microsoft.com/express/vwd/) the debugging with classic ASP has an odd behaviour.
I use option explicit on all pages. When the parser finds an undeclared var or function or there is some error in a stored procedure (not in the ASP page but in the SP itself)
I receive no error reporting. The page simply renders till that point and stops.
All the other errors are reported as usual.
I want to get the Structure within the 2 HTML Tags. I am not able to Get the regular expression for it. So here is the Code and could anyone give m ethe regular expression to get the HTML tags between the Code:
View Replies View Relatedhow to use Regular Expressions in ASP .
View Replies View RelatedCan anyone give me a regular expression for finding a URL in a string of
text?
Essentially what I want to do is find URLs in a text string and embed
them in {a href...} tags. However, I haven't used regular expressions
all that much in ASP/VBSCRIPT.
I need to create a regular expression for a date field that works only
in the following format MM/DD/YYYY with the / in the format. No other
format can be inputted into the field. I need 2 numbers for MM 2
Numbers for DD and 4 numbers for YYYY. If the users enter 1 number for
month, 1 for day he should get an alert.
I have this code and thought it was working but it is not.
var RegExPattern = /(d{1,2})W(d{1,2})W(d{4})/;
Im trying to replace all occurences of a newline with a <br /> tag using regular expressions.
However, I only want to replace the newline with a <br /> tag if the newline does NOT come directly after an </h2> tag.
I cant seem to work out a regular expression to do this. So, for example.
This is an example line. You can see how it would work. would create
This is an example line.<br /><br />You can see how it would work.
and
<h2>The Heading</h2>
This is an example line.
You can see how it would work.
would create
<h2>The Heading</h2>This is an example line.<br /><br />You can see how it would work.
i know there are tutorials for Regular Expressions too, but can a 'simple' example be posted in these forms
View Replies View RelatedI have been trying to run the example listed on MSDN to test a regular
expression. I'm running a win2k3 web server edition, WSH is version5.6.
I am getting an error everytime I run
Set RegEx = New RegExp
I have seen a few problems on MSDN with users not getting the right
permissions for some dll's so I went through the procedures trying to
correct that. I've seen the RegExp values in the registry. Even had a
friend of mine try the script on his machine. (mind you this comes
directly from MS) I cannot get New RegExp to work at all
I'm going down the road of learing the pattern matching in regular
expressions, and I'm trying to convert the characters into English in my
head so I can see whats happening...
For clarity with this one...
[b]([^]]+)[/b]
Ok - the first thing I did was break it up - because it looks a nightmare
like that...so now I have..3 parts..
[b]
([^]]+)
[/b]
In part 1 I under stand that the is telling the expression that a special
character is coming next, thus escaping the [ and ] respectively, thus ,
and in part 3 I understand the same and also the escaping of the /, thus
- no problems so far...
In part 2 I'm assuming that the brackets are seperating a "pattern" so that
I might reference it as $1 later on, I understand that the [^] are saying
"not enclosed" so therefore it's going to ignore a ], the + sign however
perplexes me - my VBScript book says "Matches the preceeding character one
or more times" - so does that mean the ] just before it, or does it mean the
character OR characters defined within the [ ] etc?
I've got a page of text which I am assigning to a string. Within this
page there are special tags e.g. lots of text....<ti>dogs</ti>..lots
more text....<ti>this is a cat</ti> etc.. So I've got a long string
interspersed with these tags. Now what I need to do is get a list of
the words/phrases that are within these tags. So in my list I would
get dogs, this is a cat etc..
I've tried a combination of mid, instr and replace and got it sort of
working but there's got to be a more efficient way of doing it.
Possibly using regular expressions?
looking for a regular expression example for asp in vbscript. just want to search for a name in some text, possibly display that text.
View Replies View RelatedI'm trying to find a regular expression function to strip contents out of a string which lie between square brackets [].I've got one for chevrons (to remove HTML - as below), but would prefer not to have to replace the chevrons for square brackets first.Code:
function funRemoveHTML( strText )
Dim RegEx
Set RegEx = New RegExp
RegEx.Pattern = "<[^>]*>"
RegEx.Global = True
funRemoveHTML = RegEx.Replace(strText, "")
end function
how I can modify this for square brackets as opposed to chevrons?
I am working on an ASP page which looks in a set of text for web page URLs.
Using the VBScript.RegExp regular expression object, I have this regular
expression:
[a-z]+.[a-z]+.[a-z]+/
And it works well finding URL's such as: windowsupdate.microsoft.com,
www.cnn.com, etc.
However, I have been trying to modify it to ALSO find URL's like this:
www.amazon.com/index/sell/ie6.html?val=1
Or
www.microsoft.com/windowsxp
Any ideas?
I'm making url's out of text starting with "www" etc. but I've got two problems. Firstly, if the string begins with www it doesn't get matched, and secondly, if there's a dot or a comma directly after the url, it becomes part of the url. I hope someone who is better at this than me will be able to help me out. Code:
reg.Pattern = "(s)(www)(S)(S+)"
s = reg.Replace(s, "$1<a href=""http://$2$3$4"" target=""_blank"">$2$3$4</a>")
I have been using a regular expression that I don’t uite understand to
filter the valid email address. My regular expression is as follows:
<asp:RegularExpressionValidator id="valValidEmail"
runat="server"
ControlToValidate="txtEmail"
ValidationExpression="^([_a-z0-9-]+)(.[_a-z0-9-]+)*@([a-z0-9-]+)(.[a-z0-9-]+)*(.[a-z]{2,4})$"
ErrorMessage="Invalid Email address."
Display="None">
</asp:RegularExpressionValidator>
Can someone explain me why the email address Join Bytes! is
considered an invalid email address?
Also can someone explain me what the above regular expression means?
Can I use regexps in fso.DeleteFile? I've found I can use a '?' and probably a '*' (although that seems a tad brutal) but I'm having trouble with expressions like ([a-z]|[0-9]-).
Am I wasting my time trying to get it to work (i.e. does it support them?) If so, how do I use them? Does it have its own quirky syntax or "standard" regexp? Every example I've found so far just mentions deleting something simple like *.txt.
For the record, I need to "tidy up" a directory full of images by deleting files whose names _don't_ contain particular text. It's quite convoluted and would be far easier if I could just go through each file one by one but hey. Here are the details:
1) I have a list of IDs in an array that I've read from a data source. This is the "current ID" list
2) I have a list of image filenames from a directory in another array. The image filenames contain an ID in them. There could be none, one or more images containing the same ID.
3) I look at each file in turn, extract the ID portion and add it to an array of "found" IDs - crucially, this array is only updated if the ID has not been seen before in another filename
4) I then step through this array and use Filter() to see if the ID is in the "current ID" list somewhere
5) If it is missing from the list, that ID is deemed "out of date" and all associated images containing that ID need to be deleted. Message to screen saying that ID has been deleted.
6) If it is in the list, just print a message saying it is "current" and move on.
I realise I could just step through each file and test it against the current ID list but then the output on-screen would be file-by-file and not ID-by-ID. The client doesn't care how many files there are; they don't even care about the underlying structure - they just point the browser to my script and it deletes the files, shows them which IDs have been removed and tells them how many IDs in total have been deleted.
If I went down that route I would have to keep a record of which IDs I've deleted and output the lot at the end instead of 1 by 1 as I go, which leaves the browser hanging for a while and doesn't give the client reassuring feedback as it ploughs through the directory adding the results to the screen row by row. Code:
I need to parse the following:
aaa_bbb_d_yyyy_mm.ext
aaa = ITM, CPF, FAC, GEN
bbb = almost anything (even more then 3 chars)
d = M,Q,Y,R
yyyy = year
mm = month
I'm terrible at figuring out regexp so I turn to the kind folk of SP
I have a field that should take a date in the following two formats:
MM/DD/YYYY or MM/DD (and assume it is this year, it will fill in current year)
I have my program checking against two regular expressions. The first one is ok:
Dim regEx
Set regEx = New RegEx
regEx.Pattern = "^(([1-9])|10|11|12)/(([1-9])|((1|2)[0-9])|30|31)/200[0-9]"
If the date checked comes up False, it then goes to this expression:
regEx.Pattern = "^((0[1-9])|(10|11|12))/((0[1-9])|((1|2)[0-9])|30|31)"
My problem is on the second one. If I enter an erroneous date like this: 11/189
It will go through and crash my program.
I am using regular expression to replace the text, This is asp function I have used to replace the text, but it’s not working properly Code:
View Replies View RelatedaddContent = replace(addContent,"<font>","")
Right, pretty simple eh!
However, what I need is something to say replace all occurence of strings that start with "<font" to eb replaced by zilch i.e.
<font>
<font color=green>
<font tag=this another=more>
I believe regular expression are the way to go?
any one have a quick regex for making sure that only 0..9 a..f are in a string?
View Replies View RelatedI'm trying to return a sub string using the regular expression object. I've not really used the regular expression object before and I'm finding it a bit clunky to use.
Basically I'm trying to match the 'description' within the string 'file_description_1'
However I'm unsure how to return the partial, would I use the Execute or Replace methods?
Regex looks like this:
With RegularExpressionObject
.Pattern = "file_(.*?)_[0-9]"
.IgnoreCase = False
.Global = True
End With
If I have a set of documents on a letterhead with a header and footer and I
want them in HTML look as they look on the paper - i.e. if a document is
longer then one printed page, the footer and then the header are inserted -
how do I do it in ASP?
I.e. is there a way to monitor page length depending on font, margins and
perhaps graphic used?
Problem: I want to check the data from a RecordSet.GetString result for today's date. If today's date exists in the row then I want to replace the preceeding <tr> tag with a <tr style='background:grey'>. I made the following objRegExp.Pattern:
.Pattern= "<tr><td><font size='1'>[w]*</font></td><td><font size='1'>[w]*</font></td><td><font size='1'>" & FormatDateTime(now(),vbShortDate)
This successfully identifies the row as containing today's date. Yea! Now, the replace part.
text = objRegExp.Replace(text,"<tr style='background:grey'><td><font size='1'></font></td><td><font size='1'></font></td><td><font size='1'>" & FormatDateTime(now(),vbShortDate))
This piece works except I lose the data that was actually contained in each cell. How can I have it so that the only thing that gets replaced is the table row tag?
I have a directory (folder) in ISS 6.0 Web server. I need to upload to a secure server over an HTTPS connection. What is the best method to upload from this directory to a secure sever.
To access the server via a browser i have to type a password and username.
The file are Cxml files and need to be uploaded on a secure connection.(HTTPS)
I would need to run a schedule task every 2 minutes to check the directory for any files that are there.
What script or method should i use. Is there any particular sample script such as (ASP) i could use. I am sure this can be done in ASP...but does anyone know how.
I am working on an ASP page that parses text using the VBScript.RegExp
regular expression object. My reg expression right now is as follows:
[a-z]+.[a-z]+.[a-z]+/
And if find URL's no problem like: windowsupdate.microsoft.com,
www.cnn.com, etc.
But I need to also find any URL, like these:
www.amazon.com/books/atoz/index.html
OR
msdn.microsoft.com/newsgroups/default.aspx
Some URL with a deeper path than something.something.com if that makes
sense. Any ideas?
I've discovered an insidious bug with the VBScript Regular Expression
object.I set the pattern to consist of the set of invalid filename
characters plus comma. I set global property to true then do a replace on a
SID. The Replace does nothing. However, if I attach the C++ (dev studio
2003) debugger to the IIS host process (dllhost.exe), every time I call
RegExp.Replace, the stack for one of the process's threads gets scrambled.
It ends up with the value 0x00000001 at the top of the stack! If your
debugger is set to stop on access violations, it always catches one (invalid
read trying to delete). The problem is insidious because, without the
debugger running, you would never know this is happening. ASP returns no
error. Potentially this could wreak havoc on your web application and cause
bizarre failures later on. Has anyone else run into this one? It seems to
happen only with the Replace method.
I need a regex pattern that will grab a select or textarea tag in an HTML file. If I run
the pattern I should get:
<select name="whatever">
<option value="a" selected>A</option>
<option value="b">B</option>
<option value="c">C</option>
</select>
Or
<textarea name="whatever">Here is some text area text</textarea>
I know the following pattern works:
<(select|textarea).*(.|
)*?</(select|textarea)>
But the problem is my web hosting company is using ASP scripting engine 5.1 which does not support the non greedy delimiter (?). I doubt they are going to upgrade to 5.5 anytime soon.
I'll appreciate it if anyone can give me a pattern that does the same job but does not use the ? delimiter. Is there a way I can tweak the pattern above so that it works in ASP scripting engine 5.1?