473,288 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

Need regular expression for this

I am trying to do a regular expression to search for

a url
so anything that has http:\\www.hellothere.com
but may not have the http:\\
and may not have the www
and may not have http:\\www
and should work for upper and lower case

I tried this:
[www|WWW][a-zA-Z0-9]*[.com|.COM]"

LOL - don't laugh.

am I close?

Nov 13 '05 #1
3 4326
1. i think access, in general is not case sensitive (unless you do a binary
search)
2. it is http:// not http:\\
3. i would use the dots as an identifier together with the instr (instring
function, see help) - you need to have at least one dot and no spaces to
have a valid IP address (e.g. bmx.com)
4. try to change your input format so that all ip addresses are entered
identical or update data that has been imported to http://...... as you say,
not all of them start with www.

nicolaas

"Danny" <da********@hotmail.com> wrote in message
news:2J**********************@news4.srv.hcvlny.cv. net...
I am trying to do a regular expression to search for

a url
so anything that has http:\\www.hellothere.com
but may not have the http:\\
and may not have the www
and may not have http:\\www
and should work for upper and lower case

I tried this:
[www|WWW][a-zA-Z0-9]*[.com|.COM]"

LOL - don't laugh.

am I close?

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
Nov 13 '05 #2
thanks for your response.
I don't see how to use the . as a placeholder in the instr command in access
2002.
I am using regular expression module and almost have this working but not
quite.

Can you tell me how to do this with the . as a place holder?

Thanks

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Fx*******************@news.xtra.co.nz...
1. i think access, in general is not case sensitive (unless you do a binary search)
2. it is http:// not http:\\
3. i would use the dots as an identifier together with the instr (instring
function, see help) - you need to have at least one dot and no spaces to
have a valid IP address (e.g. bmx.com)
4. try to change your input format so that all ip addresses are entered
identical or update data that has been imported to http://...... as you say, not all of them start with www.

nicolaas

"Danny" <da********@hotmail.com> wrote in message
news:2J**********************@news4.srv.hcvlny.cv. net...
I am trying to do a regular expression to search for

a url
so anything that has http:\\www.hellothere.com
but may not have the http:\\
and may not have the www
and may not have http:\\www
and should work for upper and lower case

I tried this:
[www|WWW][a-zA-Z0-9]*[.com|.COM]"

LOL - don't laugh.

am I close?


---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Nov 13 '05 #3
not sure, this is not my strength. I would write a module like this:
Function CHL(S As String) As Boolean
Dim i As Integer 'location of string searched, = 0 if not found
'---search for prerequsites: space or dot---
If InStr(1, S, " ", vbTextCompare) Then GoTo xit ' search for space
If InStr(1, S, ".", vbTextCompare) > 1 Then
'-----search for any of the following, add/delete lines as and required
i = i + InStr(1, S, "www", vbTextCompare)
i = i + InStr(1, S, "http://", vbTextCompare)
i = i + InStr(1, S, "com", vbTextCompare)
i = i + InStr(1, S, "net", vbTextCompare)
i = i + InStr(1, S, "org", vbTextCompare)
'if any of the following were found then it is a hyperlink
If i > 0 Then CHL = True
End If
xit:
Exit Function
err:
CHL = False
Resume xit
End Function

(just copy and paste this text into a new module)

you can then use the following expression for the controlsource of a field
in a form (just an example):

="The value for field X " iif(CHL([X])=true, "contains a hyperlink", "does
not contain a hyperlink")

Let me know if this does not make sense!


"Danny" <da********@hotmail.com> wrote in message
news:7L**********************@news4.srv.hcvlny.cv. net...
thanks for your response.
I don't see how to use the . as a placeholder in the instr command in access 2002.
I am using regular expression module and almost have this working but not
quite.

Can you tell me how to do this with the . as a place holder?

Thanks

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Fx*******************@news.xtra.co.nz...
1. i think access, in general is not case sensitive (unless you do a

binary
search)
2. it is http:// not http:\\
3. i would use the dots as an identifier together with the instr (instring function, see help) - you need to have at least one dot and no spaces to
have a valid IP address (e.g. bmx.com)
4. try to change your input format so that all ip addresses are entered
identical or update data that has been imported to http://...... as you

say,
not all of them start with www.

nicolaas

"Danny" <da********@hotmail.com> wrote in message
news:2J**********************@news4.srv.hcvlny.cv. net...
I am trying to do a regular expression to search for

a url
so anything that has http:\\www.hellothere.com
but may not have the http:\\
and may not have the www
and may not have http:\\www
and should work for upper and lower case

I tried this:
[www|WWW][a-zA-Z0-9]*[.com|.COM]"

LOL - don't laugh.

am I close?

---
Please immediately let us know (by phone or return email) if (a) this

email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Buddy | last post by:
Can someone please show me how to create a regular expression to do the following My text is set to MyColumn{1, 100} Test I want a regular expression that sets the text to the following...
4
by: Neri | last post by:
Some document processing program I write has to deal with documents that have headers and footers that are unnecessary for the main processing part. Therefore, I'm using a regular expression to go...
3
by: Joe | last post by:
Hi, 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...
18
by: Q. John Chen | last post by:
I have Vidation Controls First One: Simple exluce certain special characters: say no a or b or c in the string: * Second One: I required date be entered in "MM/DD/YYYY" format: //+4 How...
7
by: Billa | last post by:
Hi, I am replaceing a big string using different regular expressions (see some example at the end of the message). The problem is whenever I apply a "replace" it makes a new copy of string and I...
3
by: Lucky | last post by:
hi guys, i'm practising regular expression. i've got one string and i want it to split in groups. i was trying to make one regular expression but i didn't successed. please help me guys. i'm...
25
by: Mike | last post by:
I have a regular expression (^(.+)(?=\s*).*\1 ) that results in matches. I would like to get what the actual regular expression is. In other words, when I apply ^(.+)(?=\s*).*\1 to " HEART...
6
by: deepak_kamath_n | last post by:
Hello, I am relatively new to the world of regex and require some help in forming a regular expression to achieve the following: I have an input stream similar to: Slot: slot1 Description:...
14
by: Chris | last post by:
I need a pattern that matches a string that has the same number of '(' as ')': findall( compile('...'), '42^((2x+2)sin(x)) + (log(2)/log(5))' ) = Can anybody help me out? Thanks for any help!
1
by: Allan Ebdrup | last post by:
I have a dynamic list of regular expressions, the expressions don't change very often but they can change. And I have a single string that I want to match the regular expressions against and find...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.