I am using a collection to store data from a text file which I am letting the user load and I am using the .split to split and sort the data into alphabetical order and remove repeating words.However, I am having a problem removing unwanted characters from the final array. For Example, "This is the text file that I want sorted. It is random text not yet sorted"
View 6 Replies
I have developed a VB .net application which uses SQL CE as its database engine. It works great so far. I recently added a section to remove unwanted reports which are stored in the database. The app correctly pulls ReportIDs from the table, which the user can select. The program will then delete the records based on the ReportID from the database. I know this records because, for testing purposes, message boxes inform the user of how many records where collected.
Dim SQLDeleteData As String = "DELETE FROM ReportData WHERE (TableID = @ID)"
Dim Con As New SqlCeConnection(DataBaseCon)
Dim DeleteData As New SqlCeCommand(SQLDeleteData, Con)
Dim ReportDelete As Integer = -1
DeleteData.Parameters.Add("@ID", SqlDbType.Int).Value = CInt(ListView1.SelectedItems(0).Text)
noOfDeleted = DeleteData.ExecuteNonQuery
MsgBox("Records Data Deleted " & noOfDeleted)
When the form refreshes to show the user the possible ReportID's, the list no longer contains the recently deleted ReportID. Now this is where I am getting confused. When I go through the server explorer and look at the database there, in the appropriate tables the data still exists. Through the server explorer new query builder, I can still create a select statement to allow me to view the data I just deleted. Does the server explorer create some type of local cache that replicates the database in someway? Are there really two copies of the database somewhere?
I am trying to show the square root of the number entered in the textbox. when the user presses Q (Uppercase), the square Root should be shown (in the textbox). I did manage to get the sqaure root, but the problem is that when I press Q the Letter Q is also typed in. For example, if I enter 25 in the textbox and press Q then I get Q5 as the result. Is there any work around to this problem ? Below is the code that I have used.
Private Sub Textbox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
If e.KeyChar = Chr(81) Then '81 for Letter Q
Dim root As Double = Math.Sqrt(Val(TextBox1.Text))
[code]....
My program paste lots of stuff to a text box. Is it possible to replace every character that is not a number or a point to nothing? It may get lots of weird character there so is here way to replace them to �� and keeping numbers?
I know how to TextBox1.Text = TextBox1.Text.Replace("%", "") But its too many simbols to list, Can it be done easier?
Essentially I am trying to replicate the Windows 7 (In-Windows) activation key TextBox form. The Form where it will auto capitalize letters, remove or deny all non alphanumeric characters except dashes every 5 characters that will be auto-input.I assume this can be done with a fairly complicated replacement Regular Expression but I cannot seem to create one to fit the needs.
This is an Example of what I have right now, but it creates an infinite loop as it removes all characters including dashes, than adds a dash, which changes the text and removes the dash again.
[Code]...
I am trying to download chinese data from database to excel. But data is coming with different charecters in Excel like this Here is the my code for download excel. I don't understand what's wrong in my code.
[Code]...
Is there a way to remove 'this' item from a collection, i.e the one I'm working with, or do I always need an index?
For each ThisItem in MyCollection
if a=true then MyCollection.Remove(ThisItem)
next
[code].....
Currently I have a class that checks for apostrophes and doubles them up like this
Shared Function CheckForBadCharacters(ByVal MyString As String)
Dim finalstring As String = MyString
finalstring = Replace(finalstring, "'", "''")
Return finalstring
End Function
Works fine, of course i need to reverse this when retrieving - however is there a better way ?
[Code]...
I have a word that O want to alter. The words are numeric:123457I want to use the first two numbers and the last number. In this case it is 12 and 7.
View 2 Replieslbltime.Text.Replace(lbltime.Text, lbltime.Text.Length - 2)That does nothing, no error but it doesnt remove the last 2 characters from the string.
View 8 RepliesWhen I try to remove the last few characters of a string, I get an index out of range error. I am using the following to remove the characters from the end of the string:
objJSONStringBuilder.Remove(objJSONStringBuilder.Length - 1, 6)
The string has <hr /> at the end which I want to remove.
Removing the first 8 characters from a text string. How can I do it?
View 6 RepliesI need to parse an alphanumeric string leaving the characters "0-9", ".", "/" and space & remove everything else. I use "[^0-9./ ]" as my regex string and it works well. But now I have a couple other conditions that I dont know how to handle with my regex string. I actually only want to keep the "." character if it falls between two digit characters (ie. 3.5), otherwise remove it. And also I need to replace any "-" characters with a space if it falls between two digit characters (ie. 2-1), otherwise remove it.
View 1 RepliesIf I want to remove 2 characters, or a specific letter or character from a string in VB, how would I accomplish this?
A usual input would be
"63.0" in string format
and I want it to be
"63"
Is it possible to replace string characters using the delimiter and limit of a split function?
For example you have this string "1,1,1,1,1"
I wish to replace sentence number 2 into the string "2" between the "," character so that will be limit number 1.
So the result would be "1,2,1,1,1".
I have a situation where a user can enter just about anything they want into a text box.Whatever they enter in the box, I need to split the string into an array of strings where each item is one word. For example, if the user enters All State Insurance, I split that into a string array:
sParams(0) = "All"
sParams(1) = "State"
sParams(2) = "Insurance"
[code]....
I have a program that re-sizes items in an array but I can't get it to work. I have:
[Code]...
It gets to the Remove but it just doesn't delete the characters from the string.
I have a program where a user enters a list of numbers in the form of a string. This list of numbers is always a multiple of 8.So the list can contain 8, 16, 32, 40, 48, etc. numbers.
I need to split that string into every 8 characters.For example, say the user entered "1234123445674567"
How can I split it into a string array where (0) is "12341234" and (1) is "45674567"
Note: The size of the array has to be equal to the length of the string divided by 8.
Like this:
Dim stringArray(txtInput.Text.Length/8) as String Edit: I know I could do this by making a loop that counts 8 numbers and splits it into an array but that would be lengthy and take a few variables and I know there's a more efficient way to do it. I just don't know the syntax.
MVC 3. Vb.net. Part of my app generates PDF files using Itextsharp. Some strings are too long to go onto the background image correctly. So I basically need to split this string when its over 26 characters long and when it splits it cant split in the middle of a word. from there I will use newline to add the string to the right to the next line... I did start bulding the function that I will pass the string into test for length and then pass back the string after it finishes.
Private Function stringLength(ByVal _string As String) As String
If _string.Length < 26 Then
_string.Split(
End If
End Function
I have had a look at 2010 to see if any options have been added to
System.StringSplitOptions
and we still have;
None
or
RemoveEmptyEntries
Anyway after answering another STRING related question here.>>
[URL]
I thought about how the String.Split method works.
Often I have wanted to split a string on the characters that terminate a sentence such as a full stop >> . << ,
a question mark >> ? << or an exclamation mark >> ! << and still keep the string split characters.
[Code]....
Basically, for each character in a charArray created from the string to split, if the character is a letter, digit, or hyphen, I append it to a temporary string. When I see a split character or the last character, and the temporary string has value, I add it to the collection to return.
For i As Integer = 0 To (charArrayLength - 1)
charToInspect = CChar(charArray.GetValue(i))
If IsLetterOrDigit(charToInspect) Or charToInspect = hyphen Then
[Code].....
I am working on a site where I use the Split function on a string. To make sure I used a separator character that I do not use anywhere in the data I selected the character'£'. This worked fine in Firefox and Safari, but in IE8 I get an 'Index out of range' error, so apparently the '£' character is not handled correctly.
View 5 RepliesI have recently developed a serial port communication program to access my hardware firewall and its connected to the device via a converter usb to rs232head plugged to a rs232 to an ethernet cable. this ethernet cable then plugs into the device console port.
my program functions similar to that of TeraTerm. an opensource hyperterminal program written in C++ but i decided to do one for vb.net
Alright to cut the story short, i have successfully coded out the program to accept incomming data from the device but however, i'm also receiving ansi escape sequence along with it and i have no idea how i could implement codes to remove these. i have spend 3 weeks trying to look for vt100 emulation codes written in vb.net but i found none so far. most are written in c++. here's an image to illustrate the problem which im facing.
The image below is a screenshot taken when the i ran both the programs together. The bottom is tera term 3.1 and the top is my vb project which i made using msdn's example and improved on the codes. basically tera term was able to interpret those escape sequence and display accordingly to that of the vt100 terminal display. I have spent time reading on regular expressions using the inbuilt function regex in visual basic and tried parsing some strings but its not working. i guess its far more complex than i thought.
I am reading a text file with mostly alpha characters. the content is not really relevant but the size of each line is very important. The process I will feed this text to will require each line be no more than 50 characters. So I will pre-process the text and add line feeds to make sure that happens.I tried several VB.NET regex like ^.*$ but that doesn't really break up the lines by 50 characters. I would take the result and iterate through each match and then cut it up and write it to an object in memory. Can this be done with a single regex pass?Otherwise I will use a streamreader and on each line check the length and if <=50 write it out with a streamwriter. if >50 cut it up in sections of 50 and then use streamwriter.
A brief example of my text:
119 SMITH KATY AAAA F ZZZ X NB SX ET
MILES,200/LM450
[code]....
I got a question. I have a textfile name membership.txt and using vb2008. However my code found error when try to grab the data to an array. I use delimiter "|" to separate between each data in line to save in specific column in database.
[Code]...
I write the following
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Dim con As OleDbConnection
Dim cmd As OleDbCommand
[Code]...
I have a maskedtextbox as I want to force the user to enter only a IP address. My mask is: ### . ### . ### . ###
I have entered spaces between to dots and at both ends. This is what the user wants. I guess makes it easier to read.
However, I need to remove the spaces and have written the code below. However, I think I have done this in an over complex way. By using a char array.
And when I try to print the end result in a message box I get this 'System.char[]'
' Save all the configuration settings
Private Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim sip As String = txtSIP_IP.Text
[Code].....
Private Sub CopySelectedNodes(ByVal nodes As TreeNodeCollection)
For Each node As TreeNode In nodes
If node.Checked Then
'MessageBox.Show(node.FullPath)
Me.CopySelectedNodes(node.Nodes)
[Code] .....
This does not work, I want to loop through results so the textbox1 will be like 151,154,3,151, and I want to remove the last.
I am writing an app that writes notes, inserted by the user, to a txt file. The app saves that notes to a txt file, and when opening it reads the file and shows the already inserted notes. However, I want the user to be able to delete some of those notes...but I can't seem to do it...this is what I have:
VB
Dim file As New FileStream(data_path & "notes.txt", FileMode.Open)
Dim text As String = Nothing
Dim reader As New StreamReader(file)
[Code]....
It goes fine, but the text.Replace(value, "") line doesn't seem to work. I've also tried text.Remove(0) but it doesn't removes the line...it looks like it has no effect.
I am working on my program to read the html tags using with httprequest. When i set the timer, it connect to my site via httprequest and it will read the whole tags from the php source when I am trying to compare between <p id='mystrings1'> and the <span id="mystrings2">Enabled">.
here's what the messagebox display:
PHP
<p id='mystrings1'>user data 1</p><p id="images"> <a href="images.php?id=1">Images</a></td> | <a href="http://myhotlink.com">Link</a> </td> | <a href="delete.php?id=1">Delete</a> </td> | <span id="mystrings2">Enabled</td>
[code]....
what my program are doing is they are looking to compare the two tags between mystrings1 and mystrings2, then it display the whole tags from the php source.how i can split the whole tags when i am trying to compare with the two tags?
