create an xml file using a shell script

Question

I have a table with two columns

column_1 column_1
12345     12345
73255     73255
71377     71377

Now i want to create an xml like

<header>
<value>12345</value>
<value>73255</value>
<value>71377</value>
<footer>

basically i need to use a select query and put any one of the fields into the values of xml.

could you please suggest how could this be done in an easiest way? much appreciate your help.

That depends on what kind of database you have and what command-line DB client you have available. — Lukáš Lalinský
– Lukáš Lalinský, Commented Oct 22, 2009 at 10:48

ghostdog74 · Accepted Answer · 2009-10-22 11:09:13Z

1

imagine you have selected from the database and stored those columns in a file called "file"

#!/bin/bash
awk 'BEGIN{ print "<header>"}
NR>1{  print "<value>"$1"</value>" }
END{ print "<footer>"}' file

on the command line

# ./shell.sh
<header>
<value>12345</value>
<value>73255</value>
<value>71377</value>
<footer>

answered Oct 22, 2009 at 11:09

ghostdog74

346k62 gold badges264 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1