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

Open A Large Text File / Find And Replace A String

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

Way To Load A Php File And Then Search And Replace

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

Make Search And Text File And Replace It?

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

VS 2008 Search And Replace Text Of A File?

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

Open An Xml File To Search And Replace / Add Elements - Nodes?

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

Display A Large List Of Text And Search?

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

Search A Text File For "abc123" And Replace That One String With "abc456"?

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

Hex Data Search And Replace?

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

Getting A Binary Search To Work (warning:large Amounts Of Text/code)?

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

VS 2010 : Search For Strings Within Large Text Blocks (e.g. HTML Source)?

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

Exit From Search - Replace Loop

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

Function To Search And Replace A String?

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

Search All Sub Directories For A Symbol And Replace It With Another?

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

Search Record In Datagridview And Replace It With New?

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

Search / Find And Replace Function - NumericUpDown

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

Search A Textbox For Specific Text Then Replace It?

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

Using Replace Function To Replace A Character In The File?

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

Search And Replace Text With System.IO (Visual Basic)?

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

VS 2008 How To Search And Replace Words In Listbox Items

Nov 6, 2010

How to search and replace words in listbox items.

just can't seem to work it out

View 13 Replies

Function - Overload Resolution Failed For Find/replace Search?

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

Cipher/ Code Generator -Program - Search Through Textbox And Find All Of A Certain Letter (say A) And Replace It

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

Creating A Search Function To Search Through A Binary File?

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

Read Binary File And In This File Found The String And Replace It With Other One And Save The File Afterwords?

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

Large Multidimensial Array - Write A Program To Do Markov Chain But States Are Quite Large

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

Regex - Mass Search And Replace With Wildcards Or Reg Expression MyString.Length To Len(MyString)

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

Regex - Reading File Large File Very Slow?

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

Reading File Large File Very Slow

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

Search For A String And Replace With New String Program?

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

How To Get A Line From A Large File

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







Copyrights 2005-15 www.BigResource.com, All rights reserved