Search Results

You need a sql knowlegable parser to normalize the target list. It is more than just comma separated, as commas can occur in other contexts, like function calls and quoted strings. Can you do...

So, just do a:ct=0
for col in `cat file`
do
cols[$ct]=$col
(( ct++ ))
done

Load an array of 20 entries, "NULL Default_01" through "NULL Default_20". The read your file and replace the first entries in the array with column names from the file. Now, generate a query string...

In shell or some flavor of procedural SQL?