Building Regex (regular Expression) - Get Data Out Of String?
May 21, 2009ok, For the moment I have a string() where each element is in the structure of
[Code]...
ADVERTISEMENT
Regex - Capture The Repeating Data Using A Regular Expression In .Net?
Feb 7, 2011I'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)
[Code]...
Regex - Regular Expression Needed To Replace Return Character With Another String?
Jul 20, 2009I'm trying to replace all the carriage return characters in a string obtained from a multi line text box in a Windows Form with the string ", <BR>" so that when I use the string in some HTML it displays correctly.
Function Blah(ByVal strInput As String) As String
Dim rexCR As Object
rexCR = CreateObject("VBScript.RegExp")
[code]....
Regex - Regular Expression To Parse Whitespace-delimited Data?
Jun 18, 2009I have written code to pull some data into a data table and do some data re-formatting. I need some help splitting some text into appropriate columns.
CASE 1
I have data formated like this that I need to split into 2 columns.
[Code]...
column is the first 11 characters That is easy.column 2 should contain all the text after the first 11 characters up to but not including the first number.The last column is all the text after column 2
Regex - Regular Expression To Extract Numbers From Long String Containing Lots Of Punctuation?
Aug 27, 2009I am trying to separate numbers from a string which includes %,/,etc for eg (%2459348?:, or :2434545/%). How can I separate it, in VB.net
View 4 RepliesBuilding A Dynamic Regular Expression?
Jun 12, 2009I'm attempting to build a function that will return a regex that is dynamically created.The regex to create will be a range check between two numbers. So far I've got something similar to this (not finished as yet).Is this approach valid, or is there an easier way that I'm overlooking?
Public Shared Function Range(ByVal Minimum As Integer, ByVal Maximum As Integer) As String
Return "^([" & Minimum.ToString.PadLeft(2, "0") & "]" & Microsoft.VisualBasic.StrDup(Minimum.ToString.Length, "[0-9]") & "|2[0-4][0-9]|25[0-5])$"
[code]......
Regex :: How To Write Regular Expression
Sep 14, 2010My coworker needs me to write him a regular expression for his vb.net app.I do not know vb and he does not know regex.The regex he needs is:/.*web id: ?(d+).*/iBasically he needs to search a string for something like "web id: 345" or "web id:2534" and retrieve the ID.He took what I gave him above and was able to put this together:
Dim strPattern As String = ".*web id: ?(d+).*"
Dim strReplacement$ = "$1"
GetWebId$ = Regex.Replace(LCase$(strNote$), strPattern$, strReplacement$)
[code].....
Regex - ASP Regular Expression For UK Telephone Format?
Sep 23, 2009I 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 RepliesRegex - Regular Expression With Specific Criteria
Jan 31, 2011I'm trying to type a regular expression that follows the following format: [URL] There are no special characters or numbers permitted for this criteria. I thought I had it down, but I'm a bit rusty with regular expressions and when I tested mine, it failed all across the boards. So far, my regular is expression is:
[Code]...
Regex - Parsing Excel Reference With Regular Expression?
Oct 14, 2010Excel returns a reference of the form
=Sheet1!R14C1R22C71junk
("junk" won't normally be there, but I want to be sure that there's no extraneous text.)I would like to 'split' this into a VB array, where
a(0)="Sheet1"
a(1)="14"
a(2)="1"
[code]....
I'm sure it can be done easily with a regular expression, but I just can't get the hang of it.
Regex - Regular Expression That Requires At Least ONE Digits And SIX Maximum
Jan 21, 2011I need a regular expression that requires at least ONE digits and SIX maximum. I've worked out this, but neither of them seems to work. ^[0-9][0-9]?[0-9]?[0-9]?[0-9]?[0-9]?$ ^[0-999999]$
View 4 RepliesVS 2010 Proper Regular Expression (Regex) Pattern?
Apr 24, 2012It seems up until now I've never used Regex, nor even heard of it. But once I did I realized how extremely useful this is. Having said, it's been 2 days since I've began looking into constructing my own patterns. My most recent being for decimals. Is the pattern I provided below "proper"? and are there also any improvements I could be making for a more efficient patter, which would minimize any possibility of a loophole? [code] So for my use, this is doing what it's supposed to being doing under every test I can through at it. But do mind the 0. and .0, I have a function to normalize these as they are proper, I just pad the left and right accordingly. I found most regex questions asked here..and yes I am doing this in vb.net so it fits. If not, then feel free to move this post somewhere else better suited for the topic of discussion.
View 12 RepliesRegex - Extract SubString Based On Regular Expression Match
Apr 26, 2012Quick 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]...
Regex - Regular Expression To Check Input On Multiline Textbox?
Mar 15, 2011regex - regular expression to check input on multiline textbox
View 5 RepliesRegex - Regular Expression To Convert Ul To Textformat And Back, With A Different Attribute Value For First Tag ?
Apr 1, 2010This is a related to a previous question I have asked here, see the link below for a brief description as to why I am trying to do this.Regular expression from font to span (size and colour) and back (VB.NET).Basically I need a regex replace function (or if this can be done in pure VB then that's fine) to convert all ul tags in a string to textindent tags, with a different attribute value for the first textindent tag.For example:
<ul>
<li>This is some text</li>
<li>This is some more text</li>[code].....
Basically I want the first ul tag to have no indenting, but all nested ul tags to have an indent of 20.
Regex Regular Expression To Remove Lines Which Start With Certain Text?
Mar 24, 2012I know it may be quite easily for you. i have a text which contains 40 lines, I want to remove lines which starts with a constant text. check below data.
When I used (?mn)[+CMGL:].*($) it removes the whole text , when I use (?mn)[+CMGL:].*(
) , it only leaves the first line.
+CMGL: 0,1,,159
07910201956905F0440B910201532762F20008709021225282808
+CMGL: 1,1,,159
[Code]...
Regular Expression (RegEx) To Replace Floating-point Numbers In XML?
Aug 22, 2011I'm using Visual Basic 2010 Express to edit an XML file. I want to replace items that have (typically) non-zero floating point numbers with a single zero.
View 4 RepliesRegex - .net Regular Expression To Match Two Words Separated By Comma Not Working?
Mar 4, 2010I 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
Regex - Regular Expression To Split By Comma + Ignores Comma Within Double Quotes?
Feb 7, 2012I'm trying to parse csv file with VB.NET.csv files contains value like 0,"1,2,3",4 which splits in 5 instead of 3. There are many examples with other languages in Stockoverflow but I can't implement it in VB.NET.Here is my code so far but it doesn't work...
Dim t As String() = Regex.Split(str(i), ",(?=([^""]*""[^""]*"")*[^""]*$)")
Get A Regular Expression That Can Validate That A String Is An Alphanumeric Comma Delimited String?
Jun 23, 2011I need a regular expression that can validate that a string is an alphanumeric comma delimited string.
Examples:
123, 4A67, GGG, 767 would be valid.
12333, 78787&*, GH778 would be invalid
fghkjhfdg8797< would be invalid
This is what I have so far, but isn't quite right: ^(?=.*[a-zA-Z0-9][,]).*$
Regular Expression - Match A String
Jul 2, 2009I 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 RepliesRegular Expression : Match A String That Contains A,B,C,D,E And F?
Jul 2, 2009I 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 RepliesRegular Expression That Checks Input String
Oct 26, 2009I understand the concept of regular expressions but I am looking for a regular expression string that checks the input string for the following criteria only...
1.) Upper and lower case letters
2.) The space character
3.) Apostrophe
4.) Comma
5.) Period
6.) Hyphen
Regular Expression To Return A String In Between Two Brackets
Mar 19, 2009Ok - this may seem like a strange request ... but basically I need a regular expression to return a string in between two brackets as described below... String:
[Code]....
Use A Regular Expression To Find A Certain String Within A Textbox?
Jul 29, 2009I am trying to use a regular expression to find a certain string within a textbox.
Is it possible to include the equals sign (=) within the regex so it looks for this? When i type the equals sign within the regex it doesn't fnid it any more.
Works when searching this string - "and JobID 816138</Detail>":
[Code]....
Make A Regular Expression To Find A Substring Within A String?
Nov 20, 2009How do I make a regular expression to find a substring within a string that looks like: |sdrt446-7fdfs23| ? The number of characters and types change. So I need whatever in within the | |.
View 3 RepliesMatch Whole Words With Regular Expression For Any Kind Of String?
Jan 4, 2012I 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]...
Regular Expression Needed To Replace Return Character With Another String?
Jan 21, 2010I'm trying to replace all the carriage return characters in a string obtained from a multi line text box in a Windows Form with the string ", <BR>" so that when I use the string in some HTML it displays correctly.
Function Blah(ByVal strInput As String) As String
Dim rexCR As Object
rexCR = CreateObject("VBScript.RegExp")
[code]....
Regular Expression Replaces Special Chars With Numbers Instead Of String?
Jun 30, 2010I'm using the following to strip special characters out of a URL:
Dim urlReg As New Regex("[^dw ]")
inurl = urlReg.Replace(inurl, "")
[code]......
Regular Expression To Find Characters In A String And Convert Them To A Number
Sep 2, 2010I may have a string for example potato in a vb.net application. I want to find all the occurrences of o and convert them to 0, so the desired out is: p0tat0.I know it can be done by the provided string operations but I need a regular expression in my scenario.
View 1 Replies