Still getting to grips with regex and have seen a few samples about that give me most of what I need so asking for opinion on this. I need to extract x words from a single line, so the regex could use w+ to get characters, however my line may contain anything inside the word like:
[Code]...
.net framework 2 vs 2008?I need to extract a string from website. Loading a site in a big string works perfect. Im searching on google and here and I come to conclusion that regex is the easiest way to go. So...How to extract a string from one big string between known words using regex?reader string holds next data to use with regex:
...
<div id="sites-content0" class="sites-canvas-main-content sites-clear" style="">
<div dir="ltr">SampleDataToExtract v.1.2.6.7<br /></div>
</div>
...
I need to extract: SampleDataToExtract v.1.2.6.7 to another string and then work with that...
Vb.net
response = request.GetResponse()reader = New StreamReader(response.GetResponseStream(), System.Text.Encoding.GetEncoding("utf-8"))Dim test As String = System.Text.RegularExpressions.Regex.Replace(reader.ReadToEnd, "<[^>]*>", "$1", System.Text.RegularExpressions.RegexOptions.IgnoreCase)
This may take some explaining but the concept is pretty simple. A user will select a file which contains data that they wish to extract from, so keeping it simple they pick a file like so:
[Code]....
So, I need to show the user the file, allow them to select a line to match and/or extract from. So they select the first line ready for a match, they then select a word/s to mark as a constant for matching, so in this case it would be: MyGroup A simple version for text match would be like "MyGroup *" Now, I need to convert this to regex dynamically (I assume its the best method), its not a one off, the data that is selected is all open and up to user selection. There could be multiple selections and multiple extractions on the same line!
[Code]....
give me a working regex expression (C#/VB.NET) that can remove single line comments from a SQL statement ?I mean these comments:
-- This is a comment
not those
/* this is a comment */
because I already can handle the star comments.I have a made a little parser that removes those comments when they are at the start of the line, but they can also be somewhere after code or worse, in a SQL-string 'hello --Test -- World' Those comments should also be removed (except those in a SQL string of course - if possible).Surprisingly I didn't got the regex working. I would have assumed the star comments to be more difficult, but actually, they aren't.
As per request, here my code to remove /**/-style comments (In order to have it ignore SQL-Style strings, you have to subsitute strings with a uniqueidentifier (i used 4 concated), then apply the comment-removal, then apply string-backsubstitution.
static string RemoveCstyleComments(string strInput)
{
string strPattern = @"/[*][wds]+[*]/";
//strPattern = @"/*.*?*/"; // Doesn't work
[code]....
I have been stumped on this for about 3 weeks now. In the beginning me and my partner have been trying to hit this at the internal angle. only problem is different html tables are constructed different than others. We are needing to extract from multiple pages and sites so we know that Regex will be the best solution. We can use the same script for everything. This is my first time working with Regex, I got it actually extracting the very first ip[proxy]. I have no idea why it isn't extracting every one on the page. I also have to add the . in between each each octave of the ip. That is weird because I have it in the Regexpession to find the .'s.What I'm Needing is for this to basically scan the whole page and grab all the ipsorts and add them to a listbox.Here is my
Dim request As HttpWebRequest = Nothing
Dim response As HttpWebResponse = Nothing
Try
[code].....
what i am trying to do is extract information beween two tags in some html from the source of a website. The contents of the text between the two tags will always be different. the code i currently have is;
[Code]...
I want to add the ability to spell check a few textbox fields on my form. I've seen a few thread on this forum regarding spell check, which works fine, but I also want that wavy red line under any misspelled words just like in Word.
View 3 RepliesI'm having a slight issue and I've been Googling for ~3 hours now but to no avail like my other 2 questions of which the answer was obvious.t will probably be obvious again.Anyway, I want to colour everything after the String 'text2' in RichTextBox1 until the end of the line.'ve been playing around with it a bit but I couldn't get it to work.
Sub:
Private Sub ChangeColourOfWord(ByVal wordRE As String, ByVal Colour As Color, ByVal wordRE2 As String, ByVal Colour2 As Color)
[code]......
im working with a receipt layout and trying to divide up a products descriptiontext into 2 lines if its longer then 24 characters.my first solution was something like this:
If Row.Description.Length >= 24 Then
TextToPrint &= Row.Description.Substring(0, 24) & " $100"
TextToPrint &= Row.Description.Substring(24) & vbNewLine
[code].....
how can I extract a certain words from a sentence input by user. For example, when a user enters "Jones born in 1965", the program will extract the words 'Jones, born, 1965' while eliminating the word 'in'.
View 2 RepliesHow do I read a line from a database using WHERE? I've read this post but it doesn't really cover it and the forum search throws out the words, 'From' and 'Where' as being common. This is my bit of code but it just skips over it as if it doesn't exist so presumably there's an error, I dunno. I'm trying to read an entire line from the database where it equals the value of 'getweek' where 'getweek' is a variable.
[Code]....
I need your help in creating a Regex for this. I want that the regex found are placed in an Array.
UPDATE tableName SET fieldA= @param1, fieldB =@param2,
fieldC = @param3 , fieldD=@param4
WHERE fieldE=@param5 and fieldF=@param2 and
fieldG = @param6
by using this Regex:
[Code]...
I have a gigantic text. In the aplication, i need words of 4 characters and delete the rest. The text is in spanish. So far, I can select 4 char length words but i still need to delete the rest.
This is my regular expression
s(w{3,3}[a-zA-ZáéíóúäëïöüñÑ])s
How can i get all words with 4 letters in asp.net vb?
I have a textbox with a large amount of data, but I am trying to extract only the following into an array: only 3 or 4 letter, uppercase words. The goal is to find all stock symbols within a document.
For example, in this post, if I were to type "MSFT", regex would extract MSFT because it is a 4 letter, uppercase word.
I use a single instance in my application. What if I give command line arguments to the exe of my program, so I can be selective in what was given command line in my program, but still single instance?
Example:
test.exe /show
When the command /show, then my program will
Form2.Show
Form2.BringToFront
I am trying to create a web-method to check whether a string contains a word which is in a list of 'not allowed' words. This list will be updated from time to time.
<System.Web.Services.WebMethod()> _
Public Function checkword(ByVal Id As String) As String
Dim returnValue As String = String.Empty
[Code]...
Something is wrong with this function. It verifies the first word of string. After that it doesn't return anything.
Im trying to extract ALL urls from a webpage in between two sets of strings.
I have the code to extract all links, but I am
href="http://www.blah.com/yadayada?tf=info"
Using regex; I want to grab everything between href=" and the quotation mark at the end .
This was a snipit I found that works for extracting in between 'href="' and </a>
HTML
Regex.Matches(data, "href=""(.*?)"".*?>(.*?)</a>")
I learn best by example, and I tried piecing it together by comparing the regex match above, to a URL in between hreft" and </a> - but I couldnt do it. Ive been working on this project for a while, and im getting tired.
how would i extract something like this....
CODE:
could possibly something like this work...
CODE:
I am stuck in a problem with an application. I have following lines of text :1) hi {my|your|his} name is {stacker|monster|overflow}2) hi {my|your|his} job can be to {stacker|monster|overflow}3) hi {my|your|his} car {stacker|monster|overflow}What I want :on the click of a button select and replace those words which do not have { or } just before or after the word i.e. in line 1 or 3 we do not have any such word. In line 2 we have "can" and "be".
View 1 RepliesI am trying to match words driven from a database in a string input using VB .NET
The syntax I am using is so simple:
[Code]...
I am trying to extract data from a string using Regex in VB.net This is my string CN=firstname lastname/OU=orgunit/O=org;shortname I am basically trying to retrieve firstname lastname (together),orgunit,org and shortname
View 1 RepliesI 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]...
How would I use Regex to extract the body from a html doc,taking into account that the html and body tags might be in uppercase, lowercase or might not exist?
View 3 RepliesI am parsing a file which contains customer address in the following 2 formats:
Format #1 12345 Melrose Place New York NY USA 12987
[Code]...
I need to put the data into Address, City, State and Zip fields. I am able to parse and put the data (specifically line 2) in the fields for format #1 but am having issues doing the same for format # 2 because format # 2 doesn't have USA as a reference point.
[Code]...
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 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 was able to extract href value of anchors in an html string. Now, what I want to achieve is extract the href value and replace this value with a new GUID. I need to return both the replaced html string and list of extracted href value and it's corresponding GUID.
My existing code is like:
Dim sPattern As String = "<a[^>]*hrefs*=s*((""(?<URL>[^""]*)"")|('(?<URL>[^']*)')|(?<URL>[^s]* ))"
[code]......
I have strings that look like this {/CSDC} CHOC SHELL DIP COLOR {17}
I need to extract the value in the first swirly brackets. In the above example it would be
/CSDC So far i have this code which is not working
[Code]...
a user copies multiple lines of text (say, from an email) into the clipboard. Based on my observations, when one tries to paste the text into a single-line textbox, only the first line is actually pasted in. (I am aware that the "obvious" solution would be to set the Multiline property to True, but there are reasons I am looking to avoid this and to put multi-line data into a single line.)
In the TextChanged event handler, I wrote code that parses the clipboard data to successfully convert it to a single-line, comma-delimited format.
Private Sub txtMassTrackingNo_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles txtMassTrackingNo.TextChanged
[Code].....
I am trying to extract everything between the body part as I am building a forum crawler
and since all the user posts are between the <body></body> I have chosen to experiment
with Regex. So far I have coded the following but sort of stuck on how to output the result say in a textbox? Also I am not sure if the body part of the regex is correct.
Dim URL As String = Textbox1.Text
Dim request As System.Net.HttpWebRequest = System.Net.HttpWebRequest.Create("URL")
Dim response As System.Net.HttpWebResponse = request.GetResponse
Dim streamReader As System.IO.StreamReader = New System.IO.StreamReader(response.GetResponseStream())
[Code] .....