How to merge data fields into a plain text file?
November 25, 2009 8:04 AM Subscribe
Is there some way to do a "mail merge" type operation on plain text, xml or html files without using a word processor?
posted by geekgirl397 to Computers & Internet (11 answers total)
I've been working on our company wiki and I want to bulk create a bunch of pages by merging certain field data from spreadsheets, csv files or other datasources into the template text files that I've created. The output should be XML or plain text.
I have a separate task where I have a simple html template that I'd like to populate with data pulled from a csv. The output needs to be standard, simple HTML (no funny MS Word markup)
I have access to MS Office, Open Office and Abiword but everything I've tried so far seems to "pollute" my files with word processor type formatting. (I am running KDE on Ubuntu 9.10, but I also have Win XP running as a virtual machine under Virtualbox - I have access to any version of the MS Office software, and obviously anything open source).
I'm sure there's some open source tool designed to merge text files. I'm not opposed to using a command line interface although I probably would prefer a GUI. My Google-fu is failing me on this one.
Any tips on how I should achieve this, or pointers to the tools I should be looking at?