I'm working in a program that reads sms from phone I have messages like "You have successfully transferred 100.00 EGP to 20119845844Balance 7555.00Transaction: 4620439" Stord in a string So I need to search the message for the numbers 100.00 , 20119845844 , 7555.0 and 4620439 and it's sure changed every message so the how to search for this Numbers and add every one in variable to use every number of them alone?
View 7 RepliesI'm using SQL as a database in VB 2010, I already add a table to my form as a datagrid view but I don't know how to add buttons for filtering, deleting and adding things in my table, for example I want to have one button on my form call it search button to search in table names or Phone Numbers. how can I do that and where shall I write the code?
View 3 Repliesi have wrote a loop to search for duplicate numbers within a column in a database which i have got fine but when i find a duplicate i would like to get the all of the row so if 33 was a duplicate i would like to get the following row.
33MarkWhitesideM12/07/1958Michaeluuu
I have tried to do this buy use something i saw on msnd's website:
Dim foundRow() As Data.DataRow = customerDS.Tables("Details").Select("HNCNO Like '33%'")
However if i change the line to notice the i beside the like
Dim foundRow() As Data.DataRow = customerDS.Tables("Details").Select("HNCNO Like 'i%'")
but i get Index was outside the bounds of the array. Ok i know that means that there is nothing in my array. What i would like is to find the duplicate row associated i. you will probably understand me better when you see the code.
Private Sub checkRowsForDups()
Dim customerDS As DataSet
Dim dupArray As New ArrayList
[Code].....
Scenero: Users inputs the barcode numbers into a textbox, hits the search button and is returned the description of that barcode.
Database:
Two fields: Barcode - barcodes in this field
Description - Description revalant to that barcode
Form:
Consists: Textbox(Input) - txtBarcode
Button(Process) -btnClick
Listbox(Outut) - lstDetails
Code:
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
[CODE]...
This is the code i got to connect to the database itself. Then i got this code for the search part
Code:
SQL = "SELECT Description FROM Table1 where Barcode = '" & txtBarcode.text & "'"
What i need to know is:
1) Is the code for the search right.
2) How to get it so the description for that barcode is displayed in a listbox.
The string itself contains things like "random" & random.next(1,3) & "random2" etc. The string registers all of this as a string and doesn't actually calculate random numbers.Is there any way to fix this?
View 8 RepliesI'm having a problem converting a string of letters to a string of numbers. I've tried:
Dim A As String = ""
Dim strOutput As String = ""
Dim X As Integer = 0
[Code].....
how can I search a textbox for a string within a string and if certain word (string) found enable a timer?
View 3 RepliesI have written a program that uses an array of the english alphabet and Morse code. I also built a form with a input box for the alphabetic information and an output box with the Morse Code. What i am trying to do is basically type a word like "Hi" in the input box and produce the Morse Code equivalent in the Morse Code output box. [Code] This works but only one letter at a time. Do i need to Parse the string of characters one at a time, and then run it through a loop like i have created?
View 6 RepliesI have a non standard text file, ie its not delimted etc, its pretty much free flowing. What I want to do is to search for a specifc string eg. "xyz123" and then replace it with what a user types into a text box, lets call the text box and its contents "txtreplace".
I am trying to replicate a find and replace function essentially, but will need to tailor it later on down the line, but this will be a starting point.
I need a code that can allow the login form to search for pin number stored in another form example when a customer enters the pin number and clicks ok button the login form searches if the pin number exists in the bank details form
View 7 RepliesI know you can just use integer.parse to convert a string to a integer, but I need something else.I have a String like this:
001010000000101
Now what I need to do is place al those digits in a array like this:
Dim example() As Integer = {0,0,1,0,1,0,0,0,0,0,0,0,1,0,1}
What I am doing now is this:
Dim text As String = "001010000000101"
Dim collection(15) As Integer = Nothing
For i = 0 To text.Length - 1
[code]....
i do have a medium knowledge of Python, HTML/CSS. I am working on my first basic program. a simple calculator. Buttons representing numbers 0-9 Buttons with + - x / = and a clear button.
So what ive done is created a string, and when the user hits the button, it adds that value to the string (hit buton 4, it adds a 4, hit the minus, it adds a -)
i need a "function" that grabs that string, uses logical math on it, to determine the answer. I know in Python you can use: Eval(STRING NAME)is there an equivelant for VB?
I need a vb function to determine the last numerical characters in a string. For example, if the string is Step1, I need it to return 1. If the string is Step32, I need it to return 32.I'm aware of the string functions like Right, Instr, etc but I'm just not sure how to get what I need
View 1 RepliesI'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 Repliesi need a vb8 code to open a txt file,search for a string in it & extract string in a excel file.
View 2 RepliesDim number As String = "07747(a)" If number.... Then endif I want to be able to check inside the string to see if it only has number, if it does only contain numbers then run whatever is inside the if statment? What check do i use to check if the string only contains numeric and no alpha ot () etc ..? What i am trying to check for is mobile numbers, so 077 234 211 should be accepted, but other alphas should not be
View 3 RepliesI included all the code this time. In calculate click event the value is zero and I don.t understand where I went wrong. My work is due tomorrow, if anyone can tell me why I can not extract the price from the string. What this program is doing is taking items from the stockListBox and adding them to the shoppingList Box then extracting the price from the shoppingListBox and adding the prices together.
0
Public Class SupplyCalculator
Dim lists As String = "staple" & "stapler" & "folder" & "notebook" & "pencil" & "eraser" & "pen" & _
[Code].....
This is my second post on this topic. I included all the code this time. In calculate click event the value is zero and I don't understand where I went wrong. My work is due tomorrow, if anyone can tell me why I can not extract the price from the string. What this program is doing is taking items from the stockListBox and adding them to the shoppingList Box then extracting the price from the shoppingListBox and adding the prices together.t a note- in public class I changed the string and seperated the price from the item, not sure if I was suppose to do that.lso, everything works except the calculate event.
0
Public Class SupplyCalculator
Dim lists As String = "staple" & "stapler" & "folder" & "notebook" & "pencil" & "eraser" &
[code].....
Can I have a List containing one string and two numbers? Or I can only have one type of element?
View 3 RepliesHow can you remove number from a sting. The numbers could be anywhere in the sting and they could be any combination of numbers but would be together in the string. Ie abcdefg321hijk....
View 4 RepliesOkay, so I know now how to replace vowels in a string. Is there any way I can use the Select Case similar to the code below to replace all numbers into letter Z.
[Code]...
i want to reverse some string with numbers how to reverse it
ex: "ABC 123" --> "123 CBA"
or
"ABC 123 DE" --> "DE 123 CBA"
reverse string without the numbers
I currently have a string like MondayJohnsRoom1130D I want to split this up so I have Monday - Day of the week JohnsRoom - Room name 1130 - Time D - Means Daily I get given this format from another computer, the room name can vary in size but the last leter D will always be one letter and the time 4 characters.... HOw can I split this up?
View 19 RepliesI am trying to parse the digits to store in a variable from a string in VB.NET (would like to also include the decimal point).
Here is an example string: Refund issued for $27.74
I need to give comma(,) for every thousends. So I used DataFormatString="${0:#,#}". It is working fine. But when value is 0. It is showing $00. I just want to show only $0.
How can we do that?
I am trying to extract numbers from string text. e.g. 1 day (8 hours)' I need the one and the eight integers pulled out I would like to extract then store each number separately for use later. I am aware of techniques to count string text, but not pulling certain information from it.
View 7 RepliesI used a regular expression, which handles both numbers and letters in strings of arbitrary length, in one line of code.
dim rtn as String = Regex.Replace(input, "..", "$& ")
I'd like to take numeric strings of arbitrary length and insert a space every 2 characters.
So 1233456 becomes 12 33 45 6. Is there a way I can use format as string or IFormatProvider, like? That would put a limit on how long the string could be though, right? Since I'm casting to a long.
CLng((input)).ToString("## ")
I'd like to take strings of arbitrary length and insert a space every 2 characters.
123dssas4rr should become 12 3d ss as 4r r
I like to know to split a string value from a mixed value.[code]Now the result will be "Check".Is there any short ideas?
View 1 RepliesI have a program that throws out a string of six numbers from 1 to 37, what I need to do is check the the string for for a format you could say.I need to make sure the set of six numbers doesn't contain 4 or more numbers of the same numbers from the same set of ten(s).
Like this:I can't have: 1-3-6-7-8-12 Or 12-14-16-18-20-21 Or 21-23-26-28-30-31 Or 30-32-34-36-20-22
I can have : 1-3-6-12-17-23
////////////: 12-14-16-20-21-22
////////////: 20-1-13-23-26-30
////////////: 1-37-22-33-30-9
[Code]...
i have a number in this format: 123 and I want a select statement such as below for comparsion so i dont have as many if statements:
Select case numbers(i)
case is = "123"
case is = "234"
example but in real scenario numbers are random.
Heres my code in which all select cases dont get fired:
Public Function UserAdd() As String
On Error GoTo Errorhandler
Dim personcount As Integer
[Code]....
But the case is statements above dont fire when I know that number is correct above