modify the return value of an query from mysql database

[bazziewazzie]

Hello

I'm very new to unix scripting. But this time I need to have an unix script for my X-code application for Mac OS X. I want to connect to a MySQL database wit my application. The problem is that the results of an Query is like this
+------------+--------+
| column 1 | column 2 |
+------------+--------+
| result 1 | result 3 |
| result 2 | result 4 |
+------------+--------+

I'd like to convert this to something like
{{result 1, result 3}, {result 2, result 4}}

Does anyone know how to do this?

greetings bastiaan

 

[PHV]

man awk

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244