PDA

View Full Version : xml file modification


DFBrews
06-30-2011, 10:52
I have a file that is in .xml format I need to edit some info in it preferably in Excel and than drop it back into .xml any ideas oh wise and all knowing tech guys?
enfield
06-30-2011, 11:00
XML is just text. Use any text editor, such as notepad.
ghettodub
06-30-2011, 11:05
you can save as to XML from Excel when you're done too
Hoosier
06-30-2011, 11:33
It is a text file. If your changes are simple, the "open in notepad, Find, change, save" method should work.

If your changes are more complex, you can find an XML editor. I know there are a number of free ones, but I don't have any personal experience with them.

http://lmgtfy.com/?q=xml+editor

H.
DFBrews
06-30-2011, 11:50
It is a text file. If your changes are simple, the "open in notepad, Find, change, save" method should work.

If your changes are more complex, you can find an XML editor. I know there are a number of free ones, but I don't have any personal experience with them.

http://lmgtfy.com/?q=xml+editor

H.

Haha love lmgtfy
on a work comp so all that stuff is locked down as freeware sharing. Posting from my phone think I got it figured it out though font did not transfer completely right so I will need to adjust. And also the file has abunch of borders and line spaces in html so I got into the source code and changed what was needed just need to fix the font and I should be gtg.
vim
06-30-2011, 13:22
Notepad (assuming Microsoft platform) seems straightforward, and for simple typo fixes it is -- but XML cares deeply about special characters (such as the ampersand), and character encodings sometimes bite. It may look good but then an XML parser down the line may puke it back out.

I'd recommend an XML editor. If you have this need now, you'll have it again. Best to have a good tool.
Hoosier
06-30-2011, 15:01
Haha love lmgtfy
on a work comp so all that stuff is locked down as freeware sharing. Posting from my phone think I got it figured it out though font did not transfer completely right so I will need to adjust. And also the file has abunch of borders and line spaces in html so I got into the source code and changed what was needed just need to fix the font and I should be gtg.

Depending on how sensitive the data you're trying to manipulate is, you might be able to find an on-line XML editor service, where you upload the file, edit it on the web, and download it. Sounds like you've got it sorted though.

Does your work prevent personal computers on their network?

H.
Storm
07-01-2011, 01:59
If you know what you're doing (i.e. can understand/read/write xml), then use a text editor. Otherwise, I'd try something else (excel perhaps or altova).