Replace content between first and last tag from XML file

[vivek]

Hi,

I want to replace content between first and last tag from XML file.

Like below

string1
string2

I want like below
replaced string
replaced string

[gearoid]

have a look at this post - it might answer for you

Get value from a Text File and store that value in another Text file

(imported topic written by Techadmin) Hi, Below is the code, i want to get the ip address from the below code(6th line) in one text file and store it in another text file… File 1: (Get Ip address from 6th line here) <PROPERTY propname=“host” propvalue="Treats"/> <PROPERTY propname=“port” propvalue="10"/> <PROPERTY propname=“host” propvalue="172,23,34,45"/> <PROPERTY propname=“port” propvalue="123"/> <PROPERTY propname=“host” …

Or maybe this

Search for a File and Replace the content of the file

(imported topic written by waynelee91) Hi , Does anyone know how to search for a file in C:\ and replace the some part of the content in the file? Example of the content of the file as follows: Server abc Internet = 123.123.123.123 12345 I want to replace abc and 123.123.123.123 with new values. How can i go about it? Thanks!

[vivek]

Hi Gearoid,

I want to replace content from xml tag, it not fixed
ROW
this content not fixed
/ROW

I want to replace content between ROW and /ROW

[steve]

Do you know what the bad string is that needs to be replaced? If so, the second topic gearoid linked to should be what you need. You’ll read the file and output the data you want to keep using something like:

(preceding text of first "ROW%0a%0dBad string" of it & "ROW%0a%0dfixed string%0a%0d/ROW" & following text of first "/ROW" of it) of concatenation of lines of file "C:\file.txt"