Xml table fields help………….. Please help! if you know xml?
I’m facing a really tricky situation here. is there a way for me change just a particular word in an xml table to another value. e.g change values of ‘bottle’ to ‘cans’. It’s a really big table about 200,000 lines and i can’t start making the changes one by one. so is there a way to select all the "bottle" in the table and change them all to "cans" within the fields?
Thanks
Well, since the xml file is basically just a text file, you could open it in a text editor.
I would use Wordpad over using Notepad, as Wordpad can open a bigger file than Notepad.
Then you can use the replace option in the edit menu.
If you are sure that there are no places where bottle is written that is not to be replaced by cans, then you could select to replace all.
If you are unsure, you will have to find the next instance of the word bottle, make sure it is the one you want to replace. Select to replace it. Find the next one, and check if it shouldebe replaced, if so replace it and find the next one, if not find the next one. Keep doing this until you get to the end of the file.
Good luck with it.