NxLog parsing issues with CSV
Hello,
I have a CSV column that has returns in it. If I try to run NxLog, it errors out saying it expected 16 columns and got 0 (for the blank lines), got 1 (when there was one entry), etc.
The configuration I have works if I open up the CSV in excel or something and replace the returns with a ; instead.
I was wondering if there was a way to do that with NxLog. Maybe something like
Exec $Message = replace($column11, "\r\n", ";");
but i cannot seem to get NxLog to run correctly because it's spitting out the errors stated above.
Any help would be great.
Thanks