Hi!
I have a bash script like this:
#!/bin/bash
OIFS=$IFS
IFS=$'\n';
sql_command=`sqlite3 -noheader /My/Path/To/DB/ex1 "select one from tbl1 WHERE
one LIKE '%this%';"`
for i in $sql_command
do
echo "$i"
done
IFS=$OIFS;
Since the column "one" consists of text with new lines in them, I am
investigating of it is possible to
set a row seperator (if that exists in sqlite) to null so I won't have any
problems with text splitting up
incorectly.
That way I could change IFS to a null value, i.e:
IFS=
and won't have broblems with new lines when looping over the results in the
"for ..." structure.
Is that somehow possible in sqlite, or are there alternatives to this?
Thanks!
Richard Taubo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
