I have 2 strings:
"This is number 123456789"
"This is number 123456"
I want to match the last number "123456" and replace this. Not the first number because the length is > 6 digits. I have this regex "d{6}" but then he will match the first number also.
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?
I got most part correctly but the only part isnt working right is when the last 5th digit match the sum number at the last number.
Private Sub btnVerify_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnVerify.Click
Dim strCardNum As String
Dim strSumNum As String
[CODE]...
I have a txtbox(for barcode).. if i input a item number in that txtbox and if that number will match in your database, the other information(shall we say, product type, item ID, etc..) will display in my other txtboxes..
View 5 RepliesI am trying to create a lotto simulation, but don't know how to continue.I am using numericupdowns to allow users to select 6 lotto numbers. and labels to display what they have chosen, but i'm not sure how to prevent duplicates without creating a large number of If statementsMy question is, is there an easier way to prevent duplicates without writing a bunch of if statements?here is my code:
Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Lotto1, Lotto2, Lotto3, Lotto4, Lotto5, Lotto6 As Single Lotto1 = Val(NumericUpDown1.Text) lblLotto1.Text = Lotto1 Lotto2 = Val(NumericUpDown2.Text) lblLotto2.Text = Lotto2 Lotto3 = Val(NumericUpDown3.Text)
[code]....
I don't understand how to save the user selected numbers, let the computer generate 6 random numbers, and match the two sets of numbers together to see how many matches there are. As far as I understand the numbers should be stored in 2 separate arrays and then matched together to find any matches.
I'm wanting to search a RTB for all X coordinate values and convert them to SI mm units.
I have two issues: 1. My code is stopping after the first instance of match.success, I'm guessing i'm using nextmatch incorrectly? I have also tried matchcollections with no success.
2. I fear once we get it progressing to the next X value, any multiple X values with the same dimension will be replaced with my replace command, causing the new value to be converted again.
Dim MatchObj As Match = Regex.Match(RichTextBox1.Text, "[Xx](?<X>(d*.{1,1}d{1,4}))(s)*")
If MatchObj.Success Then
[Code]....
I'm trying to replace a string with another but the problem is that the string is matching some other string partially.
For e.g. -
Dim x as String = "I am Soham"
x = x.Replace("am","xx")
After this replace I would only like the word am to replaced with xx but because my name also contains am its also getting replaced.
I have created a basic query generator which allows a user to select the Select, WHERE and criteria attributes using a number of checkboxes.However i have got stuck. In the results form i have the following code
Private Sub DisplayRecord()
RichTextBox1.Text = ds.Tables("newResults").Rows(intCurrentRecord).Item(0)
RichTextBox2.Text = ds.Tables("newResults").Rows(intCurrentRecord).Item(1)
RichTextBox3.Text = ds.Tables("newResults").Rows(intCurrentRecord).Item(2)
[code]....
The program keeps on crashing if the user does not select the corresponding amount of display records from above for the amount of attributes they want for the SELECT part of the query in the intreface in form 1.
How would i go about making something where the number of SELECT attributes selected which are listed in a string create the correct number of textbox fields in the results form (form2)
my textbox will shows a random number some time it match, some time it don't. for example: my textbox is displaying "56" and my listview was added "11" instead of "56".here is my code...
TextBox1.Invoke(New Action(Of Integer)(AddressOf UpdateTextBox), CurrentNumber)
1 <span class='Txt9Gray'>Decisions ( </span> I'm trying to grab the '1' from this string. Before the '1' is another span, but I can't use that as a marker because it can change from page to page. Is there any regex expression that can simply grab the '1'.
The word 'Decisions' will always exist. That's my main way to find this line. Here's what I have been trying to no avail:
[Code]...
Is it possible to write an SQL statement for MySQL which finds all rows which match a specific arrangement of letters/numbers without using REGEXP? i.e. SELECT myCol FROM myTable WHERE myCol='{number}{number}{letter}'Should return 12X and 34Y but not 123X or 34YY..SQL match on letter and number arrangement). The difference is that I have discovered that I cannot use regular expressions with the ADO.Net driver I am using. Whatsmore, I cannot update it since I am using Visual Studio 2003 which is not compatible with later versions.]
View 8 RepliesI 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 have a form in an application that I'm building that shows a datagridview with the last field being a checkbox. What I'm attempting to do is if the user clicks on the checkbox and then clicking on "Save Changes" all of the fields on that datagridview row (except the first field) is then saved to a database. I have the following [Code] The error I keep getting is "Insert Error: Column name or number of supplied values does not match table definition.".
View 5 RepliesI'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 have a form in an application that I'm building that shows a datagridview with the last field being a checkbox. What I'm attempting to do is if the user clicks on the checkbox and then clicking on "Save Changes" all of the fields on that datagridview row (except the first field) is then saved to a database. I have the following
Private Sub holidaysaveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles holidaysaveButton.Click
For Each dr As DataGridViewRow In DataGridView1.Rows
[Code].....
I need to count the number of records that match on the GIDs from the 'Directories' table (GID) and the 'ClientSubscriptions' table (DirectoryGID), and also the 'FranchiseGID' from both; as follows:
Dim iSubscriptionCount
SQLCommand = "SELECT COUNT(*) AS Counter FROM Directories.GID, ClientSubscriptons.DirectoryGID FROM Directories, ClientSubscriptons WHERE Directories.GID = ClientSubscriptons.DirectoryGID;"
[CODE]...
I need to determine whether or not to show a menu option based on the above.
Full Code: Default.asp
<!--#include virtual="/System/Startup_Admin.asp"-->
<!--#include virtual="/Admin/FranchiseAdmin/DirectorySetup/i_Directory.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
[CODE]....
"_anim(d+)$"
Ok, with that, I can check for any string that has the _anim suffix alright.
But I need to get the value inside the parenthesis (which I expect to be an integer). And I will also need to get the value before the _anim prefix (which I expect to be a string).
That is what I don't get: how do it "get" values, instead of just "knowing" there was a match?
I have users check off lab facilities in a UI. I want to use linq to fetch corresponding records for all of the labs that they have checked off. Basically,
Dim myRecs = (From l As EpiData In myDataContext.EPIDatas Where l.facility= _
one of the checked labs
So basically, I need to write a linq query where the "strings" to match are determined at runtime. Is there any way to do this easily? I know that there is a library out there called dynamic LINQ, but (1) it's in C# and I'm writing in VB (2) I'm really just looking for a single, simple solution for this single case.
For the past 2 days i have been trying to come up with a simple solution for this problem, but i have turned up nothing so far.[code]What i am thinking now, is if there was a way to get the "name" and "value" field with the 1 regular expression, instead of having to do the 2, would that be possible?
View 4 RepliesBeen at this for ages now experimenting different ways to do this, i have fields in my html file that look like:[code]is it possible for me to get both the numeric values 18621335 and the username graham23s in the same regular expression?
View 1 RepliesI've been looking at this for a while and I'm stumped. I'm under the impression that if I use strOpass = strOpass.Replace(":d", "Z") that I should be seeing any numbers that a user inputs the code line there will return a Z. It's not working and I don't understandI've also tried "[0 - 9]" and :z, but the program is still returning the original input.B is not giving me a hard time over that line ( no errors or warnings. ) The other statements work just fine and return a X just like they should. Here is the entire block of code:
Private Sub btnDisplay_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
Dim strOpass As String
[code]......
My problem is to extract some specific string from the web script by RegExp, e.g:
1. <TD title="ABC - SDC">Home Furniture</TD>
- I want to extract "Home Furniture" from here.
2. <TD><INPUT class=ID="( 8352623 ) Demark" value="( 8352623 ) Demark"></TD></TR><!-- <tr> -->
- I want to extract "8352623" from here, can be any of them.
How can I write a RegExp to match them?
And I am getting one solution but work out in C#, obviously it's not working in VB, so anyone does me a favor to translate them in VB structure...
string pattern1 = @"<([tT][dD])[^>]*>(?<between>.*)(?=</1>)";
string test1 = @"<TD title=""ABC - SDC"">Home Furniture</TD>";
if (Regex.IsMatch(test1, pattern1))
[Code]....
The original string is like this: sLine = " 1 Screen"
What I want is this: sLine = "000001 Screen" (I do want to keep the space between the number and the text, so that is why its not just a replace) What I see with the following code is this: sLine = "01 Screen" Some how the replace does the first char, but then is not adding the zeros to the rest of the string, its just removing them (somehow I think it must think integer? [Code]
I have 10 lines of array that are first name space last name space zip code. All the zip codes start with different numbers. Is there a way to replace the #1 in the indexof below so that it searches for any number character instead?
'open file
inFile = IO.File.OpenText("Names.txt")
'process the loop instruct until end of file
intSubscript = 0
[code].....
In a project I'm working on, I've assigned each user a unique ID with the following code. [code] However, I want to replace the number at the end (RecordCount) with a randomly generated sequence of 4 numbers (no 2 can be the same).
View 3 RepliesAm trying to match characters or combination of the characters i specify in any order they appears
vb
Regex.IsMatch(teststring "[nuls]")
what i want matched is either any single character, or combination of any of them in any oder. this means that it should not match any character not specified in the pattern.
For example
it should match
n,u,l,s,nu,un,lun, sl etc
not
ny, nx so etc or any other
A
/n
/n
/n
.
.
B
Now there can be n no of lines between a and b have to find such content and remove A and B
The file reads in parameters and two of the parameters used to be in Date Format YYYYMMDD but will now permanently be in format YYYY-MM-DD. This change, I believe, is stopping the import of the file from working. I would like to replace the new format YYYY-MM-DD back to YYYYMMDD in the code. If possible I'd also like to see some output so I know that the old format has been replaced with the new format. The code is below. I added the two rows with .replace code in green in expecting that to be enough but it is still not working.
Public
Sub Main()
Dim R1, O1, P1, C1, strDateFrom, strDateTo, strRunDate
As
String
[CODE]...
I'm working on a timekeeping application in Visual Basic 2008 and am having trouble formatting a timespan for display. Here's how I want to the information:If a positive number my Label will be: lblTimespan.txt will show as "12 Hours And 15 Minutes" This works fine.If its a negative number I want to display it as "(12 Hours And 15 Minutes)'[ in red. The problem is that I can't get rid of the minus sign. [code] Thr Replace doesn't seem to want to replace the "-", can anyone suggest what to do?
View 2 RepliesI have a bunch of object variables which are all initialised in their declarations such that:
Private _myObject As New ThisObject("SomeString")
where ThisObject is one of a number of object types, but all are initialised using a string.
I would like to use the Visual Studio Find/Replace dialog box to search for "As New" then replace everything from "As New" to the first set of speech marks with some text such that:
EDIT
My original example could be solved using other methods. This example is more representative of the actual problem:
Private _myObjectA As New ThisObjectA("SomeString")
Private _myObjectLongName As New ThisObjectLongName("SomeString")
[Code]....