Does anyone have a regurlar expression available which only accepts dates in the format dd/mm/yy but also has strict checking to make sure that the date is valid, including leap year support?
I am coding in vb.net and am struggling to work this one out.
See subject of positing for question.
1) I recall seeing a really cool option in VB.NET using LINQ to match using "LIKE%'
2) I know regular expressions will work and I suspect that will result in the shortest code and probably won't be too hard to read for such a simple test.
Here's what I did.
Private Shared Function FileNameIsOk(ByVal fileName As String) As Boolean
For Position As Integer = 0 To fileName.Length - 1
Dim Character As String = fileName.Substring(Position, 1).ToUpper
Dim AsciiCharacter As Integer = Asc(Character)
Select Case True
[Code] .....
I want to match a string for example "yes" but where it is not in brackets so that the following would be matched: yes (bla yes bla) bla yes
View 7 RepliesHow can I match the domain part only of a URI with regular expressions? I see lots of examples but the mutch the subdomain too. What I am looking to do is to capture only the domain. So, for example [URL] should match only google. As a secondary question, I am looking to implement this on a VB.NET program. Would there be some other way to do it without regular expressions?
View 2 RepliesI want a regular expression for the following issue:I want to match a string that contains A,B,C,D,E and F. string length should be 0 to 6. and not character should be repeat in the string.Example: ABCDEF, ACDEFB, EFBCDA, etc. but not ABBCDES/W Engineer
View 3 RepliesI would like to match a certain url from an html page using a regular expression. For example I only want the url that appears after the <h2 header in the html page.basically here is the url I want to match; so what would the regular expression look like.
<h2 style="display: block"><a href="http://url.com/">url</a></h2>
I have matched the href part, but I only need to pull this particular one on the page that appears after the h2 header.
I want to match whole words for any kinds of strings, my
Text: to happening behitond .to.the to curtains of this .<NET> open <NET> sou<NET>rce project.<NET>
now i have tried this to find "<NET>" (without quotes) the whole word with[code]...
Is it possible to use regex with Range.Find.Text or set the Word.Range according to a regex in word automation? I just want to find strings that match a regular expression an manipulate them.
View 2 RepliesQuick RegExp problem (i hope). I need to identify a sub string from any string based on a regular expression. For Example, take the following strings:
[Code]...
I am pretty good with perl regular expressions but evidently I am at a loss on why this doesn't work.The code below stores "Person Test" in output variable.
im output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)", RegexOptions.Singleline)
output = re.Replace(userName, "$2 $1")
So why doesn't the following code store "#Test##Person#" in output variable.
Dim output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)")
For Each Match As Match In re.Matches(userName)
output &= "#" & Match.ToString & "#"
Next
I am trying to write a regular expression string match in vb.net. The condition that I am trying to implement is that the string should contain only alphabets and must contain atleast one letter of both lower and upper case. i.e AAA-fail, aaa-fail, aAaA-pass.
The regular expression that I have come up with is ^(([a-z]+[A-Z]+)+|([A-Z]+[a-z]+)+)$
Regex(@"@(?:[a-zA-Z0-9-]+.)+[a-zA-Z]{2,4}$", RegexOptions.Compiled);
Using the above, I want to pass only values like @gmail.com, @xyz.edu, @co.uk etc...
But I find that the values like abc@gmail.com (valid email ids) also pass through.
have a regular expression in .NET, which will allow only 24 hr time format in the textbox.
View 6 RepliesI need to validate user input in some fields, where these are defining how to show time in some views.
Requirements: Time format must be expressed in Microsoft .NET way (check this MSDN Library article if you want to learn more about framework's date and time formatting: [URL]. Keep in mind I'm looking to validate the format instead of an actual time string.
For example, user may input:
HH:mm
hh:mm
ss
hh:ss
mm:ss
... and so on.
In fact, it should validate from the shortest to longest time format available. Another point is I need to do it in client-side using JavaScript. In other words, any given regular expression by you should work in browsers JavaScript regular expressions' engine. I can't use ASP.NET validation engine, or any other. Because of project's requirements, I need to avoid that.
I want regular expression validator for my telephone field in VB.net. Telephone format should be (+)xx-(0)xxxx-xxxxxx ext xxxx (Optional) example my number would appear as 44-7966-591739 Screen would be formatted to show +44-(0)7966-591739 ext?
View 3 RepliesIn the application I am currently working on, I have an option to create automatic backups of a certain file on the hard disk. What I would like to do is offer the user the possibility to configure the name of the file and its extension.
For example, the backup filename could be something like : "backup_month_year_username.bak". I had the idea to save the format in the form of a regular expression. For the example above, the regexp would look like :
"^backup_(?<Month>d{2})_(?<Year>d{2})_(?<Username>w).(?<extension>bak)$"
I thought about using regex because I will also have to browse through the directory of backuped files to delete those older than a certain date. The main trouble I have now is how to create a filename using the regex. In a way I should replace the tags with the information. I could do that using regex.replace and another regex, but I feel it's a big weird doing that and it might be a better way.
[Edit] Maybe I wasn't really clear in the first go, but the idea is of course that the user (in this case an admin that will know regex syntax) will have the possibility to modify the form of the filename, that's all the idea behind it[/Edit]
i try to make a regular expression format to validate phone number at this format: (555) 555-5555 Dim IsPhoneValid As New System.Text.RegularExpressions.Regex("^/([0-9]{3}/)*[0-9]{3}*[0-9]{4}$")
View 3 RepliesDim re As New Regex("((?<field>[^"",
]+)|""(?<field>([^""]|"""")+)"")((?<rowbreak>,
|
|
|$)|,)")
[Code] .....
Now it puts all the data in the correct columns but there's just a comma in the empty columns.
Lets say I have a multiline textbox that I would like to have checked for say, 1-2 digits over a max of 5 lines. I found a regular expression pattern answered on another similar question on here but it was not working for me even after modifying it a number of times.
I'm currently using the following without success.
Dim textCheck As New Regex("(^d{1,2}$
?
?){0,5}", RegexOptions.Multiline)
regex - regular expression to check input on multiline textbox
View 5 RepliesI am trying to build a filter string for my DataView, but I have run into a problem. My underlying DataTable contains values that are formatted when displayed in my DataGridView.For example, if the DataColumn contains 1.52 and the DataGridViewColumn.DefaultCellStyle.Format = "n0" then 2 is displayed.So the user sees 2, then sets the DataView.RowFilter = "DataColumn = 2", and no DataRows are returned. Is there a way to format the DataColumn in the RowFilter string? For example, DataView.RowFilter = "FORMAT(DataColumn, "n0") IN (2, 4)". This filter string should return 3 rows. If not, can LINQ do this?
View 5 Replieswith a system of regional date configuration as dd/MM/yy
isdate("13/08/10 10:00") ' returns true, but with a system of regional date configuration as MM/dd/yy
isdate("13/08/10 10:00") ' returns false
how to handle this situation, all i need is i want to check a string for convert able to valid date format & then convert the same.
Imports System.Text.RegularExpressions
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim t As Object
[code]....
I'm trying to use regular expressions to find a matching model within the game. This part works perfectly! The only problem is that if it finds more than one match it'll try to place all matches it finds which I don't want it to do. Anyone more advanced in Regex can they tell me how to use regular expressions to only show one match or the first match it finds?
If Messege.ToLower.StartsWith("^place model") Then
Dim Regex As String = Messege.Remove(0, 13)
Dim R As New Regex(String.Format(".*{0}.*", Regex))
[code].....
Is it possible to write an SQL statement for MySQL which finds all rows which match a specific arrangement of letters/numbers without using REGEXP? i.e. SELECT myCol FROM myTable WHERE myCol='{number}{number}{letter}'Should return 12X and 34Y but not 123X or 34YY..SQL match on letter and number arrangement). The difference is that I have discovered that I cannot use regular expressions with the ADO.Net driver I am using. Whatsmore, I cannot update it since I am using Visual Studio 2003 which is not compatible with later versions.]
View 8 RepliesRegular Expression to count per words and characters in VB.Net. Here's my codes.
[Code]...
I'm trying to create a regex which will match either one of the following [code] This regex is supposed to return all and any form of the function that is used.If match string were - FVAL(A,"B")+5 then match group should be FVAL(A,"B")
View 1 RepliesI have the following regular expression for validating a file name:
^(([a-zA-Z]:|))?(((.)|(..)|(. %5D">^/:*?"|<>. |([^/:*?"|<>][^/:*?"|<>. ]))?))). %5D">^/:*?"|<>. |([^/:*?"|<>]*[^/:*?"|<>. ]))?$
I can get it to work in VB.NET but not C#. I can't figure out why it works in one but not the other.
[Code]...
As far as I can tell the patterns are identical in both languages with escaping. When I run the VB code I get a match. When I run the C# code I get nothing.
I have just coded the below regular expression. I have a mini rich text editor on a web page (very similar to the one I am using to post this question) and I want to make use of a double asterisk to indicate which words/phrases should be wrapped in a strong tag. The aim is to allow the user to add pre-defined HTML elements without actually having to submit HTML.
[code...]
Maybe I am over-optimising this, but I want to know if this can be made more efficient?
It is a little like a search and replace, I want to replace any string that contains any substring in parentheses with the same string but the words in parentheses colored RED: Eg
Take this text in TextBox1:
"The Prime Minister (that idiot from Scotland) made a speech today"
and convert to this text in RichTextBox1:
"The Prime Minister (that idiot from Scotland) made a speech today"