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
