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]...
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'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 would like to be able to parse vb.net code files, so I can examine the collection of Subs, Functions (and their contents, including comments), private variables, etc. I can be open the actual source code files. So for example, if I have:
[Code]....
I'm parsing fixed length file with .NET 3.5 and Regex. This file is from bank. In customer name sometimes there is one characters from this set &,(),[],',"". These are characters, so far I've encountered. There can be anything else. Because of this my regex is failing. My regex is [A-Za-z0-9s-.,'""""(){}[]]{35}. Is there any wild card I can use for special chars rather than specifying individually. I also tried . but didn't work.
View 2 RepliesI just spent about 2 hours searching this forum on this topic but I need some advice. I am looking to extract certain data from HTML source code that I have down loaded into a text file its about 9KB in size.I am looking to keep all email address found. How would this work or what would be the best method to use? This is what I would like to extract and write to another file:
[Code]...
parse a file for lines of data that start with this pattern "Feb 06 2010 15:49:00.017 MCO", where MCO could be any 3 letter ID, and return the entire record for the line. I think I could get the first part, but the returning the rest of the line is where I get lost.Here is some sample data.
Feb 06 2010 15:49:00.017 MCO -I -I -I -I 0.34 527 0.26 0.24 184 Tentative 0.00 0 Radar Only -RDR- - - - - No 282356N 0811758W [code].....
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.
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 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 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
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 sure this is simple and I'll probably be embarrassed to have this question in my profile but I can't seem to get this Regex correct.
I'm tring to extract just the digits from the last group of the following string:
Properties[1].Securitymeasures[14].AdditionalSecurityType
so I want to have a regex that will return 14
The Regex I have come up with is:
[(d)+]
However - the match is returning "[14]" - including the brackets and I do not understand why. I have surrounded the d with parenthesis which should mean that this is the data I want to capture.
i need help parsing html using regex..i am hardly find the exact expression to use.
[Code]...