I must admit it's been a few years since my RegEx class and since then, I have done little with them. So I turn to the brain power of SO. . . I have an Excel spreadsheet (2007) with some data. I want to search one of the columns for a pattern (here's the RegEx part). When I find a match I want to copy a portion of the found match to another column in the same row.
[Code]...
G:DevelopmentDOT NET DevColony_4ImagesBattenhallAve_Plan.bmpand i want to find and return the value after the last '' for example in the string above i would want to return:BattenhallAve_Plan.bmp
View 5 RepliesI'm working on a program that gets some info about a certain web page. But one of the features is it needs to find all the links to other webpages on THE SAME site (I think its called an internal link... not sure). I already figured out how to get the page's HTML code, now i just need to know how to find stuff like "" in the HTML code then output me [URL]
View 4 RepliesI'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've got a string which could or could not contain the substring "/announce". I would like to replace this part of the string with "/scrape" if its found...so far nothing tricky. But heres the thing: I only want to replace it if the '/' in it is the last occurring in the string. Heres what I mean:
Heres a scenario where I want the replace to happen:
MyStringWithRandomText/announce?x=19
would become:
MyStringWithRandomText/scrape?x=19
And heres another scenario where the '/' in announce is not the last '/' occuring in the string, so I dont want to replace it:
MyStringWithRandomText/announce/foo?x=19
I hope that made sense. Not sure if there is a way to handle this by only using RegEx
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.
The following code in C# gives result "228452386"
UInt32 a;
int k = 0;
a = 0x9E3779B9;
a += (UInt32)(url[k + 0] + (url[k + 1] << 8) + (url[k + 2] << 16) + (url[k + 3] << 24));
After above code is ran, "a" contains "228452386" But the following same code in VB.Net results in "Arithmetic operation resulted in an overflow". Basically the last statement is returning value "1868983913" so the runtime error is generated.
Dim a As UInt32
Dim k As Integer = 0
a = &H9E3779B9UI
a += CUInt(AscW(url(k + 0)) + (AscW(url(k + 1)) << 8) + (AscW(url(k + 2)) << 16) + (AscW(url(k + 3)) << 24))
note the variable "url" in above code could be any string and it is same for both codes.
EDIT:When I run the following statements in both C# and VB.Net than they both return same value
C#
(UInt32)(url[k + 0] + (url[k + 1] << 8) + (url[k + 2] << 16) + (url[k + 3] << 24))
VB.Net
CUInt(AscW(url(k + 0)) + (AscW(url(k + 1)) << 8) + (AscW(url(k + 2)) << 16) + (AscW(url(k + 3)) << 24))
Both statements return value "1868983913" for "url" "info:microsoft.com". But when I run complete statement with a += ..then VB.Net gives error while C# returns value "228452386".
VB.NET Code:
Module Module1
Sub Main()
Dim x, y As Single
x = 0 + (512 / 2 - 407) / 256 * 192 * -1
[code].....
returns 0: 0
i got two forms
form1 (frmUserDetails)
form2 (frmSearchForm)
when i click the search button in form1, form2 appears.
i get the information i want from form 2 and store it in a variable.
when i close form2 and form1 is active again i want this code to run automatically:
[Code]...
I been trying to create a database of files. I wanted to list the Titles and Authors of the files.
How can this be done?
i got two forms
form1 (frmUserDetails)
form2 (frmSearchForm)
when i click the search button in form1, form2 appears.i get the information i want from form 2 and store it in a variable.when i close form2 and form1 is active again i want this code to run automatically:
Me.userIDsearch = frmUserSearch.NuNameTB
Try
'TODO: This line of code loads data into the 'SoftwareLookupDataSet.tbl_software' table. You can move, or remove it, as needed.
Me.Tbl_softwareTableAdapter.Fill(Me.SoftwareLookupDataSet.tbl_software)
[code]....
how would i get the above code to run when the focus is back on form1?
I have a asp.net mvc route that is taking a url and doing a simple get and return the status code from the request.
<AcceptVerbs(HttpVerbs.Post)> _
Public Function ValidateUrlStatusCode(ByVal url As String) As ActionResult
Dim code As Integer = 0
[Code]....
Now if I use firefox (using Firebug) and go to the url http://www.facebook.com/blah.html, I get the expected 404 returned. However if I use my application to call the mvc route via an ajax call, I get 200. If I set the request object's AllowAutoRedirect to false, I get 302. I never get a 404. I am verifying this once again through Firebug.
I have a asp.net mvc route that is taking a url and doing a simple get and return the status code from the request.
<AcceptVerbs(HttpVerbs.Post)> _
Public Function ValidateUrlStatusCode(ByVal url As String) As ActionResult
Dim code As Integer = 0
[code].....
Me.pass = Conversions.ToString(CDbl((((Conversions.ToDouble((4 & 3)) - Conversions.ToDouble(4)) + (Conversions.ToDouble(2) * Conversions.ToDouble(1))) / Conversions.ToDouble(2))))
[code].....
I've been looking for a code example that would run through the Erlang B formula, but the only thing I can find are commercial packages.
View 8 RepliesI am working on a little small 10 question quiz. The quiz is just for fun for a work thing I'm doing. I'm using VB.net. I'd like to put in one of the questions something like "what's your favorite baseball team?" Then list 3 radio buttons for 3 possible answers. But I'd like to make 2 of the radio buttons move away when a person tries to mouse over it to click on it. So only the answer I want them to use would be possible. I can creat it all but the code to make the raido buttons move when moused over. I've been searching but having trouble finding anything on how to do this.
I don't have my actual quiz code in front of me. But can post the form code for that question later tonight when I get home if needed. But the form is very basic. just has the question in a lable, Then the 3 answers below it as radio buttons. I have a next button that goes to the next form and closes the previous one, and an exit button that closes down the whole application.
I have written a short piece of code to validate a UK NI number. The format is 2 upper case letters, followed by 6 digits followed by A,B, C or D. This code does not work, it never matches even when the string NI_Num is OK: [code]
View 2 RepliesI am using the tutorial laid out here http://www.androidsnippets.com/vbnet-server-side-code-to-send-c2dm-messages to attempt to send a message to my device. I have requested a device ID and placed that string in the RegID String.I receive a (what looks like a) GUID for the googleAuthToken successfully, but when the rest of the code executes,the response I get is Error= MissingRegistration. What exactly am I missing to implement C2DM from a server via VB.NET?
View 1 RepliesHere the code behind... I'm trying to retrieve this control so I can add items to the drop down list (I'm retrieving the Role Groups to add to the drop down list in the code-behind)
Protected Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DDRoleGroups As DropDownList
[code].....
I am trying to write a VB function to strip unwanted characters from a string. It is for generating a 'clean' url from data that has been inputted into a CMS. Someone has copied and pasted from a Word document and so there appears to be an mdash or ndash in the product title. This results in ─ appearing instead of -
I have tried a Replace(text, Chr(196), Chr(45)) but it isn't working so it can't be 196. Is there a tool or something where I can copy this character and paste it into the tool and it will tell me what char code it is?
I have a vb.net / ado.net application for distributors that queries a sql server db, converts the records to tab delimited text format file. After building the file, the user goes to the website of the manufacturer, logs in to a private area and uploads the txt file.
I would like to add a function to my vb.net code that would launch a browser in a form, load the manufacturer's login screen, load the user id, password and then let the user log in by clicking the login button. Then when the next page loads, I'd like to have the text file I just created pop into the web page text box for file name, choose a couple of radio button options properly and then let the user click the submit button.
wrote a program with Regex condition but it shows me Twice the first condition (<H1>Welcome to my Homepage</H1>)what is my problem?i enable multiline property of Textbox1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim l As New Regex("<(H1|H2)>.*?</(H1|H2)>")
[code].....
what would the regEX code be for the following:
<br/><span class=""synopsis-view-synopsis"">America's justice system comes under indictment in director <a href='/people/1035' class='actor' style='font-weight:bold'>Norman Jewison</a>'s trenchant film starring <a href='/people/1028'
[code].....
I am using winform RichTextBox and I wonder if we can find the corresponding rtf code (or at least whereabouts of it) when selecting text?
View 1 RepliesI have the following code for finding factorials:
Private Shared Function Factorial(ByVal Number As Long) As Long
If Number = 0 Then
Return 1
Else
Return Number * Factorial(Number - 1)
End If
End Function
It usually results in an overflow. It only works if I start with something small like 4. I have to work with starting numbers such as 30-60. I thought changing the value type to LONG would prevent this problem. This is VB.net just for reference.
There may be times when it would be useful for your code to be able to find and close modal dialogs displayed by an application. Perhaps you do not want to have to wait indefinitely for your user's input, or are using the COM Web browser control to automatically navigate Web page and would like to interactively close alert messages that pop up.Digging into our Interop toolbox, we find that this is a relatively simple process using a few core Win32API calls. Starting with the handle of the main window associated with the dialog (this is the form from which the messagebox was shown, whether from your code or from a Web page hosted in a Web browser control on the form), the GetWindow function can be used to retrieve a handle to a dialog windows (called a popup by the Windows API) being displayed (if any). The same function can then be used to enumerate the child windows of the dialog to find a button on the dialog to click in order to close it, and the SendMessage API function can be used to simulate that click, effectlvely closing the dialog window.
NOTE: At the top of whatever code file you put this code, be sure to include the following line (thanks poiygon for pointing this out):Code:Imports System.Runtime.InteropServices this allows for the shortcuts to the DllImport attributes.[code]This sample can be easily modified to close a dialog in another application (by using the MainWindowHandle of that application in the LookForAndCloseIEPopup function, instead of "Me.Handle") or to close any other type of modal dialog message being displayed to your user.
I need to find .MP3 format URLS in a HTML source code.So how could i do that?Lets say i have:
Dim wcClient As New System.Net.WebClient
Dim data As System.IO.Stream = wcClient.OpenRead(inbox.ToString)
Dim reader As System.IO.StreamReader = New System.IO.StreamReader(data)
reader = reader.ReadToEnd()
reader.Close()
so how could i find all the .MP3 urls which are in the source code?
I've found some examples using RegEx but im not really sure how to use the RegEx pattern to find MP3 urls in the source 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 looking for sample code for vb.net Dynamic Dashboard applications? i want the code in vb.net which will be my front end and sql will be my back end for database?
View 2 RepliesYes, I've googled. But I must defer to the experts as time to study Regex is not available.
[Code]...
Can these 3 lines be condensed into one line? If so, how? The purpose is to remove all spaces before and after all occurrences of & in a string.