Thank you E.Pasma, most elegant. Solves my problem.
Thank you Rowan, I was trying to achieve it with /bin/sh (dash) On Tue, Sep 18, 2018 at 7:12 PM, E.Pasma <pasm...@concepts.nl> wrote: > > > Rowan Worth wrote: > > > > You can also filter out specific messages at the shell level: > > > > sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the > > rest with NULL' >&2) > > > > But note that the >() syntax is not a POSIX sh feature, and will not work > > in a script using a shebang of #!/bin/sh. You need to change it to > > #!/bin/bash or whatever shell you have on hand. For more info see the > > "Process Substition" section of the bash man page. > > > > If you have the ability to modify the generated SQL, presumably you could > > avoid the error by generating a NULL yourself for the missing column? > > -Rowan > I replied just before reading this. This solution may be preferred. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users