Scan textfile word and edit it and make report in excel of editing done

Question

1.00/5 (1 vote)

See more:

is there any solution for below:

if suppose we are having lines as

"abcd defg"

and when we edit say "abcd" to "1234" and when clicked on button then one report should be generated in excel/csv saying below:

FIle name Line number Scanned word Edited word
1.txt 1 abcd 1234

What I have tried:

getting no idea for implementation.googled many search criteria but no result found as needed.

Posted 26-Jun-20 0:05am

shaileshshinde

Updated 26-Jun-20 0:40am

Add a Solution

1 solution

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)

Richard MacCutchan · Answer 1 · 2020-06-26T00:40:00

Solution 1

You have the name of the source file, so reading line by line and checking for the values to change is a fairly simple matter using the StreamReader, StreamWriter* and String classes. Similarly generating the report values and writing to a .csv file is quite straightforward.

*do not try to edit the file in place if you read line by line. You could simplify it by using ReadAllLines, and then write the results at the end of the scan.

Posted 26-Jun-20 0:40am

Richard MacCutchan

Comments

shaileshshinde 26-Jun-20 7:00am

can you please send me sample code as i am not getting idea to implement

Richard MacCutchan 26-Jun-20 8:31am

Sorry, no. This site does not provide code to order. If you had actually gone to MSDN and looked for the documentation on the classes I suggested, you would have found some sample code.

shaileshshinde 26-Jun-20 9:58am

Thanks.
I think website name says code of project.so this site is for providing code only.

Richard MacCutchan 26-Jun-20 10:14am

No that is not what it says, and it is not in any way for providing code. I suggest you carefully read Code Project Quick Answers FAQ[^].