• 0

[VB.NET] Deleting string from text file


Question

9 answers to this question

Recommended Posts

  • 0
  Puggsley said:
I need to search through a .txt file and remove a specific string. Anything i've found so far deletes a specific line number, but the string could appear on any line.

Ok, this answer will work, but I'm sure there are less expensive ways to achive the desired result. That said... Load the entire file into a string (oh my!) and then do a String.Replace("OLD VALUE", "") and then save the string to the file.

If the file is small, this is not a big deal, if the file is large it can take a serious chunk of memory.

If I think of something else I'll post back.

  • 0

Thanks for the prompt reply!

Thats the best solution i could come up with as well. As for the file size, there is about 10 files, varying from 20kb to 5mb so it could be a problem. Time and memory isn't too much of an issue and if it becomes one then it is something to look at in the future, but right now its more important to get something working

How much of a problem do you think it will be?

  • 0

I think the 5mb file is a LITTLE bit of an issue, but since these days (as opposed to 1995) memory is cheap and plentiful it's not something I would freak about.

If you write your code well, when you find a better solution, you'll be able to change that small chunk of code and get better performance. (hack? oh a little)

If it was me, and I was out of time, I'd go with the original idea and then at a later date do the performance gain. I've done tech work for 20 years and dev for 15. *I* find it most important to get the job done, over having it done well. Done well is nice, but not if it's NOT done. (read that sentence carefully)

  • 0

Would it be possible to read the file just one line at a time? This way only one line will have to be in memory. There may be a way to loop this method until the end of file has been reached. Just search through each line one at a time for the string to remove it. After the line has been analyzed, unload it and load the next line.

I'm not sure how you would go about coding this, but perhaps the idea will spark something. :)

  • 0

The problem with the "line by line" is that VB opens access to the file and will allocate a chunk of memory near the size of the file in either case. This is a concern and I'm sure there is a better solution that I have stated above... at the moment I don't have one. (sorry)

EDIT:

I thought I'd make a comment here: Besides the coding issues another point of development work is to know which goals to reach for... I had a friend back in San Francisco that spent a month creating a reporting engine in VB. Considering his fee and the abilities of VB the time would have been much better spent purchasing Crystal Reports or some other engine and having a large number of reports created by the end of that first month. (of course there are arguments for creating the engine, but in this case it was a serious waste of the client's cash)

SOMETIMES getting something done quickly vs writing tight, memory and CPU light code is better. It's a case by case issue based on the information at hand and the time alotted.

Just food for thought.

Peace,

James Rose

New York City

Edited by jameswjrose
  • 0

OK, so i took the plunge and went with the original suggestion but am having real difficulties getting it to work

To make sure its nothing else in the program i created a new project and put the following code on the form load event and created a text file with the contents "Hello World" in the output folder

Dim FileContents as String
Dim objReader as System.IO.StreamReader
objReader - New StreamReader(Environment.CurrentDirectory & "\test.txt")
FileContents = objReader.ReadToEnd
objReader.Close
FileContents.Replace("Hello", "")
Dim objWriter as System.IO.StreamWriter
objWriter = New StreamWriter(Environment.CurrentDirectory & "\test.txt")
objWriter.Write(FileContents)
objWriter.Close

From watching in explorer the program seems to zero byte the file and then write exactly the same contents back again.

Any ideas would be greatly appreciated!

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Microsoft locks Windows 11 user out, shows how easy losing data from forced encryption is by Sayan Sen Back in March earlier this year, a new redesigned Microsoft Account sign-in was released with the intention to make it "more modern, simple, and secure." Microsoft also probably hopes that the revamp will help win some hearts since many dislike the Microsoft Account (MSA) quite a bit as they are forced to use the service during Windows 11 installation. Yes, signing in to the MSA is one of the several system requirements for Windows 11, and it is also the recommended way and it clearly does not like it when users opt for a Local account instead. Microsoft often highlights the benefits of an MSA as it points out the unified access users get across devices and services like Windows, Office, OneDrive, and Xbox, which can help in synchronization of files and settings for convenience. A Microsoft Account also stores the BitLocker encryption key which is crucial thing that all users who have encryption need to store securely. Back in May this year, we covered reports of users losing their data as a consequence of BitLocker key loss, and this is a real danger for many, given that Microsoft now enables automatic BitLocker encryption on Windows 11 24H2, that most users won't even be aware of. So in the case of loss of access to a Microsoft Account, an affected user can suddenly find that they have lost all their data and there may be no way to recover it according to Microsoft's terms. Such account lock-outs can happen as a Reddit user deus03690 found out. The frustrated user claims that Microsoft apparently "randomly" locked their account when they were dealing with multiple data drives. They explain: The user has good reason to be annoyed and frustrated at this, Microsoft's own official guidance about the Account lock says: "If you tried to sign in to your account and received a message that it's been locked, it's because activity associated with your account might violate our Terms of Use." The Terms of Use for MSA explain how Microsoft deals with a closed account. It states: Thus, this shows how users can be pretty much helpless if they get locked out of MSA or lose access to it. It also shows how over-reliance on cloud services on Windows 11, something which LibreOffice recently pointed out, can lead to additional data nightmares like losing all of your data due to forced BitLocker encryption that you may not even be aware of was there in the first place. The solution? Better keep your important data backed up locally on internal or external HDDs and SSDs as only cloud storage is probably not the best decision.
    • I don't know, I haven't checked what changed in previous sockets. I agree that the 1156-1155-1151 succession was suspicious, with a reduction in pin count every time. Intel could do a better job of pre-allocating pins for future use. Another hypothesis is that the internal layout of their CPUs change, like the I/O is moved from one place to another on the chip, and they need to reorganize pins rather than having circuitry go into spaghetti mode to remain compatible. I agree that if AMD is able to maintain compatibility, Intel should be able to do the same, at least by reserving pins for future use and then using those pins when a need for them arises. However, I wouldn't say that AMD's products are entirely better. Intel's I/O now slightly edges out thanks to having double the bandwidth to the chipset and dedicated Thunderbolt lanes to the CPU. It seems that they could widen their lead with the next platform. NVMe SSDs have increased the need for PCIe lanes significantly, and AM5 has been pretty underwhelming in that regard, especially because the chipset connection is so narrow and gets saturated with just 1 gen 4 SSD, leaving the other chipset connectivity (Ethernet, Wi-Fi, audio, etc) to hope for any remaining bandwidth. Otherwise motherboard manufacturers could also make more x2 M.2 slots, those would be fast enough at gen 5 speeds and possibly at gen 4 speeds too.
  • Recent Achievements

    • Week One Done
      korostelev earned a badge
      Week One Done
    • Week One Done
      rozermack875 earned a badge
      Week One Done
    • Week One Done
      oneworldtechnologies earned a badge
      Week One Done
    • Veteran
      matthiew went up a rank
      Veteran
    • Enthusiast
      Motoman26 went up a rank
      Enthusiast
  • Popular Contributors

    1. 1
      +primortal
      675
    2. 2
      ATLien_0
      264
    3. 3
      Michael Scrip
      184
    4. 4
      +FloatingFatMan
      177
    5. 5
      Steven P.
      140
  • Tell a friend

    Love Neowin? Tell a friend!