I wanted to see if anyone has issues with the newer CDR Reports and importing the .csv into excel. The issue I am having is that the program it is double quoting the clid field, thus excel sees the first set of quotes and delimits them then if the CLID has a comma in the caller name it causes issues and pushes the caller last name to next column.
I am having to manually go into the DB and extract the calls and then I can import them. The CLID field already quotes the caller name, so I need to see if there is any way to modify the CDR Report program to remove any quotes first, then proceed to double quote each field. That way it would prevent double double quoting the CLID fields that contain a comma.
Thanks in advance,