Handling file full of Database SQL Statements

All,

I’ve been given a less than ideal task of monitoring a directory for a .sql file that has a list of database insert statements and processing those through Cloverleaf and put into a database. Unfortunately I do no have any way to change this input format.

My thought was to try to process this into a VRL type format, and then execute these directly into the database, however there are unfortunately newlines in the text so I cannot in split into unique “messages” correctly.

My initial thoughts on how to do this are to write a pre-proc TCL to read in the entire file and split on my known end character (not newline) and then pass each insert is as a  new message.

Any other advise on how to approach this within cloverleaf?