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 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?
I need to use RegEx.Replace to replace only certain named groups in my input string.
So I might have a pattern like:
"^(?<NoReplace>.+)(?<FirstPeriod>(d{2})|CM|RM|PM|CN|RN){1}(?<LastPeriod>(d{2})|CM|RM|PM|CN|RN){1}((#(?<NumberFormat>[#,.+-%0]+))*)$"
Tokens such as CM, RM are being replaced using Regex.Replace with a MatchEvaluator. However, this should only be replacing characters in the FirstPeriod and LastPeriod groups.
Example input:
"FIELDCNS 01CM"
Desired output:
[Code]....
Is this possible or am I best just pulling out the parts I want to replace and re-assembling afterwards?
I am trying to think of a regex replace to replace double quotes with nothing. Example:
hello("hi there") would become hello(hi there)
"hi" would become hi
"example "3" would become example "3
-edit Maybe an easier way to explain this is, replace all " that do not have a backslash before them.
I'm creating a program in VB.NET to output multiple images. Some images will have the same file name. If there is multiple files with the same name I want to add "_1_" to the end of the file name. If the "_1_" file already exists I want to increment the 1 to be "_2_". If this file already exists I want to continue incrementing the number ultil it doesn't exist. So for example "filename", filename_1_", "filename_2_", etc. Here is the code that I have tried
[Code]...
I am trying to filter out all unwanted characters from a string. All I want in the string is letters A-Z, numbers 0-9 as well as comma (,) plus (+) and quotes (").I figured how to do the letters and numbers, but the 3 special characters are giving me a problem. I also tried with the Chr(34) equivelant for the " sign, but no luck, as and " or , messes up the way the code is read. Here�s what I have so far, but it only works for A-Z and 0-9:
STR = System.Text.RegularExpressions.Regex.Replace(STR, "[^A-Z, 0-9, Chr(43) ]", "")
Say I have this list (with unknown delimiters):
ABC-12345, DEF-34567; WER-12312
ERT-23423
I know the regex to mach what I need is: [A-ZÆØÅ]{3}-d{5}. But how do I use the Group or Capture of the .net Match class?
This is my first attempt:
Public Function ParseSites(ByVal txt As String) As List(Of String)
Const SiteIdRegEx = "([A-ZÆØÅ]{3}-d{5})"
Dim list As New List(Of String)
[Code].....
(<td [^>]+>
ss|[^, ]<a href=""http://www.test.com/member.php?action=profile[^>]+>(<span [^>]+><strong>|<span [^>]+>|))[^<]+(<span [^>]+>|</strong></span></a>|</a>|</span></a>)
How do i turn that into a capture group so it only gets the text that is bold and removes the rest?Also how do i loop through all the result from that captured group text?
may i know how to extract "+ from a group of Substring? i tried the indexof method like i1 = s1.IndexOf(" "" ") but its giving me error probably because the compiler thought its unclosed clause.
I am trying to grab the "+ from the string : +CMGL: 1,"REC READ","+6596231118",,"09/08/13,00:17:11+32"Fire alert So this will actually grab the string starting from the "+ and including the handphone number until the next" , like this +6596231118 I have tried the substring method but it wont work because of the memory location over at the +cmgl.
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'm using this code
[Code]...
I need it to match both 12345 (5 char zip) and 12345-1234 (10 char zip) in 1 single group. Is that possible?
[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 have the following text that I am trying to parse:
"user1@emailaddy1.com" <user1@emailaddy1.com>, "Jane Doe" <jane.doe@ addyB.org>,
"joe@company.net" <joe@company.net>
I am using the following code to try and split up the string:
Dim groups As GroupCollection
Dim matches As MatchCollection
Dim regexp1 As New Regex("""(.*)"" <(.*)>")
matches = regexp1 .Matches(toNode.InnerText)
For Each match As Match In matches
groups = match.Groups
message.CompanyName = groups(1).Value
message.CompanyEmail = groups(2).Value
Next
But this regular expression is greedy and is grabbing the entire string up to the last quote after "joe@company.net". I'm having a hard time putting together an expression that will group this string into the two groups I'm looking for: Name (in the quotes) and E-Mail (in the angle brackets).
We are using Exchange 2003 as part of sbs 2003 premium.
We have a distribution group abc which receives emails abc@mydomian.com. How can I access emails coming to this distribution group and extract any PDF attachments that may be present using vb.net 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)
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]...
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].....
I'm using the following VB.net Code to find phone numbers in HTML and make them "clickable":
Regex.Replace(pDisp.Document.Body.innerHTML, "([0-9+ ]{3,6}[s]{1,1}[0123456789 -/]{4,15})", "<a href=http://DIAL/$1>$1</a>")
There appears an issue if the numbers contain white spaces, for example:
089 12233 455
This will be replaced with:
<a href=http://DIAL/089 12233 455>089 12233 455</a>
Is there a way to get
<a href=http://DIAL/08912233455>089 12233 455</a>
instead?
How can I convert [b]xxx[/b] to <strong>xxx</strong> using VB.NET Regex.Replace()?
View 2 RepliesI have a text file like this
4.5 28 Red (T1 ) [1 12.86 53.8] 229111 -28275 198452 -1309 | 11.0 28 Red (2 13.10 04.0) [T1 ] 130611 2948 229111 28275
1.5 28 Blue (T2 ) [1 07.06 59.1] 191611 51225 190456 39339 |
[code].....
I am trying to replace text in my xsl file. I have to replace all the http and https. But I can leave any links that start with <a href>
Ie; http://www.google.com has to replaced. But < a href="google.com">google.com</a> has to remain as it is.
I am using regex to find all the http(s) and a hrefs in the text. I am struck here.
My code is,
Dim href As New Regex("(<a.*?>.*?</a>)", RegexOptions.IgnoreCase)
Dim hrefs As New Regex("http(s)?://([w+?.w+])+([a-zA-Z0-9~!@#$\%^&*()_-=+\/?.:;',]*)?", RegexOptions.IgnoreCase)
[Code].....
I am trying to use Regex.Replace to replace my https. But I am unable to write the evaluate function.
My regex.replace replaces all the values with a single value.
System.Text.RegularExpressions.Regex.Replace(item.Summary.Text, ????, "")
What would I put in the? to get only the domain from a URL: EG [URL] should turn into "Google".
I don't know how the regex works to make it do that. Would it be like "*/*..*" or something?
Dim ab As String = "aaaextBox1.Text = Regex.Replace(TextBox1.Text, "Dim " + ab + " As String", "aab")That is the code I am using now. Problem is that it's output is only "aab".Is there any way to keep the structure, so it would be "Dim aab As String" instead of only "aab"?
View 2 RepliesI'm trying to find a way where i can make it loop through the results of my capture group regex query.
For instance if i have this:
VB.NET
Dim matches = Regex.Matches("<h1><span>test</span></h1>", "(?<=<h1>(<span>)?)(?<data>.+)(?=(</span>)?</h1>)")For Each item In matches.OfType(Of Match)()Console.WriteLine(item.Value)Next
And i'm trying to get the contents of <data>, how do i do it without it printing out the junk before it and after it?
quantifier isn't working, its supposed to make the <span> tag optional in the query, but it isn't.
I'm developing Asset Management System, it will compute for straight line depreciation, my problem is how to calculate running total on each group that I've extracted from my database.Here's a snippet for my extraction of data
Private Sub cboAType_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAType.SelectedIndexChanged
ListView1.Items.Clear()
If Not cboAType.Text = "-" Then
[code]....