I have several reports assigned to a schedule to automate some data exports into a CSV format. Recently, I ran into an issue where a user had put carriage returns into a group description field and these carriage returns are being inserted into the CSV file. Is there a way, using SWQL, to replace these carriage returns (or ignore them entirely) when I am exporting to a CSV? It completely breaks my import process using SQL OpenRowSet and I would like to maintain using the SolarWinds Reports rather than switch to using the API for this one specific table.
Example:
SELECT ContainerID, Name, Description FROM Orion.Container
CSV Output
1,MyFirstGroup,This is my first group.
2,Hard Returns, This group's description contain's a few hard returns.
This unit test is to ensure hard returns are handled.
3,MyLastGroup,This is my last group.
Any ideas?
