From: Michael L. <mic...@pc...> - 2010-01-25 23:11:49
|
On Tuesday 26 January 2010 09:47:53 Chigali wrote: > Benny Malengier wrote: > > "Anyway, I don't know how Excel opens xml, but I would not thing a > > spreadsheet is a good way to edit a (probably utf-8 encoded) text > > file." - Benny > > You were absolutely right. The main culprit is Excel, which embeds its own > 'stylesheet' into the xml. > Try Open Office. Don't know if it does any better, but it is FREE (Open Source). I looked at the help and I think it will also embed its own style sheet but there are xml converters so you may be able to export it without the style sheet.See: http://www.openoffice.org > I would appreciate any ideas on how best to effortlessly edit the xml. I'm > looking to move the lastname to patronym, set grouping to patronym, move > first name to last name, and call name to first name. > Most people simply use a text editor - ugly but global search and replace still works. -- ==== Michael Lightfoot Canberra, Australia OPC Merther & St Breock, Cornwall see http://www.cornwall-opc.org mic...@pc... ==== |