When \r present in columns, the CSV files generate additional lines and not formatted correctly:
system_time,id,detection_rules,computer_name,Event.EventData.TargetFilename,image
2021-10-26 05:58:04,11,"+ Suspicious xxxx
File Created In TMP","""xxxx""",xxxx,xxxx
2021-10-26 06:55:36,11,"+ Suspicious xxxx
File Created In TMP","""xxxx""",xxxx,xxxx
This is normally the case for the column "Detection Rules".
Would it be possible to remove that \r or generate that column in a different way so that the CSVs will be created correctly?
When \r present in columns, the CSV files generate additional lines and not formatted correctly:
system_time,id,detection_rules,computer_name,Event.EventData.TargetFilename,image 2021-10-26 05:58:04,11,"+ Suspicious xxxx File Created In TMP","""xxxx""",xxxx,xxxx 2021-10-26 06:55:36,11,"+ Suspicious xxxx File Created In TMP","""xxxx""",xxxx,xxxx
This is normally the case for the column "Detection Rules". Would it be possible to remove that \r or generate that column in a different way so that the CSVs will be created correctly?