Find & replace in Text file from vb.net

Question

3.00/5 (1 vote)

See more:

hi to all,

I am working with text files in desktop app(vb.net). Framework is 3.0.
I have a several(e.g. 10) text files each containing 10,000 records.
e.g.
17725534 874893829834
17725535 313554132154
17725536 981521451554
and so on.

I have another file containing 200 records called Missing.txt, from within 10 files.
e.g.
17725534 874893829834 1 st row from 1st file.
27725537 564355432154 3 rd row from 2st file.
57725564 156548545484 30 th row from 5st file.
so on till 200 records.

Now I want to check 10 files for 200 records.
Means, I will take 1 st record from Missing.txt & loop in 10 text files to find the same.

If I found any records in 10 files, either it'll deleted or replaced with zeros(0)(In same file, not in Missing.txt).
I am not able to delete the record or replace the same.
Is there ant IO function to replace particular line or to delete it..?

Thanx..

Posted 19-May-12 1:06am

Harshad-HBK

Updated 30-May-12 2:05am

v4

Add a Solution

Comments

OriginalGriff 19-May-12 7:11am

I'm a little confused as to what you are doing.
Where does notepad come into this? Are these just text files?
What constitutes a check? Is it specific text? Is the data formatted in some way, or delimited?
Perhaps a relevant code fragment would help?

Stephen Hewison 19-May-12 7:16am

I'd suggest you're doing something wrong with your Filestream approach. Using code you should be able to process all files in at most a few seconds. Try posting your code so we can see exactly what it is your doing?

Despite that, and I'm not suggesting it's the best approach. You can send key presses to any process using the SendKeys command. This would allow you to use the find and replace features of notepad.

Jαved 31-May-12 5:02am

are the records seperated by comma or space? or there is only one record on one line?

Harshad-HBK 2-Jun-12 5:29am

only one record in line...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2012-05-19T12:10:00

Your description is pretty confusing. We have no idea what you're really having a problem with, so, the generic explanation:

You have to read the file line by line to find what you're looking for. If you don't find it, write the line out to a new file.

If you do find what you're looking for, manipulate the line however appropriate, then write it to the new file.

Repeat until the end of the source file, then close the files and do whatever you wish with them.

...BTW: They're called "Text Files" not "Notepad Files".

Jαved · Answer 2 · 2012-05-30T23:05:00

Hi Harshad,
Refer this link to achieve your goal-
searching-for-line-of-one-text-file-in-another-text-file[^]

Or follow these steps-
1. read both files line by line [Link][^]
2. split each line on their white spaces [Link][^]
3. for both files, create a 2 dimensional array [Link][^]
4. compare the appropriate columns from your 2 dimensional arrays to each other and check if one contains the other [Link][^]
5. write something back to a 3rd file [Link][^]

Find & replace in Text file from vb.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0