>> On Sat, May 31, 2008 at 9:48 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >>> Here's a more basic example. This is really just a shell script formatting >>> problem and it must be really simple. I'm trying to use \n as new line. The >>> result I want from the echo statement is as follows but I can't figure out >>> how to set x to get there. >>> >>> A >>> B >>> C >>> D >>> >>> >>> set x="A\nB\nC\nD"; echo $x >> >> $ x="A\nB\nC\nD"; echo -e $x >> A >> B >> C >> D > > Excellent, I knew it was something simple. > > Now one odd problem. > > When \n is properly substituted, this all works fine EXCEPT for the select > statement. > > There the "*" is somehow seen as though it was asking for a directory. If I > change the "*" to a valid field name, I get correct results. > > Command string: > > x=".read /a.sql > .schema > .tables > select * from Responses; > .dump > "; echo -e $x |sqlite3 :memory: > > Result:
Never mind; it was the variable before the echo statement. Echo -e ".read /a.sql .schema .tables select * from Responses; .dump "|sqlite3 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
