Re: Add columns to table; insert values based on row

On Fri, 2 Nov 2018, Tim Cross wrote:

> 3. Is it really insert or update you need?

Tim,

   Update.

   It's been a long time since I did any database manipulation (I just use
the existing databases as each project needs its data) so I sometimes make
these types of mistakes.

   Your idea of manipulating a text file is a great one!

   I'll use gawk to extract the relevant fields from the text file in which
they reside (in the correct order), then use emacs keyboard macros to add
the appropriate update text to each line. Must more efficient (and less
tedious) than manually writing each line.

Thanks,

Rich