Find and replace a text in XML using VB.net

Question

I have a XML file. Inside the XML file where ever I find the string as ("C:\Results\test1_01") I need to replace it with ("B:\final\test1_01") and save it. Please guide me for this.

Thanks in advance,

Your question show that have done any effort or research. However, there is your answer. — Ahmad
– Ahmad, Commented Jun 22, 2011 at 11:31

Ahmad · Accepted Answer · 2011-06-22 11:30:15Z

2

       Try
            Dim fOut as StreamWriter = New StreamWriter("Output.xls")
            Using sr As StreamReader = New StreamReader("YourXMLFile.xml")
                Dim line As String
                Do
                  line = sr.ReadLine()
                fOut.WriteLine(Line.Replace("C:\Results\test1_01","B:\final\test1_01"))
                Loop Until line Is Nothing
                sr.Close()
                fOut.Close()
            End Using
        Catch E As Exception
            ' Let the user know what went wrong.
            Console.WriteLine("The file could not be read:")
            Console.WriteLine(E.Message)
        End Try

answered Jun 22, 2011 at 11:30

Ahmad

12.8k7 gold badges53 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Find and replace a text in XML using VB.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related