Depending on how your Excel file is set up, the least painful way might just be to do it all in Excel. Add columns in between each field, throw XML strings into those, then concatenate each row into a single cell at the end of the row and copy-paste that final column out. If you want cleaner XML (i.e. one attribute per line rather than the all the item's attributes strung together) you can add regular expressions in with your XML and parse them out later.
-Matt On Mar 1, 2011, at 1:53 PM, "Edward M. Corrado" <[email protected]> wrote: > Hello all, > > I have an excel file that I need to map to Dublin Core. I can think of > a number of ways to do this, but was wondering if anyone else who has > done it has a suggestion before I dust off my old sed/awk skills or > otherwise reinvent the wheel. I looked at Terry Reese's MarcEdit and I > probably can use that, but it looks like I'd have to intermediately > convert it to MARC. Either a windows-based program or *nix tool is > fine. > > Edward
