I have a string with some custom formula like FVAL("A")+FVAL(B). I want to figure out all string inside FVAL() which does not have quotes around it.
So basically I want to extract out B because it does not have quotes around it.
I'm in need of some help trying to figure out the RegEx formula for finding the values within the tags of HTML mark-up like this:
<span class=""releaseYear"">1993</span>
<span class=""mpaa"">R</span>
<span class=""average-rating"">2.8</span>
<span class=""rt-fresh-small rt-fresh"" title=""Rotten Tomatoes score"">94%</span>
I only need 1993, R, 2.8 and 94% from that HTML above.
validating a 9-digit number.
CANNOT BE -----------
000000000
111111111
[code]....
I had just managed to get the first piece done -- "^(??!0+|1+|2+|3+|4+))d{9}$"
I was considering validating some input using RegEx to match a pattern of
Firstname, Lastname
I largely have it, but there is so much variability in names that I'm not quite sure if any pattern is safe. In fact, in this case, I know that no pattern is safe, so I have built in a means for the user to accept whatever was entered, regardless of what it was, which isn't so great.
What I'm wondering is whether or not there is a safe Regex pattern that will cover names in this format, or will cover at least most of them. What I currently have is:
"^[A-Z][a-z]+, [A-Z][a-z]+"
But that will allow through things like Hiker, Shaggy, the, which is fairly silly, but shouldn't be allowed....I think. Does anybody use names with commas in them? I know that apostrophes are fairly common, though I'm pretty sure I can ignore them.
Need a pattern to match a string which should NOT be --
777777777
888888888
999999999
Or start with 00 or 02 or 04. when i tried to go create a pattern to match the above requirements, i got it done by - Dim _pattern6 As String = "^(7+|8+|9+|(00|07|08|09|17|18|19|28|29|43|48|69|70|78|79|80|96|97).*)$". could not get the NOT MATCH part done.
I have to extract all there is between this caracters:
<a href="/url?q=(text to extract whatever it is)&
I tried this pattern, but it's not working for me:
/(?<=url?q=).*?(?=&)/
I'm programming in Vb.net, this is the code, but I think that the problem is that the pattern is wrong:
[Code]...
I need your help to find the right pattern to extract a string that i need.. The problem is that i have to extract all there is between this caracters:<a href="/url?q=(text to extract whatever it is)& I tried this pattern, but it's not working for me! : /(?<=url\?q=).*?(?=&)/
i'm programming in Vb.net, this is the code, but i think that the problem is that the pattern is wrong:
Dim matches As MatchCollection
matches = regex.Matches(TextBox1.Text)
For Each Match As Match In matches
listbox1.items.add(Match.Value)
Next
This is a pretty complex regular expression that returns an array of key/value pairs from a proprietary string of data. Here is sample of the data, in case the express can not be used in .Net and another method needs to be used.
0,"101"1,"12345"11,"ABC Company"12,"John Doe"13,"123 Main St"14,""15,"Malvern"16,"PA"17,"19355"19,"UPS"21,"10"22,"GND"23,""24,"082310"25,""26,"0.00"29,"1Z1235550300000645"30," PA 193 9-05"34,"6.55"37,"6.55"38,"8.05"65,"1Z1235550300000645"77,"10"96,""97,""98
If you look closely you see its key,"value",key,"value" The only guarantee on formatting is that each key value pair is separated by a comma, and each value will always be encased in double quotes. The main problem (the reason you cant explode it) is the poor choice of the previous coder to separate keys and values with the same character as the entries. Anyways, out of my hands. Here is a working PHP example.
function parseResponse($response) {
// split response into $key, $value pieces
preg_match_all("/(.*?),"(.*?)"/", $response, $m);
[code]....
I am developing a regex/pattern tester in vb.net where I have three textbox's:
- Textbox1: Here I enter my regular expression for pattern matching in textbox2
- Textbox2: Upload the plain-texts from dB and then look for a match
- Textbox3: Displays the result of the search.
Now the issue I am having is when I enter a regular expression in **Textbox1** and click search it is unable to find any matching pattern even though I have made sure a matching text is present in the paragraph.But whereas, if I enter the non-regex word/text itself in Textbox1 it is able to find a match.
In my button click_event I have initiated all the relavent regex functions etc but still not able to figure out why it wont except regex expressions instead of the word itself.Here is the code I am using for pattern search:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim m As Match
Dim re As Regex
Dim matches As MatchCollection
[code]....
I am working on my application to extract the value from my php page using with the regex pattern. I can extract the value using with the mystrings1 tags with no problem, but I can't be able to extract mystrings1 and mystrings2 tags in the same line.
[Code]...
I have to validate a string using a regex pattern, I just can not figure out how to actually create it. In practice my string is composed of:
aw4d13-m12k4s It therefore can only contain characters from "a-z" and "0-9" separated by a "-" Who can kindly do it for me?
I'm trying to find a pattern in a string, I guess is very easy but I'm terrible in regular expressions. I have a big text and I need to find all the next type of pattern:
{a|b|c}
That can be also something like this: {a|b|c|s|f|f|ft|r} or any number of items inside but at least 2 items so the pipe symbol is another key. Is this an easy regular expression? I'm using vb.net 2005.
Trying to parse a text file for records starting with an RH space and a date. I need to return the entire line. I expect to find about 6000 in the file. Example of a full record:
RH 09/27/08 11:49 11:49:00.224 COA292 H393 2664FB753 178 -54.82 8.98 C 431 264 13 040 34 24.45-074 58 57.93 H Snipit of text file:
[Code]...
I have strings like:
1. Three (3) 10,000 gallons underground gasoline storage tanks.
2. Equip ID: (23-1)
I want to extract the '3' and the '23-1' and from the strings. I can rely on the first set being inside ( ) as the strings I need. The strings will be numeric characters plus the dash (anything between ( ) would be preferable.) What RegEx pattern would I use?
Here's what I have so far but it gets the first number and not the ones in ( ):
Function Extract_Stuff(ByVal LineText As String) As String
Dim myMatches As MatchCollection
Dim myRegex As New Regex("([0-9]+)")
myMatches = myRegex.Matches(LineText)
For Each successfulMatch As Match In myMatches
Return successfulMatch.Value ' should only be one match, return first
Next
Return ""
End Function
I'm trying to assign the pattern regex looks for using an if statement like below. Then I use match to test, returning t/f from match.success. The patterns work fine, and finds what i am looking for in a test data set. The problem comes when I try to assign a pattern to test for via an if statement (assigned to SearchRegexString below) and then try to match using the appropriate object. so basically
SearchRegexString = "TestStringA"Object = new regex (pattern, options)object.match(string).success
[Code]...
doesn't work. match.success always returns false when the if then construct is used even if the phrase exists in the string. Is this a compiler issue, beyond the limits of Regex? what is going on?
I have a project that uses regex, and while matching strings and regex syntax is working well [If rx.IsMatch(test) Then], i'd like to know (if any) a way to use regex to extract all instances of a pattern.
View 3 RepliesI need to find illegal characters in a windows forms textbox
The textbox text is sent as an sms text message and illegal characters are not allowed
e.g 1 client pasted some text from a word document into the texbox and the ' in msword appears as slanting ' in the textbox (see below)
e.g msword text - This is a new test of the Services
after pasting in textbox - This is a new test of the Services
The sms company have advised the slanting apostrophe is a unicode character
How can I find characters like above so I can remove them before sending the sms text
have a 1mb file, should get the pattern from it
pattern should be like this
6numbers + 10&FF + 6numbers
in the hex binary editor it looks like this
[code].....
I need an extremely simple regex pattern that matches anything within square brackets [].
Example:
This is a [test] text with [some] [examples].Required results: [test], [some], [examples].I don't want to get rid of the brackets, they should be included in the result (that should make it easier, right?)
If possible I'd like to exlude results that have whitespace in them, so things like [this string] should not be matched. If that gets too hard (probably not, but hey I can't even manage this :S) then I don't really mind, I can always check if the result contains whitespace myself.
I tried a lot of examples I could find online and ones that I could think of myself but none work. Note: I've been testing with the Visual Studio Find dialog (checking to use regular expressions obviously), maybe that's where the problem lies, because I don't really understand why some of these don't work...
Anyway, first thing I tried was simple: match the two brackets and one or more characters in between (that should be a +, right?)
Rename files in a folder who's name matches a regex pattern ?[code]...
View 3 RepliesCannot work out for the life of me how to match the apostrophe in a regex pattern in .net, seems to be different in .net than any other implementation of regex where you can just use '
Also tried matching "x27", "'" and "''" all with no success
It 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 RepliesQuestion:Given a SQL string like
CREATE VIEW TestView AS
SELECT value1, value2
FROM TABLE_0[code]...........
for each strObjectName in tables, to check whether or not the view depends on this object.But this fails on table_12 (and results in cyclic dependencies) for example, because tables contains "table_1". Aaargh.I need a regex that can check if the view definition contains a function name, table-valued function or another view...
(
For checking with
System.Text.RegularExpressions.Regex.IsMatch([code].....
But it fails, plus it doesn't account for object names embraced in brackets, like
"[TABLE_NAME]"
I'm trying to match exactly the following format:
+639201112222
09201112222
and this is all Ive tried so far:
(+63|0)?d{10}
the problem is that it match 2920111222 in 29201112222. How can i create a pattern that will match only the formats below?
+63XXXXXXXXXX
0XXXXXXXXXX
+63 or 0 plus 10 digit number only.where X are all digits from 0-9.
I'm working on a program that get's a file list from an FTP server and it's getting it as one giant html string, here's what I'm getting:
[code]...
Alternatively, if anyone knows how to get an ftp file object using .Net 2.0 instead of an html string that would be even better.
I am trying to get '[NewsLink1234]' from the textbox. I think the Regex code is correct. I need the results to show:
[NewsLink1234]
[NewsLink12333444]
[NewsLink12]
Depending on which ones are in the textbox as the numbers will be ids.
Here is the code:
Partial Class Hertscricket___Test_admin_Default
Inherits System.Web.UI.Page
Public StringVariable As String = ""
Public strValue As String = ""
[Code] .....
I am having an issue where I am using regex.Replace to replace part of a string. The basic idea is that I want to capture the beginning of the string then replace the end of the string with a value from code. For an example pretend I have a string that says "Test Number " followed by number and I want to increment that number. I capture the "Test Number " but when I try to concatenate that capture with the new number it treats the capture ($1) as a literal and replaces the entire string with $1[new number].
[code]...
This will output "We are on Test Number 2", as expected. how I can use a variable in the replacement string portion of the Regex.Replace when including a captured group?
My programming days are many years in the past - so I'm trying to get back into it. My current problem is as follows - I have a word document that is set up as a mailmerge document that is merged to email (through outlook). The merge records are in an excel spreadsheet (the email address is in a field called EMAIL). My emails are getting rejected by the recipient domain because they're being sent too fast (so they therefore think that they're spam).
I need to create a VB Program that will use the document called MASTER and merge it with the spreadsheet called RECIPIENTS and send via Outlook. However, I need it to send the first 10 emails, wait 10 minutes, send the next 10, wait another 10 minutes and continue cycling through until all of the emails have been sent.
I want to take the text and some special characters between the xml tags.. My input file contains:
[Code]...
now i want the Regex to take text and the special characters between the tags <line>,<inline>..
[URL]It is a sub that is meant to add a user to a group in Active Directory. However, I can't seem to figure out how to use it. Here is the code:
''' <summary>
''' Method to add a user to a group
''' </summary>
''' <param name="de">DirectoryEntry to use</param>
[code]....
I'm not sure what to put for the first argument when calling it. For example:
AddUserToGroup(?, User, Group)