NxLog parsing issues with CSV

View thread

Deleted user

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