issue_comments: 1257072258

For completeness, the regex requires a bit more dark magic to capture the following lines, here is a working expression: https://regex101.com/r/rsuEcs/1

``` sqlite-utils insert /tmp/log.db log multiline.log --text --convert " import re

r = re.compile(r'^(?P<datetime>\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2})(?:\:\s)(?P<log>(.\s\s.|.*)+)', re.MULTILINE)

def convert(text): return [m.groupdict() for m in r.finditer(text)] " ```

BEGIN TRANSACTION; CREATE TABLE [log] ( [datetime] TEXT, [log] TEXT ); INSERT INTO "log" VALUES('2022-03-01T12:04:52','Here is a log message that spans multiple lines'); INSERT INTO "log" VALUES('2022-03-01T12:04:52','This is a single line'); INSERT INTO "log" VALUES('2022-03-01T12:04:52','Here is another message that spans multiple lines'); COMMIT;