Error with String Splitter (Regex) based on date and time
Hi, I’m trying to split a column that contains a log such as the one shown below. I want to split it in rows with each row containing the part of the log starting with the date/time (keeping the date/time). I’m using the following regex in the String Splitter (Regex) node but get an error Some input string(s) were missing or did not match the pattern. Played with advanced settings to no avail.
(?=\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2})regex101 shows the split and I used the above regex in Python code successfully using re.split()
Log
2025-01-23 11:45:12 - John Doe (Additional comments)
Rejected by John Doe
2025-01-22 09:56:36 - David Smith (Additional comments)
Approval request sent to David Smith - david.smith@acme.com
Any help appreciated.
Thanks.