Hi All,
I'm attempting to make a windows batch file that reads a text file and inserts a new record for each entry: sqlite3.exe dropped.db "INSERT INTO `DropDB_log`(`date`,`ip_address`,`status`) VALUES (%DATE%,readfile('machinelist.txt'),'%STATUS%');" Right now, it does this: date,ip_address,status20160926,128.10.10.1 128.10.10.3 128.10.10.4 128.10.10.5,up I'd like this: 20160926,128.10.10.1,up 20160926,128.10.10.3,up 20160926,128.10.10.4,down 20160926,128.10.10.5,up Will the readfile + the separator command allow this kind of hackery in windows batch files? Thanks! -- ------- inum: 883510009027723 sip: jungleboo...@sip2sip.info _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users