Search And Replace A Very Large File
Dec 6, 2010
I have a 133 Mb file which contains almost a million records. Currently, a user loads this file into KEdit (a great editor for working with large files) and changes occurrences of a dollar sign $ to blank and takes negative numbers represented as such with parentheses and changes that to a negative sign. That is, (5000.23) would become -5000.23. So the leading ( becomes a - and the trailing ) becomes a blank. I believe the only occurrences of ( and ) are around the numbers I want to change, so I don't have to worry about changing something that should have been left alone. Using VB.NET in Visual Studio 2008, is there a "painless" way to do this other than reading the file one record at a time and searching/replacing and writing the record out? While not really painful, I am worried about how long that will take (to run, not to code ). Is that a valid concern?
My long range goal is to automate many of the routine file preparation tasks my users do. We get an input file from 15 clients. The file can be in any format the client has chosen to give us, and it is our burden to reformat any errant fields into an acceptable format for insertion into our database.
View 2 Replies
ADVERTISEMENT
Nov 1, 2009
I would like to step through each *.txt file in a given directory, open it, find and replace all, perhaps a thousand, occurances of a given string (e.g. "00/00/00"), then close and save file, and step to next one in the directory to do the same find and replace. I've been looking at filestream classes and regular expressions but don't see a clear way to do this.
View 4 Replies
Jul 31, 2009
I've figured out a way to load a php file and then search and replace if it contains one of the following:[code]Is their a way where I can load the the php file and also load a txt which contains the string i want to replace, so the exe dont actually save the txt.Replace. This way the user of the app can define the contents of the search and replace and it wont run out of memory.
View 1 Replies
Sep 3, 2009
I got some code that im try to make search and text file and replace it. The code im using to replace it with is whatever the user entered in txtURL.text. Here is what i have
Dim strFile as String
Dim result as String
strFile = "C:\test.txt"
oRead = IO.File.OpenText(strFile)
result = Replace(oRead.ReadToEnd(), txtURL.text, "1F.php")
oRead.Close()
Is this writing it back to the file also....I think that might be the problem, not sure..
View 4 Replies
Jun 4, 2009
I have this code to search text and replace it in a file. But might it optimized?
Example:
Dim reader As StreamReader
Dim contents As String
Dim writer As StreamWriter
[Code]....
View 4 Replies
Jul 20, 2010
I am needing to open up a file, it is a kml file, and I am wanting to search for a particular line and the replace some of the lines following that.
Dim file As New System.IO.FileStream(kmlFileName, FileMode.Open, FileAccess.ReadWrite)But I don't see any means in which to actually go through the file line by line in order to search for my criteria.
View 8 Replies
Aug 4, 2009
I'm trying to have it so theres a big list of items for example:
item1
item2
item3
[Code]....
I was thinking a list box? but I'm not all too sure on how to use one. I'd like the user to be able to scroll down through the list OR use a search. How could I search the list?(Id use a textbox as what to search for and a button to search the list.)
View 9 Replies
Mar 2, 2010
I want to search a text file for "abc123" and replace that one string with "abc456". The search string will only occur once in the file.
View 2 Replies
Jun 8, 2011
Im using this code in vb.net, but works only one byte replacing. Plz, how to work many byte search and replace.I want find all F1 B6 D9 E8 C5 and replace to F7 B3 D1 E7 C4 and save. my code:Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim fullFilename As String
[Code]...
View 1 Replies
Dec 25, 2009
Couldn't think of a better title.(Background on the problem/me)Okay, so, first question/post here, so hi. Now that that's done with, the information pertinent to my problem. I'm fairly new to VB (and programming as well, aside from screwing around with C++ and learning assembler(well, attempting is the better word) god knows how many years ago), and have only seriously been programming for about under half a year, and my skill level is about at that stage. Only been using VB.Net, nothing older. Depending on the time of day and if I'm home or at school, I fluxuate between VB express and Vis Studio 08. Umm, this program I'm having trouble with was on a test that I took yesterday (took the problem home with me cause I really wanted to figure out what was wrong with it).
The stipulations of the test were:
No For->Each Loops
No using Built-In Sorting or Searching Functions
[code].....
View 4 Replies
May 3, 2012
I'm developing an app for WP7 and Win7 that will get info extracted directly from particular websites. The app will download the HTML source and parse through it to find the required strings. The strings may not have tags. note multiple instances of the string needs to be found. I've tried a few very rudimentary ways, and although they work, they are extremely slow.
View 4 Replies
Jan 16, 2010
I want to allow the user to exit out of a find - replace operation, but I also need to block input during the operation, so I was using this Declare Function BlockInput Lib "User32" (ByVal fBlockIt As Boolean) As Boolean Private Declare Function GetInputState Lib "user32" () As Int32
[Code]...
View 3 Replies
May 15, 2009
I have a VB .NET String. How can I search that string for a character string and replace it with another string?
For example:
Dim rValue As
String = sproc.ExecuteScalar()
' rValue now has the XML string <indracio fire height=23, width - 6>
/* This is the string that I want to search. Replace the words "indracio fire" with the word "lucion time"
How can I search this string for the words "indracio fire" , and replace with the word "lucion time" ?
View 1 Replies
Mar 30, 2012
I am trying to search all sub directories for a symbol and replace it with another. The code below works for a specified path but it will not search sub directories.
[Code]...
View 2 Replies
Dec 31, 2011
I am trying to find or search record from a datagridview so I could replace it with a new data from a textbox. I used the datasource.find() method the only problem is...If the my Table consist only of one Row, the find method replaces that one row everytime i insert a data. I just couldn't figure out how to datagridview works with if else statment.
View 2 Replies
Apr 6, 2011
I am writing a program and I have the Read Function all written out. I need to have the write function. I think is I copied and pasted from the Read function I wrote.
I was able to Mass edit This:
Reader.Position = (&H)
NumericUpDown281.Value = Reader.ReadInt16()
Reader.Position = (&H)
NumericUpDown280.Value = Reader.ReadInt16()
Reader.Position = (&H)
[Code] .....
And there is at least 370 NumericUpDown's. Is there any way to search/find/replace all in one instead of typing:
Find what: NumericUpDown320.Value = writer.WriteInt16()
Replace with: writer.WriteInt16(NumericUpDown320.Value)
Each individually?
The write function will only write properly this way:
writer.Position = (&H)
writer.WriteInt16(NumericUpDown66.Value)
And not this way:
writer.Position = (&H)
NumericUpDown319.Value = writer.WriteInt16()
View 4 Replies
May 21, 2010
Is there a way to look in a textbox for some text1 and then if its there, it is replaced by text2?
View 3 Replies
Jul 7, 2011
I am using replace function to replace a character in the file
sw.WriteLine(Regex.Replace(strLine, "\", Chr(13)))
This code is working fine, but now I want to replace two times and I want to use the replace function twice. Something like this, but it is not working . Can anyone tell me how to use Replace function multiple times?
sw.WriteLine(Regex.Replace(strLine, "\", Chr(13)).Replace(strLine, Chr(13), ""))
View 2 Replies
Dec 1, 2009
What is the code to replace text in a document. For exaple if my document had the text "The Dog Jumped over the fence" how would i get it to change to "The Cat Jumped over the fence"
View 3 Replies
Nov 6, 2010
How to search and replace words in listbox items.
just can't seem to work it out
View 13 Replies
Jun 15, 2012
Public Sub MyFunction()
Dim lowstring As String
lowstring = "hi"
Me.RichTextView.Find(lowstring, 0, 2)
End Sub
The above produces the error of Overload resolution failed because no accessible 'Find' can be called without a narrowing conversion:
Public Function Find(characterSet() As Char,
start As Integer, end As Integer) As Integer:
Argument matching parameter 'characterSet' narrows
from 'String' to '1-dimensional array of Char'.
Public Function Find(str As String, start As Integer,
[Code]...
View 2 Replies
Nov 25, 2008
I'm trying to make a program (in VB 2008 Express Edition) that will take text (from a textbox) and then switch the letters (say a->f and A->F) and will put the result into a second textbox when I click a button. How do I code the program so that it will search through the textbox and find all of a certain letter (say a) and replace it, then search for the next letters (say b-z) and replace them?
View 4 Replies
Jan 5, 2010
I'm creating a search function to search through a binary file and find a record based on the users input. Surprisingly, that isn't the problem! The problem I'm having is that as part of this I'm using a procedure to display results in text boxes, and I'm getting the error "Too many arguments to private sub display customer"I've encountered this error before, but never really knew what it was... Here is my code.
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
FilenameCust = "F:\College\CustomersFile.bin"
[code].....
View 4 Replies
Jan 11, 2011
i need to read binary file and in this file found the string and replace it with other one and save the file afterwords. I found many example to read binary, but to find and replace is for me mistery.
View 3 Replies
Jun 9, 2011
I want to write a program to do Markov chain, but my states are quite large. First of all I calculate all the transition probabilities and revenues for all states(1381860 total states), and store in a multidimensional array. Public RevArr(0 To 9, 0 To 750, 0 To 282) As Long
After that the iteration of markov chain should use these as inputs to calculate the steady-state probabilities. But when I try to run the main code I got this error.Exception of type 'System.OutOfMemoryException' was thrown.
The following is the declaration of second array I add just another dimension for storing all the iterations, but I get this error. Dim stateprob(IT + 1, 0 To 9, 0 To 750, 0 To 282) As single
View 1 Replies
Oct 14, 2010
I have a large ASP.NET project where I want to do a mass search and replace (about 3500 instances)
I want to change
If strErrorMessage.Length > 0
If strSomeString.Length > 0
If strWhatever.Length > 0
and any other similar call to the Length method from a string to the following
If Len(strErrorMessage) > 0
If Len(strSomeString) > 0
If Len(strWhatever) > 0
Anyway to reliably do this in one shot?
I can do a search and replace for something like If *.Length > 0 --> If Len(*) > 0
This just won't work though as it won't understand how to rearrange it properly. Currently have VS2010 and N++ at my disposal.
View 2 Replies
Aug 26, 2011
this code takes about 30 mins and high cpu usage, what is the problem
Do
strLine = objReader.ReadLine()
If strLine Is Nothing Then
[code].....
View 3 Replies
Aug 26, 2011
this code takes about 60 mins and high cpu usage for a text file of 90,000 lines, what is the problem..[code]
View 9 Replies
Apr 27, 2011
I 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.
View 4 Replies
Apr 4, 2012
The file is a UTF8 text files.
Each characters has varying number of bytes and each line has varying number of characters.
Does vb.net has table of line numbers to byte location function or something like that?
Also after that how to read that?
View 1 Replies
