Thanks hick. But that's not the problem. The import will always write to stderr, it's not an error Lots of other stuff in the script and I want to be able to catch any errors in the other parts of the script.
On Tue, Sep 18, 2018 at 4:20 PM, Hick Gunter <h...@scigames.at> wrote: > When running a script from the shell, you can redirect stderr tot he null > device using 2>/dev/null or to the same destination as stdout using 2>&1. > The latter is also very useful in crontab entries, as neglecting to handle > stderr will result in an email tot he user that contains anything written > there > > -----Ursprüngliche Nachricht----- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von D Burgess > Gesendet: Dienstag, 18. September 2018 08:15 > An: sqlite-users@mailinglists.sqlite.org > Betreff: [EXTERNAL] [sqlite] shell csv import > > I have a script that loads csv into an existing table. > > I get this message on stderr for each row imported: > > "... expected 7 columns but found 6 - filling the rest with NULL" > > > We have the means to send stdout to /dev/null using the .once or .output > > Is there a way to send suppress stderr messages for a dot command? > > If not, can we have one? > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick | Software Engineer | Scientific Games International GmbH | > Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) > +43 1 80100 - 0 > > May be privileged. May be confidential. Please delete if not the addressee. > _______________________________________________ > 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