I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this:
"Andy", 4685, "requires 5" by 2" silver plate", 1132
According to CSV standard it should be:
"Andy", 4685, "requires 5"" by 2"" silver plate", 1132
How do I get this? Do I need to create a formula field for each field that potentially contains a double-quote? That would be hundreds of fields and lots of work. Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!